hey, everyone
what in your personal opinion are the best excel formulas you know and use every day, that can be useful for everyone?
hey, everyone
what in your personal opinion are the best excel formulas you know and use every day, that can be useful for everyone?
Formulas or functions?
Formula: a statement/equation written by an Excel user... I would rather comment on 2 useful functions...
A few years ago a coworker turned me on to XLOOKUP which I found more useful and easier to use than IFERROR(VLOOKUP....
I was also pleased when CONCAT came out as a shortened version of CONCATENATE. In mentioning this somewhere it was pointed to me the autocomplete function feature... type =CONC , press tab and the rest of the formula will complete to this point... =CONCAT(
If you are using XLOOKUP, then your forum profile is out-of-date - please fix this at your earliest convenience. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks