How can I fix this so that the tables on the right look more aligned? First table under R, S, T rows 2,3,4,5 should look aligned with Brad Pitt. 2nd table under R,S,T rows 6,7,8,9,10 should look aligned to George Clooney. 3rd table under R,S,T rows 11,12,13,14,15,16,17 should look aligned to Matt Damon. 4th table under R,S,T, rows 18-24 should look aligned to Glen Powell.

Post Photo
like
Posting as :
works at
You are currently posting as works at

Why don’t you just do a pivot table? That way you can slice and dice your data however you’d like.

like

Pivot table here would be a better option

^this. Quick tutorial on pivot table will change your life.

The hard way is to code with IF or SUMIF

like

haha yes, I no longer use these formula in these scenarios

First things first, separate those new tables in a different part of the sheet (or in another sheet). You can then create new columns to pull the information from those tables, using =INDEX(FILTER()) and a # column (1,2,3...) to control the index for different names

Second, a pivot table here not only doesn't solve the issue but is also a very bad recommendation, practical and performance-wise.

Related Posts

Deloitte Consulting's M&A team is hiring IT M&A professionals for their Dubai office (United Arab Emirates, Middle East)

If interested, please reach out for more color

like

I'm an Accountant having 6+ YOE in India. Now looking for jobs in EU. Any advice about finding a job in EU

like

Hey y’all. I just graduated in December and I have experience in PR and marketing and want to pursue those fields in the fashion/beauty industry in NYC. Anyone know great public relations firms hiring in nyc?

like

Getting out of M&A? I am a 3rd yr at a V30 and want to get entirely out of M&A and do more licensing/media/entertainment work. Willing to take paycut and be retooled. Any idea where to begin?

like

I have over 12 years in B2B sales/sales management experience along with a graduate degree. I am wanting to shift gears and I am at a point where I can invest time in myself to learn through practical experience. The new industry I am wanting to pursue is real estate investment. I have read all the books but want some hands on experience on the property management side. How could I best leverage my skills for a role in this, and what should my expectations be for negotiation in compensation?

What's a good salary for 4.5 years of experience as a Big Data Engineer (Azure/PySpark/Databricks) in the Amsterdam/Utrecht area?

In talks with recruiters and I feel like I'm being low balled.

1.When does appraisal happens in synechron
2.What is the appraisal cycle
3.How much avg % hike

like

How did you give notice you were lateraling to people you like? Particularly if you haven't been there that long?

I'm lateraling to another firm because frankly I think the management of this one is terrible, but the people (and individual partners) I actually work with are awesome. I've only been here for about 18 months, so I imagine that short time frame will make it extra awkward 😬

like

Did anyone read the top consulting firms to work for? 😂😂😂

like

What’s the benefit of a mba if you’re already a consultant? Seems like classes are redundant and you would earn more staying in consulting

like

Does anyone have a conference phone at home that just runs on WiFi only? I don’t want to get a home phone plan but would like a conference phone....

like

Does anybody have good electric standing desk recommendations? Ideally in the $200-300 range.

like

Today's one of those rare days where I thought "this job isn't that bad." But maybe because it's Friday

like
like

I am considering moving from US to Canada within EY if my visa doesn’t work out. Joined EY TAS- OTS from MBA as a Senior last year with base of 150k. How much salary should I expect in Toronto?

What are the salary expectations for a non technical program manager in cloud? T2 city, 2 YOE. Also, what is the salary progression for this role?

likehelpful

Waiting on offer from Deloitte for Cyber Digital Identity Manager - Microsoft Azure Active Directory
7 YOE
Present TC- 130k
What is the ideal salary ask for this position and joining bonus at Deloitte ?#it

like

Thanks for coming out folks, I’m still here though 😎

Post Photo

McKinsey & Company Hi fishes, is Mckinsey Client Capability Network different from Mckinsey Digital? Also, what are the hierarchies such as analyst, senior analyst and all in CNN? McKinsey & Company

like

“We had complimenting genitalia.”

likefunny

Additional Posts in Excel Genius

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

like

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. 😂🤯

like

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

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

like

Anyone know what these badges are?

Post Photo
likefunny

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?

like

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

like

Anyone have an app or Excel spreadsheet they use to keep track of utilization? We just switched systems and our new system doesn’t give us a real time balance of our utilization rate (cont)

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

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

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

like

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

like

I am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Still don't have xlookup. #fomo

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal