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

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

Concatenate them into 1 column then add in a simple pivot table?

like

Not quite clear on what you need. I wonder if the functions left() and right () would help you? This way you could split up those codes and use sumif() to get totals of different combinations?

like

Unclear what you are asking. Are you just trying to flag any cells that have the letter ‘w’ in it? Or are you trying to count w’s in each cell?

If the former, Maybe try =find()?

If the latter you are looking at something a bit more complex.

like

Make sure you add a check if you do use the sim if route. You want to make sure that all of the sumif() results equal the number of data points.

like

I.e w1-x1-y1-z1 has a certain meaning which I want to show in a visualisation
As well as combinations that include different numbers (assigned codes) for all w x y and z

like

We is financial individual deliver to the people's NY strategy sharing spreading yield street investment plan start here . Welcome teams groups across we provide information for the public.com

Post Photo
like

Related Posts

Is it better to register as DBA or LLC for someone starting a side hustle that may hopefully turn to a small business?

like

Which MPLS agencies have strong account leadership?

I’ve worked at a few shops and have encountered maybe 2-3 account mgrs who worked to sell good work and protect timelines. Lots of box-checking.

like

If anyone is looking for referrals at Servicetitan, hit me up.

like

Hello fishes..
Looking for corporate development/ investment analyst jobs.. Any help will be appreciated.

like

Anyone looking for a resource manager or creative recruiter?

like

Hi All,

Anyone who got retained recently in LTI, please let me know, need some help.

Hi fishes, after completing 3 months probation, after how many days we get the confirmation ? Even we get the confirmation or not ?

Got couple of openings for HR professionals in India . Middle to Senior level . IM me with your CV if keen. Thanks

likefunny

Any referal for 2 year, security engineer in global logic??

New dracena is not stoked, whats his deal?

Post Photo
like

Vail or Park City?

like

Has anyone ever flown Silver Airways? Reviews I’ve seen look horrible but the regional route I’m looking into has limited direct options.

like

Other than Airbnb, what is the best way to find month to month rental options?

like

I'm a long time user of mvelopes budgeting software, and we just got a notice that they're shutting the platform down at the end of the year.

Looking for a recommendation for an "envelope based" replacement. They suggested Every Dollar, but it doesn't handle credit cards well.

like

Good morning, hope everyone is having a great week! Does anyone have any advice on breaking into an analyst role? I am currently a Senior Customer Success Manager, with a background in Operations/Process and Project Management as well. I have always enjoyed the analysis pieces of my roles and would love to expand my skills to show how qualified for a position in data analytics. Thank you in advance for the help!

like

Is there a group for people who aren’t alcoholics, but have issues drinking? Is it rude to go to AA if you aren’t totally dependent, but it is affecting you adversely?

Any meetings for ad people in la? I find no one really understands how we work in normal aa meetings. They find it suspect when I’m at work till 10pm every night for 3 weeks.

So for those who have been with Deloitte for 3yrs and above, what is the motivation? What are the rewards? No ESPP, so what really do you get to show for the work, time and all? Kindly share, am trying to make a big decision here, thanks?

like

My dad was recently laid off from his job as a derivatives trader in NYC. He’s been down in the dumps and interested in a new career. I’m trying to help as best I can. Any suggestions/ideas/leads?

like

Any one have info on Trust Strategy and operations associate at pwc? How is the work-life, what you do etc?

like

Additional Posts in Excel Genius

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 am trying to recreate this without the numbers at the end. Any advice?

Post Photo
likehelpful

Any book recommendations on excel modeling for real world business applications?

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

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
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

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Our Data is only showing when something has changed, is there any way to make excel fill in the values?

Post Photo
like

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

like

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

After I set a print area, how do I showcase the page 1 - page x in the excel sheet and have the background be grey?

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

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

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

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.

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

How long did it take you to become good at excel? Like fast?

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

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Hi All,
Looking to automate a manual process for the client and thinking of creating macros for with VBA. Has anyone done anything similar?

In the process of learning but wanted to reach out for any tips, tricks and advice anyone may have.

Thanks I’m advance.

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