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

Hi all,
Is lunch free in Societe Generale and should we pay for parking also??

How long does it take in tcs to complete the bgv? When can i know whether it is completed successfully or not?

What are some tools you use to track progress (IEP goals) for high school students? How often do you track?

How much time do you spend after regular working hours on learning and improving technicals? I feel the most challenging part for this job is not just to complete the client work but also endless learning which requires a lot commitments after work hours.

Parents- how much are you saving for your kids? Married mid 30s and family income is around 200k. We both max employer 401k. Have around 30k debt. Lcol and low mortgage. Would you pay off debt- or focus on kids savings? Oldest kid is 7 years out from college and will have some VA benefits.

Just found out my boyfriend of 3 months (talking stage was about 6 months before making it official) slept with his ex a couple times while we were talking. After we agreed to be exclusive. Without protection. I’m so crushed 😞

Hi fishes,
What Package can i ask to L&T for Data Engineer with 3 years experience. Having 12.5 offer in hand.

Your response is highly appreciated.

What’s the average compensation for an Account Executive?

What do you think is the typical pay for a design manager? Does comp stop increasing for this role after a certain number of years?

Motivation to work: non existent. 🙂🙃

3/29 Thread (General):

Do y’all get moved around from hall to hall? I’ve been moved so many times. I have 2 more years until I can retire.

Hello Fishes!

There is "Annual Flexible Compensation" compenent in the salary structure, is it paid monthly along with basic salary or as it has flexible word in the name , its given as per company's performance?

Thank you!

#creditsuisse

Tired of hearing all the "account people suck” comments on this app. Get some new material creatives.

Hi All, For B8 position having 8 years of experience in Project Manageme ,how much should someone quote and negotiate with the HR.

I am starting a 4-months internship at a company B in January. However, I just heard from a company T that they will interview me for their full time position.

Company T is paying me way more (twice) than Company B. And I like company T more. However, they want me to start working in February if I get this position. If I end up getting the offer, I will have to quit my internship at Company B, almost immediately after I begin the internship.

Is this okay?

@GSK can anyone tell me about Haleon? Good company, culture, salary/benefits? Seen some open roles and I’m curious.

Where does b8 band for SE lie ? How is the hierarchy here in natwest.

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

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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)

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

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

I’m trying to learn more about Excel functionality and there’s several simple functions that I don’t know, this is probably one. If I am color coding data, is there a way to automatically move those lines to the top or bottom of the spreadsheet once the color code for the line is made?

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

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?

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

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).

Anybody use a personal computer for work? How's your experience been, any horror stories/watch-outs?

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

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?

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.

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

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