Forum Discussion
Using Formulas to search multiple columns for one criteria & generate a list
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.
meghan1728 attached is an example showing a sample 'data' set, pulling a UNIQUE set of all languages, Data validation for drop-down, and output table of matching results. I formatted the data as a table to make it easy to expand and contract as needed.
This example is exactly what I'm looking for : I receive a file with in the first column the name (of a server) and in the next columnS the various IP this server have (the # of IPs may vary from one server name to the next one).
It is nt possible for me to regenerate the file like you did in your next exemples).
BUT
when I reselect language Dutch in cell J1, it comes with an error (#NAMe?) in cell L2 where I should see the list of persons.
It looks like you uses a library I do not have ???
Thank you for your help. (I have MS Office 365, xlsx v2108)
P.S. : sorry for my bad English, I Hope my question is clear.
- 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.