What are some unique applications of conditional formatting y'all have tried? I made a pretty cool checklist that updated according to the task's completion percentage.

Can anyone invest in Roth IRA asking with 401k or is there a limit based on salary? I was told if you are making above X, you can't invest in Roth IRA. If this is true what's is X amount?

Ally bank dropping rates again. CD a good choice?

What rates are people getting for condos? I’m thinking about selling my condo (I had 3.25%) but my realtor said that the rates are so high now that if I were to buy a similarly priced place, the monthly payment would be like $800 more. I’m bad at math, so I wanted to ask here to confirm this is accurate. Mortgage is around $700k

Anyone refer for java 6 years experience for ford? Lwd 22 aug

Facing problems with working memory and long term memory while you did good previously. Any supplements/ therapy for memory retention and increasing listening absorbing skills?

Does anyone know Barclays Ib summer bonus cycle month?? Thanks in advance

I'm looking to return to the U.S. after over a decade living and working in SSA (Marcom for ecommerce startups and tech enabled nonprofits). I've been job hunting as I plan my move in the fall but haven't gotten any serious bites. Does anyone have any pointers to ease the process of transcontinental job hunting?

I am going way over budget but 1. Even s seniors have admitted some unique circumstances have happened and 2. I’m working like insane hours 3. I’m trying - I can tell by tone management is not happy with me. I’m legit trying the best I can ....

Any PR professionals here up for a quick chat?

Hey guys I also got laid off at D. 1 year experience as a BTA>S&A>CCG. Would anybody mind helping a mate out with any referrals? Would love to discuss over DM. Appreciate your help, thank you so much!

What are some good consultant recruiting agencies?

Anyone know about Vista Outdoor?

Looking for a job dojng cloud security. Which are the best and worst companies to work for? Optiv any good?

My practice got super busy after the pandemic. I have had a waitlist and been incredibly busy. It’s been stressful, but I have been grateful for business & to be helping people through a crazy time. This fall, I’ve noticed things slowing down and I don’t really know why. Has anyone else seen any similar trends (or know what might be going on)? TIA.

Hello everyone, is there any openings for designing and animation field?

Just got a freelance gig for $1250 for 2 shoot days, but they’re asking for hourly rate for prep days. Not sure what rate to give them & if I should base it on a 10 or 12 hr hourly rate. It’s LA based & content/digital production. I’m not a fan of hourly rates, but I don’t want to lose the gig or end up agreeing to less days than I actually end up working..

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?

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

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.

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!

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

Would anyone be willing to teach me vlookup?

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?

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

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.

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

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

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 🙏

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

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

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?

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?

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?