I have a column with names, ~1000 rows, the names of the individuals shows multiple times as it is a list of PMs for all projects in my department. Is there a formula that allows to copy paste all the names into a new column, but only have the names show once?

Hopefully that is understandable^

any ADs wanna do young lions with me next year? i know it’s early but i’m eager. let’s meet up, do some spec, have some fun.

Why do people not respond to calendar invites? Come on now we can do better🙃

What random skills do you possess that can help during the pandemic? I'll go first-

I can make soap, beer and mead from home. Im gonna be drunk and clean!

Help me out - I'm starting a HedgeFund. I'm calling it ____________ Capital.

Transitioning from line of business familiarity (understanding financial statements) to... real(?) Finance (bonds and cap markets and other debt sales) any advice on books or resources to learn really from step 0?

Hi All,
I am interviewing for Google Operations Center,India for Lead role. I have total 10 years of experience.

How much salary should I ask as expectation as Google salary is in higher range.

Hello, I'm Catherine, I'm a recruiter looking to hire a Dental Hygienist $45-$50 per hour and a Front Desk/Patient Coordinator pay rate is $15-$25 per hour. In Norcross, GA. Both Full Time. Anyone interested?

Hi Fishes,
Any news of hikes in OSSI?

Hi,

Any idea about the C&SP department in comcast? working culture, WLB and all..

I was selected in Comcast for a developer role.. Will Comcast provide work from home?

so if anyone knows about that please share your thoughts.

Hi everyone

Does S&P Global revise an offer based on a counter offer?

Thanks

How does Strategy & Consulting differ from Business & Tech Integration? It appears to me, looking at the profiles of people in these different divisions, that most of the time at the Consultant-ish level, both divisions are just providing Business Analysts? What am I missing?

I’ve heard electric cars aren’t actually as clean as they make them out to be since the electricity they use is still being produced by coal-powered plants. To what extent is this true? Is the reduced environmental impact worth the investment at this point in their development?

A colleague just "shamed me" about the size of my engagement ring. My fiance is a wonderful, hardworking guy who bought me a beautiful ring. I'd take a great guy over a large ring any day.

Guys, what platform do you use to trade US stock?

Any insight on DLA Piper’s energy practice in the Northeast? Specifically, renewables.

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.

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?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

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

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

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

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.

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

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.

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

Timesaver: If you’re working on a file saved on the cloud (teams, share point, etc.) and need the URL to communicate out, tap FILE -> INFO -> COPY PATH and the url will be on your clipboard. Pre-established sharing privileges of orig folder will apply. Hopefully this saves you time reshuffling open windows! Bonus: Same on standard MS suite files.

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?

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

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 it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

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

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏