Related Posts
Can you give like so that I can DM someone
May I know what is the notice period if one resigns in infy during the first 6 months of joining? I am a lateral resource and they hired me in June, but they have no projects related to my tech and want me to take weird roles.. seems they are hiring to increase employee count and cross training most. just looking for options..
Infosys
How is John St these days for accounts?
It’s only Wednesday. 🤬

Additional Posts in Excel Genius
New to Fishbowl?
unlock all discussions on Fishbowl.





Everything that you can do in the 2013 version you can do in the 365 version, relax.
There are a couple of useful formulas and features in the 365 version tho
Maxifs, ministro, unique, Xlookup, Ifs (finally nested IF)
These are the ones in top of my head
Apparently xlookup is better than Index Match, but I still haven’t had a chance to use it because I’m worried about compatibility for clients.
Maxifs, ministro, unique, Xlookup, Ifs (finally nested IF)
These are the ones in top of my head
You have dynamic arrays formula that are really convenient in office 365 have a look at them they do in one step what would normally take extra ones. There is a good course from Leila Gharani on this surely you have access with some of your firm knowledge.
Filter, unique ...
If you were already used to index match match or these kind of combinations the new x lookup will not change much for you