Forum Discussion
Solved
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.
Hello,
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.
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.- 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