Related Posts
Can I get 11 likes to unlock DM, please?
Do you work alone or with a team?
Additional Posts in Consulting
If money were no issue, what would you be doing?
National Debt now over $60,000 per citizen. 😱
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Rising Star
Alt + F4
Madman
Index match, if error, concatenate
Index match match, to go across columns and rows!
Indirect. I ❤️ named ranges.
Thanks so much!
Literally concat and text to columns are my lifesavers some days
It used to be Power Query, but I do love me some text to columns
Xlookup (I know, basic) but it's so much faster than vlookup.
Alt+Ctrl+delete
Pro
Substitute, trim doesn’t work 100% of the time as I unfortunately found out
Pro
OW1, I learned last week that trim won’t remove spaces between words it will only remove excess spaces. Substitute was the simplest solution substituting “” for “ “
Who uses excel lol
Rising Star
yeah wtf kind of take is this lol. i UsE pYtHon AnD R bEcAuSe I’m tOo gOod foR eXcel 🤡
Rising Star
SUMPRODUCT as tool for counting with more complex logical criteria
F1
Round
Ifna