Forum Discussion
Using Formulas to search multiple columns for one criteria & generate a list
Hey all! I hope I'm able to type this in a way where it makes sense. For my job, I'm trying to fix up our list of interpreters to make it easier to navigate. There are currently three sheets: the...
mathetes hey John, not to give you a hard time but I guess you are so lazy you forgot to attach your workbook. LOL. Sry I couldn't resist the poke. But seriously, I absolutely agree with you that another format would be much more efficient so updated my sheet with a recommended format. I'm curious how closely it will match your sheet.
with MS office 365 you should have access to those functions. Make sure you have updated it. Some have their update set to manual or blocked so make sure you update.
This is what I fiered. I've a company managed computer, sa I can't force updates... This is why I provided the version# of my xlsx. Is it supposed to be ok ? What is the version@ of your xlsx ?
- I have the 'Current Channel' and have version 2301. Here is a link to what version each of the channels are presently released: https://learn.microsoft.com/en-us/officeupdates/update-history-microsoft365-apps-by-date
at version 2108 you may be "up to date" if you have a Semi-Annual Enterprise Channel.
you can also see the Features Flyer (aka.ms/ExcelFeaturesFlyer) to see features by version.- thank you for your feedback.
It should work by me as I do have a have a Semi annual Enterprise Channel ...
P.S. I was talking of your first example
