How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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

1. You could filter the PV with anything that contains “red” so both red and red,blue would show up
2. Create a separate true/false column in your data for any entry that contains “red” and update your pivot

like

Related Posts

How many times a day does excel crash on you for no reason?? At least 3 for me...So frustrating

like

Send it 🚀

likefunny

What service lines, and sub service lines have the most amount of work? I'm thinking about EY specifically, but I'm interested in other firms as well.

like

What is dry ice in HCL like what kind of project it is is it good

like

ISO remote positions doing data entry, education technology, curriculum development, project management, customer support specialist. My experience is 7 years of teaching experience with 2-3 years experience of clerical work, team leadership experience, daily operations management.

like

Anyone available to review my resume/guide me through this job search? I’ve been applying places for the past 6 months and am not getting responses. Unemployment has run out and I’m starting to crumble under the pressure of bills. My experience the past 6yrs has been in smaller companies where my role was never just one thing but instead spread over multiple departments, so I’m struggling to narrow down how to convey the vast experience I do have.

like

Any trust and estate attorney openings in Texas?

like

I am trying to start a new career in programming can someone recommend me something with good salary rate and future thanks

like

Am I wrong that physicians are the millennial snowflakes of the healthcare industry?

likefunny

Hi does hsbc gives joining bonus how much salary band we can expect for gcb 5 ? This is my 3rd post on fishbowl but not a single reply I am getting ..

like

Larsen & Toubro Infotech I have given the L1 on 7th May and that was cleared and L2 given on 14th May.
Got the mail from recruiter that cleared 2nd round and will get update soon for further process.

So in how many days I can expect for HR round and further process ?
Or they can ghost me ? Can it happen in Larsen & Toubro Infotech that after clearing both rounds they won't go forward for further process ?

Thanks

like

Question about job postings. I keep seeing the same equity research associate job on linked in being reposted. Does that mean they’re still looking for candidates or is there another reason?

like

Do we have openings in gurgaon location for etl, teradata developer profile. It's urgent!

Anyone working in spain??

like

Does KPMG send you a rejection email? Did my last round last week Friday and haven’t heard back. Followed up with the recruiter and she said she’s following up with the team

like

Hey everybody, I work in Healthcare Consulting (9m of prior M&A experience) and have an upcoming PwC Deals Contracts Analytics associate interview next week, any PwC D&T/M&A folks willing to connect, share their experience and provide any insights for nailing the interview?

like
like

Hi,
Is C1 level at Capgemini equivalent to Manager grade?

like

Is there any advantage to telling a company you are interested in working for in the future where you decided to accept an offer from? Or does it not matter? I accepted an offer a week ago with a great company (Company A) that for this season in my life seems like a great fit and only strengthens what I have to offer company B down the road. Company B just sent me a request for interview and I want to keep the door open with Company B but they were just very late in extending an interview.

likehelpful

Hi @all

There are following open position. Affine

Principal Data scientist - Experience -7-10 year's
Principal Business analytics - 7-10 YOE.
Data Engineer 4-7 YOE

DM if you are interested

like

Additional Posts in Excel Genius

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

Post Photo
likehelpful

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

I’m helping my GF with excel and need help lol. She works at a hospital and is trying to make an excel schedule for doctors to reserve rooms. She wants drop downs for days of the week (column K) and also different drop down menus in column P for the reserved time slots.

Is it possible to do this with two sets of drop downs (days of week + time slots) and not use index match here? She could make 5 tables for each day of the week, but prefers one table that can be easily navigated by doctors.

Post Photo
like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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

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

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

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

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

like

Anyone know what these badges are?

Post Photo
likefunny

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

How do I compare two sheets to make sure they are identical?

like

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.

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

like

I’m calculating a bunch of totals and averages by category on one worksheet by filtering data in different categories from another worksheet. However, when I change the filters, the previously..(cont)

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

like

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

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