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

Has anyone quit your job without an offer from another company? I'm getting frustrated in current company and want to quit as soon as possible, everyday feels like same and i hate to work and my productivity is dropping. I have savings of 3 months of my salary. Is it a good decision to quit immediately?

like

Hope he runs in 2024 so Dems can win in a landslide

Post Photo
likeupliftingfunny

I’m applying for a job as an insurance agent with progressive and was wondering if I should disclose my ADHD and PTSD? I have all the preferred and required experience but Every time I disclose any type of disability it seems I am not considered for the position, but I NEED this job because of the benefits. Thanks Lovlies ❤️

like

Random, but valid/persistent thought.

After 2 years of a pandemic and working independently for many years, I am not feeling interviews AT ALL. There are points in the interview where I want to just say "Look! Either hire me or don't".

How can I get over this feeling? I'm over the whole "stand in the line of fire to prove how good I am" bs. Any recommendations for getting over this or possible industries to pivot into to avoid bs interview processes and ghosting?

like

Income tax return due date is in 2 days.

DM me if you want a CA's assistance and advice in filing Income tax returns and claiming refund.

~ Nominal charges involved :)

What should be my expected ctc at Frost & Sullivan ??? Current ctc 5lpa

like

Are airlines giving refunds? Or only modification of reservations? My family and I were supposed to fly in April on Royal Air Maroc, the website says they will only allow a 6 month travel voucher....

like

When asked,do you disclose your current rate in an interview? Are you required to provide evidence? What is the norm? Thanks!!!

like

Do Federal consulting firms value MBAs or specialized Masters degrees more? Interested in the earnings potential from MBA that is often touted, can’t help but think that it is less applicable in Fed.

like

Thinking of getting the semicolon tattoo as a reminder to myself of my growth, but at the same time I am afraid that if seen on the job I will get questions I do not want to answer

I'd want it (cont)

likehelpful

Salary range for Technical Lead I QA in Citiustech??

like

What happened to Huge’s recruiting department? They seem to have really lost their touch.

Hello Guys,

Which one to choose KPMG Global Services (Pune) or EY GDS (Mumbai) for Salesforce, better yearly hike, work life balance, work culture, Experience , onsite.
Skill: Salesforce
YoE-6

like

Hi,
Which portal to login using my reference number to check candidature status?
Please provide the link

like

I have a chance to accept a job in an area of law I love, but it doesn't pay high. My financial situation has suddenly changed very drastically. I need to make 30k more than what the job pays. Really want the job, but I also don't want to be able to not make rent. This is terrible.

like

Never had anxiety before law school and it has gotten progressively worse as I graduated, passed the bar, started working. Now it's at the point where it's hard to get myself to work some days. Anyone have any experience with therapy/a psychiatrist? I'm starting to realize effects on my physical health and performance at work and desperately want to feel better.

like

Hi Sharks Need your kind suggestion having 10 days left to join IBM : 30 LPA fixed Oracle : 28 LPA +1 jb SAP : 28 LPA + 1l jb SAP IBM Oracle

like

#copied

when a junior dev is invited to a meeting with higher ups and he speaks 😅🤣

Post Photo
likefunny

Just now I got offer from Walmart. I asked 27 lpa as base pay but they released offer letter with 23 lpa as base pay and hr didn't called me to discuss. May I know is there any way to negotiate now and also can i negotiate here because without discussion they released offer ,ideally they should send the salary break before releasing it.Walmart

like

Any ID attorneys get their CPCU? Trying to make myself more marketable as claims counsel or in-house for a carrier (not doing ID).

like

Additional Posts in Excel Genius

Do you still use index match? Is it (Always) Possible to switch to xlookup?

like

I can finally use index match. I feel like such a genius

likeupliftingfunny

How do you calculate the “rate of change” within excel? I am comparing the number of bugs from one week to another.

like

Does anyone know if Excel is compatable with Adobe Sign/PDF? I'm trying to automate data entry from Adobe sign/PDF to an Excel sheet. Adobe

like

Hi, in my excel pivot table slicer I have my options and then (blanks) option , anyway to get rid of that?

I’m looking to make a supplier list where I can just filter on certain requirements to get a smaller list…currently creating as a pivot table but is there any other options that make sense?

Post Photo
like

How do you create a lagged time series in excel? Lag of order 1 and 2

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

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

like

I’m trying to consolidated planning of FTEs from weeks to fiscal periods in a new table. If my column heading in the original table is 1, 2, 3 etc and my new table is Period 1, Period 2 etc
What is the most efficient formula to do this? Just doing =sum(Hours!E7:H7) for each period will take forever… thank you!!

like

How would I create subtotal rows in a table? A true table, I dont want to turn my table into a range because I need the other sorting features.

likehelpful

Anyone know why my wildcards * are not working consistently in sumifs? If I combine multiple sumifs in one formula using + the wildcard only works in some parts. In other parts I need to specify the exact full text which makes my formula lengthier than needed. For example, "app*" isn't picking up "application" and "apple" so I need two separate sumifs to pick up these two.

like

I'm stumped!
Coworker creates "Sheet A" with invoice numbers
I use Monarch to extract invoice #'s and amounts from another report.
I do a pivot table to compile amounts by invoice. I copy those results to "Sheet Z".
I then do an @vlookup on Sheet A referencing Sheet Z (just the invoice # and amount).
It isn't working unless I go to Sheet Z and type over the invoice # (same number)! All invoice #'s are absolute and in the same font & alignment. Workbook has 10 yrs data. Has worked in past!

like

Having problems converting pdf files to excel? I can work on that. Just let me know. :)

likefunnyuplifting

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

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

Hello All,
Excel help please. I’m trying to combine 3 tabs into 1. So on tabs a,b,c I have wire instructions that go to different places, but they all have the same field names/format. However the number of rows for each tab will vary from day to day. I need to make a fourth tab that shows all the rows from a,b,c consecutively. Because the number of rows change, I can’t find the best way to collate all the rows into one table. I can use a macro or lookups or a source formula. Please advise!
Mo

like

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

Hi Gang, I have voluminous pdf bank statements that I want to convert to excel with the formatting. What’s the easiest way out?

like

My Goal: I have a drop down menu in a cell. I want it to sort conditionally based on what I select. Is that possible?
Ex: If the drop down ="done" it falls to the bottom of the list.

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

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