Anyone know a way to divide a list of teams and titles into groups where each group should have a max of 5 titles from teams where possible? There are teams with only 1 title and others with more than 5 titles. I tried my hand (unsuccessfully) at Solver and VBA but wondered if there was an easier method out there…

We’ve been trying to fill a cyber security architect position, but we are apparently missing the mark on our salary. We also want candidates that have AWS certifications. 100% remote. We are a consulting company. Is 180k that off base?

Found thread to gain status through match stream for all rental companies and 5 hotel chains

Was told I had to leave a Marriott hotel last night mid stay due to a fire alarm compliance issue. They credited 6k points and gave me a room at a nearby Marriott property for the night. Con’t...

Recommendations for first time to Europe?? Looking to do a trip with my parents and sister (I’m 23) hitting multiple cities.

Looking to book a quiet 4-5 day beach vacation in February. Flying from Boston with my sister, who’s never been on a beach vacation before. Which locations would you recommend? Continued.

Midweight earning 6K. Is it low or high? What should I target?

Whats the max of monthly rent has anybody shown for HRA deduction 😅

What are the chances of Onshore transfer from IQVIA Consulting Services India office to Canada? I also hold a PR to Canada! Will that help I want to apply at IQVIA Canada?

People can be terminated for requesting Work from home option due to health issues? Please share the inputs and if anyone know about the legal terms.Thank you.

My manager asked me to help sprint this proposal. I’m out in 6 weeks. How do I kindly tell him to GTFO

Single black female. Late 30s, no kids. Is it better to practice in a smaller market that’s close to major cities, lots of professional opportunities, but no real single professional scene? OR be in a bigger pond/major city with more professional and networking opportunities, oversaturated with lawyers of color, more competition for professional opportunities, but bigger dating pool?

Hey there! Can anyone recommend/ know of some nice dermatologists in Bay area who accept Kaiser insurance? Thanks in advance :)

What's a good salary in CH for a Big4 for a Manager position? What benefits can be included?

Who decides the Hike percentage in EY GDS ?

Please help me to understand if counsellor plays any role in hike percentage or is that based on Current rating we have got while VPB announcement ?

NSP- seriously what crap it is? What a waste of time. Agle 2 din aur jhelna h 😭 EY ne itna ghatiya program implement kaise kiya 🙄

I need a job😭😭😭😭😭😭😭😭

Hello Fishes,

I have 11 Years of experience in Physical Security, I presently work for BIAL(Bangalore International Airport Limited). was looking for reference for Corporate Security positions. if any one could help me in referring me for any of the positions in Corporate Security it would help me in my growth.

Thanks.

Hello folks, I have work experience of 14 years in Javascript, vue.js, python, AWS with Devops, working as a Senior technology manager currently in Finance domain. How much salary should I target in a remote only setup? Any suggestions are appreciated!

How can I copy a formula from one sheet to another?i tried the simple Ctrl+C, Ctrl-V, but the formula refers to the old sheet.

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

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

Hello. Quick question about formatting. I have an excel sheet with bunch of negative numbers, but some are percentage values and some are dollar values. Is there a way to make all of them have a parenthesis for being negative while keeping them still percentage and dollar value separately or do I have to target them separately?

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?

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.

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

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

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!

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?

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

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.

Does 2-finger touchpad scroll not work on Excel sheets anymore? I used to be able to swipe quickly on my laptop's touchpad to navigate sheets but now it doesn't work. Based on the handful of posts I've read online about it, the problem seems unresolved. Has anyone dealt with the same issue and fixed it?

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

Would anyone be willing to teach me vlookup?