Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

Hi! I have 2.5 years consulting experience & 4 years industry (B2B Sales) experience. What level should I be targeting for in cloud S&O. Is IC-5 too junior?

I really wish the big law firms in Canada were as transparent about their pay and bonus scales as what we are seeing in the US. Does any Canadian firm share bonus scales??

Hello All,

How is Blackstone Project in Wipro?
Is it good to join Wipro or Capgemini. Both Final Discussion in progress.

Tech Scrum Master + Delivery Manager
Yoe - 10+

Novo: guys, there's been Labtop theft at the office before, what should we do to prevent it? Normal ppl: better security? Novo: Na, just lock up your laptops and if you don't, we'll confiscate it

Happy to inform that this bowl is now 1000+ times stronger! 1.2K members and counting! 😀

Dads with older children: while raising your children, did your children prefer their moms over you? I know some will prefer dads over moms, but I assume majority of children out there will prefer their moms over dads… I have one child and it kinda hurts to see my child always preferring the mom over me. I know I shouldn’t feel this way, but I just do. How did you cope with such issue raising your children?

I’m looking into cyro banks to bank my eggs for long term storage. Has anyone had any experience with California Cyrobank, Reprotech, or Fairfax Cyrobank?

How does a new campus hire best set themselves up for GSAP success?

Any book recommendations? Here are a couple that I've recently recommended:1) Freakonomics2) Super Freakonomics3) The Big Short4) Never Eat Alone. Please add as you see fit!

Woke up from a dream where my grandma had passed away before my grandpa and was trying to grapple with his medical care. Ended up having to sell their home and put him in a home because I couldn't get any help from my family.

Anyone else have these kinds of super realistic dreams? If so, what was it about?

2 years work experience in consulting and talent team; masters and undergraduate degree in HR, and SHRM certification. What kind of roles would I be qualified for in NYC and what would be a good salary range?

Settling a debate- is it unethical to tell your confused, alcohol detox patient (who is violent and threatening staff over liquor) that the mix of apple juice and ginger ale you are handing them is angry orchard? Yes, the pt did calm down and laughed when he learned what his mocktale really was a few days later. Yes, this is a Wisconsin hospital.

Best websites to find new jobs. LinkedIn isn’t working for me at all. Looking to relocate to Tampa

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

Alt W H

For your enemies lol

How do I easily find any cells that are hard coded vs formula? I have 10,000 rows of data and column F is supposed to be a formula based on columns C and D, without clicking into all 10k cells in column F how can I make sure formulas are there and not accidentally hand keyed over?

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

Is there a way to do a multilevel sort but keep certain rows from sorting? I’ve got a fairly involved project plan with different levels and I need to sort by the dates on certain rows but keep other rows intact

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

Hey fishies, looking for some help with the below

I have 4 lots of data categories which are assigned a code in the adjacent cell
Eg:
Cell A2= 'xyz' Cell B2 = 'w1'
Cell C2= 'ghi' Cell D2 = 'x1'
Cell E2= 'plm' Cell F2 = 'y1'
Cell G2= 'mhn' Cell H2 = 'z1'

The combination of the 'W','X','Y' and 'Z' codes identity a specific trend
I am extracting data which includes multiple combinations of these codes. What is the best way to show frequency of the codes against the category it is assigned to

How do I change line style@back to default on excel? Accidentally click on one, and now it wants to use that style every time. I just want to be able to use the ones in the typical drop down

Dear auditors, please explain how you pick samples for substantative testing.

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.