I can finally use index match. I feel like such a genius

Do you think it’s tacky to announce a 3 year relationship breakup on Facebook?

Would it be wild if I added my preferred gender pronouns to my signature? (He/his)

Influencers: how long till they die?

John Prine 😭

Please share PWC WLB and work culture experience.
Glassdoor main WLB nehi hai dekkhe phat
rahahe. 😀

I’m Elizabeth and I’m in Las Vegas. I’ve been teaching ECSE for 14 years and it’s my 18th year teaching (i taught resource for 4 years). I love my littles! Who has taught the toddler crowd?

Hello Everyone,

I am looking for referal in WIPRO,Tech Mahindra,LTI.
Skill: SAP ABAP developer with OData and Abap on Hana experience
YOE:3.4 years

Can you guys help me with referal??

Thanks and regards.

My wife's birthday is coming up in 2 weeks. She is also pregnant. Any suggestions on good and useful gift/s for her?

Hi all , iam joining barclays on November ..am I eligible for taking two weeks of marriage leave on Feb month ? When should I inform my managers after joining ? Should I inform before one month or immediately after I joined ?

Tiger Analytics has started firing their new joineers(freshers) as they don't have adequate projects. I don't know where the freshers will go as they haven't done any project as such.

This is just pathetic from organization. They are just firing people owing to failing a test of certification, for which other company gives 3 trials but they are giving only one try with negative markings

First year senior here, what kind of salary bump could I expect if I went from B4 ITS to a mid tier ITS senior role?

This week is starting horribly, and unfortunately, will end horribly too. #jan20 #dday

Looking to support a new APIA founded startup? Well look no further!

Have you ever found something online and thought "... if I buy this, what about my anniversary gift, that trip to Europe, the car I always wanted..."

Well I have and founded Okane (money in Japanese 🤑)

Okane is a free Chrome Extension that focuses on goal-based budgeting. We track your wealth and help you save for your future goals while avoiding impulse purchases, right as you shop online. ( okane.crd.co)

Lmk what you think!!

Ed Sheeran cameo: good, bad, neutral?

I’m getting frustrated with these unpaid design tests I am required to complete! Should I be water marking my design tests?

@Administrator please rename this bowl as BIG4 UK & US. So we have broader range of people join here.

If Trump’s legal team doesn’t win, is Trump gonna sue his legal team for not winning?

Anyone working at Minds + Assembly that can give me some info about it? What’s it like? Creative, work, culture, people, benefits, etc. Wise?

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

I have a filtered date data and wanted to only copy the visible cell in column A and paste it to the next column (column B) with special paste. Because it is filtered data, I could not simple copy the whole column and paste it all at once. What is the quickest way to do this? I tried to search macro online but still cannot do it right.

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 you use the SUBTOTAL feature with formulas as well? Such as IF statements

Index Match > Vlookup

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)))),"")

Does anyone know of a good excel training online (pivot tables…filters…) ? (Preferably free)

I was sent an Excel skills test to complete as part of a job interview process (through Test Genius if it matters). I've had some assessments in Excel that I've bombed, and I've aced off the top of my head. I'd like to get in a quick review before taking this assessment, but I'm worried about not being prepared. Any good resources for practice, and/or tips on what topics these assessments typically cover?

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

Looking to expand my Excel skills by learning Power Query/Power Pivot & VBA & then expand my learning towards certain programming languages (not Excel related).

I currently have access to LinkedIn Learning, but curious about Udemy and Coursera. I know about the differences between them, but content-wise, anyone have a better experience with one over the other out of three? Other recommendations?

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?

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

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