Please help: 2 line items of data is getting dropped from the source to the pivot table. The source is an excel sheet in the same workbook so I can quickly verify that the data is there. Now I’m getting REF results from my GETPIVOTDATA formulas. How do I begin to troubleshoot this?

Posting as :
works at
You are currently posting as works at

Nevermind I fixed it. Reminder to make sure you’re selecting all the rows you need when you’re setting the pivot table data source

funnylike

Alternatively, reminder to not use a pivot table :)

like

Related Posts

What is a fair salary/hourly for a kitchen manager in Tampa FL? Small kitchen with 3 to 4 kitchen assistants. Kitchen is open 50 hours a week. Manager has full creative license and has no one above them in the chain of command outside of owners.

What is this line means "Practice Proactive - A5 -Nov - 8- Selenium" It is in the mail of my Candidate id mail from Capgemini. They will onboard me before Nov-8?

like

Is it possible to make a million in any sales position? I see so many classes and books on how to be a millionaire by selling. Seems like BS.

likehelpful

Hi Fishes,
With overall 8+ IT experience and 4+ java development , how can Professional scrum master (PSM-1) certifications will help in
1. Enhancing technical profile
2. Career growth
3. For better salary package?

like

Anyone know anything about Morgan Franklin consulting in DC? Clients, pay, culture etc?

like

Second year C in Advisory making ~73k, but have a potential op to switch to Consulting (probably as a BTA). Is it worth the jump ?

like

I'm searching for job opportunities in Canada anywhere in pharmaceutical or biotechnology company from last 4 months but did not hear back much. I have used linked in, indeed and tried to find my connections as well.

I have 10 years of experience in Serum institute of India ltd in quality control department. I have studied Master's in pharmacy.

What should I do please suggest.
I have applied for so many jobs with new resume everytime as trained by employment agency. most of company required

like

Is Commonwealth Bank a good company to work for their Bangalore location?

like

Cheapest way to get accurate body fat %s?

How many of you folks have been told to return to office? Is there any way I can continue working from home?
Location-BLR

like

Are the likes of Deloitte and Accenture still hiring? Any indications of cuts due to recession fears?

Hello Everyone,

I am working as a Senior Technical Lead with 9 years of experience and planning to take up PMP certification and move towards PM as my future career. How helpful is this certification and is this the right way to continue to change my career path. Please drop you valuable comments.

Thank you

like

Ahh Fuqua's admit weekend is virtual for class incoming 2021. Great. I love rona.

like

I feel like the simple girl Hubble ended up marrying in my relationship after a crazy ex trying to sabotage my relationship and told me their story 😂, or Big and Natasha and Carrie in Sex and the City. Leave a comment if you have ever watched “The Way We Were”. None of my friends did.

like

Looking for a 2bhk flat near Koramangala and surrounding areas.

Budget - 15-25k

like

I don’t have the relieving letter as of now.. it will take some time for my current organisation to release it.. how can i ho forward with the onboarding???

like

Can anyone here familiar with FDM Group shed more light on their contracts and operations? All I know about them is that their pay is grossly under market value even as a junior developer in training. Also you are locked into a 2 year contract in which you have to pay them should you leave for a higher paying job for example.

Does this group also have a non-compete which prevents you from working a second job should you need more money?

like

Have screening interviews with Google after applying about 2-3 months ago. My contract recently ended with Meta due to restructure and reorg in the department. What is the best answer to let them know why I am no longer with Meta?

like

Anyone aware of any places in town looking for freelance or full-time copywriters?

like

Hot take: Contrary to popular opinion, ABDs are the coolest bunch of people. What do you think?

funnylike

Additional Posts in Excel Genius

What macros do y’all have set up?

like

Does xlookup take more processing power than index match or is it negligible?

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

Matching Data into Same Row

This may be simple or complicated:
I have a data set that is divided into 6 columns. I need to combine some of the rows together based off matching data.

What needs to happen is everyone with the same Bus Driver, needs to populate into the same row. Instead of the same Bus Driver being listed twice in the column.

For The names I plan on labeling them Person 1 | Person 2 | Person 3 | Person 4 | Person 5

I attached a smaller data set for an example

Post Photo
likehelpful

Geniuses can you please share some ideas/creative ways to track the following..

Case: have around 25 companies and associated info. Part of that info includes company contact point info (name, email) each company may have 1-8 contacts. Contacts change frequently. Ideally I’d like my columns to be |comp name | contact name| contact email |etc, but the issue is I need to track when people leave a company, can’t delete the data.

Rn I have 1 sheet holding comp info, another, contact info.

like

I’m using a pivot table to show how different initiatives fall under broader themes. If I’m screen sharing the pivot table w my audience and we make a live edit to one of the initiatives on the table itself, is there a way this can also change the initiative in the source data?

like

Anyone know how to delete multiple custom cell styles at once without running a macro?

Hi all!
I have a file that is full of hyperlinks to different files in another folder.
I moved the location of tbe original fil and hyperlinks stopped working.
Now I also want to move the location of the hyperlinks folder.
Is there a way of fixing the links? (File names are still the same)

like

Alternatives to Power BI for Mac users? Trying to branch out of excel. Reports aren’t too stable with excel

likefunny

How can I resize the horizontal scroll bar to only fit to my data? It goes all the way to column XFD and my data only goes to GK. Someone once had formatting that far out and now it won’t resize

likeupliftinghelpful

Anyone have thoughts on best VBA/macro training out there? I find there are so many things I could automate and need a good place to learn the basics (particularly for excel).

like

What are the most important Excel skills to have to grow in the Consulting industry?

like

What are your favorite excel macros to make you more efficient at work?

like

Hi Guys, just started a new job and they want me to build an Gannt chart in Excel. I have experience in P6... but excel seems to be a lot of work with little customization. I downloaded an app, but am still have trouble showing all the info in a zoomedout view to give leadership a high-level snapshot of a 6 to 10 month project. Does anyone have a customizable spreadsheet they can share that let's me gets into the weeds, but also shows a high level view for executives?

like

How TF do I attach the SharePoint version of a slide deck in an email? Every time I try to share, it gives me the link in the email body instead of an actual attachment to open in app. PLEASE AND THANK YOU

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

I'd like to know if anyone has ever pressed the excel help key (f1) on purpose. It is literally the most useless and obnoxious shortcut for excel. I accidentally press it 5 times a day at least.

likefunny

Is there an enhanced "sumifs" that will sum rows and columns based on two different criteria?

like

Anyone know of an Excel plugin that acts as a reference calendar for Federal Reserve holidays (and those observed)?

like

Suppose I have a table where column Aksts groups and column B lists subgroups (so there are multiple unique values in B for each unique value in A). With pivot tables or anything else, is there a quick way to just get the taxonomy for A and B? Basically the output would be a table that shows Group 1 in A with all of it's subgroups, followed by Group 2 and it's subgroups, etc.

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

Send download link to your phone

OR

Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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