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?

For those of you who are based in NYC, what are you all doing for New Year’s Eve?

Best websites/apps for apartment hunting?

Is it official holdiay in Accenture today? 26th oct! Or optional

F GSB and that email. The lack of self awareness is mind blowing. 😂

Hi fellow healthcare 🐠! For those who are still on the hunt and looking to make a move, Vynamic is currently hiring experienced consultants. Great pay and benefits, outstanding work/life balance, and solid leadership team. We have offices in Philly, Boston, Durham, and London, but remote is not an issue at all. If you’re interested, DM me to learn more.

Does anyone know what AKQA New York is like in terms of product work? I heard they are more digital experiences than campaign work these days. Is that true?

Can anyone give insight on the Verizon product work there? What's the vibe and teams like in the NY studio?

Any specific city recommendations for South America? Outside of Brazil as I have already been there!

Hey,
Senior associate and manager position open at PWC AC for assurance. Anyone wants referral dm me. ( CA or CPA)

Also if you have a job id for PWC AC opening, I can refer you :)

Guys I need a help...

My last working day is 26 July and I have an offer from PWC AC Bangalore.
My HR told me that there will be permanent remote work..

So just wanted to confirm with you guys, is that true?

For internships, what tactics do you employ to recruit industry hosts?

Is it okay to share your personal documents to hr in email? There were a few companies asking me to share education, Id, photo and pan card over email? Please share ur thoughts

Which DC area Ritz is better? Pentagon City, Georgetown, or DC

Which is better Harman connected services or CGI?

Hi Fishes,
How much can a Security Engineer with 5 years of experience expect at Rakuten?
Current CTC is 16,but holding offer for 25.
Also,is it good in terms of hikes,growth opportunities?
Thanks.

Does anyone want to meet up Wednesday 9/28 or Thursday 29 in Chicago? I’m thinking 4-6 men and 4-6 women to balance it. I can help coordinate

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

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

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

Looking for a shortcut key that is the equivalent of PowePoint's Ctrl + Shift + Up/Down arrow.

Essentially a way to switch row positions w/o replacing or inserting cells...

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

Anyone know of an excel Add-in (preferably free) that lets tracking formula in a cell?

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

Thoughts on learning VBA? Is it useful in consulting? Many people argue Python is better to learn overall?

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

Is there a text to rows (instead of text to columns) trick?

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

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

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

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

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.

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