Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Yay finally 🎉🎉🎉

LA is once again the City of Champions

Looking to start a rock climbing gym from scratch. Advice on finding investors?

Planning to move out to LA in the winter time. Wondering what would be good neighborhoods for me to consider. I like the beach, hiking, and going out. 25/M/gay if that matters lol. Max of 1800k/month

I’ve seen comments on here about shit ADs who change their writers lines right before presenting to CDs or sending the deck to account. On multiple occasions. Cont’d below

Guys - What is L3 senior manager in tech consulting and how does it compare to Sr manager in other big 4? The job levels are confusing

What value does CFA add if you’re on the technology and/or Risk Management side of finance? Specifically unsecured lending.

FWIW, I already have an MBA. I’m just contemplating the CFA to boost my resume.

Networking coffee chat with someone from another firm - who pays the bill? Do you each pay your own? Does the person who requested the chat pay? What’s the protocol here?

I though people would be talking about the Bill by now, do you all not care? Thoughts about the Stimulus checks? When will people get it?

any insights on working in an internal strategy role at any of the large insurance carriers? ideally would pivot to insurtech after a few years but not sure if this is the right move in the interim

Just backed out of a signed offer and I feel like shit. The new company was very delayed in issuing an offer letter (3 weeks from verbal) and approaching a month from background check. I missed kick off events and offered to visit happy hours, but they denied that request until after the start date (which had to be pushed back).

I feel I’m justified in reneging but the group lead did everything they could to recruit and move things along, so I feel bad. Here to vent.

What’s your productivity playlist? I usually toggle between koothu by anirudh ravichander or go to other extreme and listen to ms subbulakshmi! Share yours!

I will say this I love working with the students . I love getting to know them . I smile to myself when I go to work . I still feel this way after last week being asked my three different people about doing something where I told them that I was not going to do. following day I was then ambushed by admin (where I have never felt more like nothing. Following this encounter with people in charge I had an anxiety attack. This was terrible and I have no trust . TAs are mistreated. Similar story?

Some of my girlfriends moved back home so kind of feeling lonely in the city. How do you meet new people / make new friends?

Big 4 schedules be like:

1:00 pm: Meet with my senior
2:00 pm: Attend team planning meeting
3:00 pm: Have mental breakdown at desk
4:00 pm: Smile for meeting with partner

Any HR/employment lawyer here? Currently a reservist, and have a military mission in June for 15-30 days. Would my firm let go of me when I am on duty and what protection do I have?

What brand of prenatal vitamins do you use? How many months before and after pregnancy did you use it for and did you see any difference after use?

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

How do you create a lagged time series in excel? Lag of order 1 and 2

I’m copying a report into workbook but the columns don’t line up to the report is there something I can do like to make it if this column name copy here. Not sure if this makes sense. I just fell like it really manual and there has to be an easier way

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

Dear auditors, please explain how you pick samples for substantative testing.

Can someone help me with recoding surgery question into binary variables? I’d so appreciate your help! TIA

Does anyone know why negative IRR sometimes gives you a NUM error? A lot of googling and experimenting but cannot pin down what’s going on.

Is there a way to wrap your header text within access database?

I have an idea- unsure about the execution...

I have an Excel worksheet which has a table of items, i.e., a stock count of items available.

Is there a way to link this table to Microsoft forms/sharepoint whereby someone can request an 'x' amount of stock from this summary table and whatever the requestor asks for, once approved, is automatically deducted from the table of figures and the corresponding items

I appreciate that there is a lot of automation in the above. Would welcome any advice

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?

Hi! I’ve got a number thats 6 digits and I’d like to make this 4. However, everytime I do my beginning and ending zeros disappear. Any suggestions? Or how do I shorten to 4 and keep zeros

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

Would someone please explain in a simple way when to use an array? Is it for every index match formula every time?

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

Anyone know how to capture reference text (I.e. some reference of a particular word in a given cell with multiple words) within a Median(if()) formula? Usually I use the funky “*”&xyz&”*”, where xyz is the word I’m looking for, but isn’t working in this formula I have down:

=IFERROR(MEDIAN(IF(Data!$AR:$AR>0,IF(Data!$Y:$Y>0,IF(Data!$M:$AM="*"&D$345&"*",Data!$BR:$BR)))),"")