A while back, a teammate asked if I could help them with a tricky Excel formula. We ended up sitting together for half an hour, going over SUMIFS, conditional formatting, and some keyboard shortcuts.
By the end, not only had we fixed the formula, but I realized how much I enjoyed showing someone else the ropes.

Hello London folk. There’s a lot of great chat about diversity in adland on fishbowl, but it’s all very US based. So I’ve just started a bowl on diversity in London specifically - 9qo8f

Doing a budget travel to London for 4 days. Took a London pass for 3 days. Any other must dos while I'm there that can fall within my budget backpacking trip?

Best Marriott hotel to stay in Amsterdam for a weekend? (For a 28 year old single male :)

Weezer fans, give me a 👍

Samsung Galaxy Note 9 or iPhone X/XS? Like the S Pen for writing but would also like to be able to send texts from iPad without keeping the phone on (I.e. iMessage). Currently have an iPhone

Any tips for someone trying to break into consulting in the GCC from the US? Applying blindly hasn't worked out. Head hunter recommendations would be great as well!

What is the best way to search for remote job openings in the IT sector in Canada provided you already have a PR and everythg is legal

The concept of Pseudomorphosis applies to most emerging changes to organizations and leadership: They are forced to comply with outdated structures dated back to Taylor.

How does underwriting compare to PIP litigation in terms of flex time (ability to stop/start work throughout day, work at 2 am if needed, etc)

For example.. in PIP Litigation I can review my suits at 2 am if needed (as a result of having a rough day or other emergency) and still be in compliance

Does Underwriting carry any time sensitive tasks?

What's the New joiner registration grace period at Accenture?can someone help me to understand.

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”

Bank error 30k in your favor. BTC… Where to start?

Just received a text from a team member stating two missionaries that traveled through Tokyo were in my classroom teaching (private school). Said they hired a company to deep clean tonight. Thoughts?

Guys... are they giving location of our choice...specially Chennai and not bangalore..?

I have submitted my background check for the new offer. One of my previous bosses I referenced and now I am trying to call and text him to inform but he’s not responding so I am worried. (Cont’d)

So what's the deal with read receipt requests? Are they timing people once they have that notification? 🙄

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.

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

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.

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

Is there any easy way to handle FedEx/ups tracking numbers? I’d like to have some formula that would just show the status in another cell.

Still don't have xlookup. #fomo

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

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?

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

Current IE here. What are some Time Motion Study Softwares that are out there and you use in your jobs?

Is there anything similar to the INDIRECT function that I can use to build a formula reference to another workbook? INDIRECT creates errors when the referenced workbook is closed..

Best way to lookup a value with multiple criteria across rows and Columns, for 3 criteria I usually do sum product. Any other tips?

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

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

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?

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

How do you fix microsoft excel cannot paste data error?