Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

IFV recommendations in Boston anyone? A Reproductive Endocrinologist the most - but reccs on any and all members of a health team/other tips welcome. Wide and I are about to begin this journey =/

Is giving birth w/o the epidural really that crazy of a concept? People laugh at me when I say its very feasible...

What is the Protiviti senior consultant 1 salary? Also thoughts on Protiviti vs West Monroe?

How is Booz Allen cyber strategy and risk management consulting? Got a recruiter inquiry

24 yr old, 110k TC, maxing out Roth IRA and Roth 401k, no debt or large expenses. Also have ~35k sitting in a bank account. What should I do with that money?? Am I better just sitting on it for a while then watching it shrivel up in my brokerage account?

Hello Amazonians,

I am currently interviewing for Business Analyst role for Amazon, cleared 1st round which lasted for an hour. They have asked me to confirm availability for a full day. Can you please help me with what kind of interview rounds i can expect?

I received a mail stating CDP completed. Any idea what's that

Hi all,

I would like to hear out your opinions on internal salary negotiations at the back of promotion.

I'm a Business Analyst with over 10 years experience, been in the same company for the whole time, Currently, I'm below Average Industry standards by approx. 10% for my (current) role.

I have applied for internal job which is effectively one level above, meaning it would be a promotion.

I got the job, awaiting offer.

Average Industry Salary for the new role, according to online research,

Hi guys...TCS offices have opened or still wfh is there ?

Awesome bowl!! Ty

Would you accept sr cloud architect role at 185k + bonus + vested stocks (locked 4 years) from MS when you are already making 205k +50k vested bonus(locked 3 years)in current organization ?

Feeling like it’s time to move to the next opportunity. What’s some good, general networking advice?

Anyone who had a tailored 2 piece suit made from Parmar Tailors in Deira. Did you get a price reduction or pay asking? What did you agree?

Client referred me to thier mother. Has $68k coming due in cds and wants income. Money is qualified. Refuses stocks. Wants some money short term. Any ideas?

My bf has asked me to help him quit the ecigs and told me he’ll probably hide them from me but he wants me to take them. So I have for the past week. He really only keeps them in his pocket, 1 drawer

I dint feel happy when my bf proposed me for marriage.. i am not able to understand why..he is very nice guy, we have been dating for almost 4 years but honestly, in these 4 years, i never had that butterflies feelings with him never ever. Its just that we are comfortable with each other as a person thats it and we started dating.
Whats wrong with me..i am also not sure if i want marry him..

Do people think working remotely will remove some gender bias in the work place? Or impact people’s perceptions of women colleagues?

Might move from agency to a premium car brand. New position is contract, not W2. Currently making 64k , bonus, 401k, health insurance, 15 days PTO. What $$ ask would be reasonable to recoup benefits?

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

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

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?

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”

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Just created my first macro! Super proud of myself! #humblebrag

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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!

What’s the best way to compare lots of data with time stamps? I.e. you’re trying to evaluate the time different steps in a process take for multiple line items (10000 rows)

Current approach I’m doing is to subtract the times (in hh.mm.ss) from each other to get the duration of each step. Not sure if there’s an excel time stamp function that would make this easier. It’s not working well for times that were late PM and bleed into early next day AM.

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?

Any weekend or online excel course recommendations?

How do you fix microsoft excel cannot paste data error?

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?

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

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?

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