PDA

View Full Version : Exclude One Name From List



Tech
2017-01-25, 08:42 PM
Hello all!

I have this range formula to get a list of names and would like to exclude the name that appears in cell L9:



=csvRange('2017 Training Records'!B3:B19)


How can this be done?

Thanks for any help

Hercules1946
2017-01-27, 02:35 PM
Have you mistyped? Cell L9 is not in the Range ... Also can you post more of the code (or all of it if possible) so we can see how your using the range ?

p45cal
2017-01-30, 11:10 AM
cross posted without links and solved elsewhere:
http://www.excelforum.com/showthread.php?t=1171309
Tech / BillyRaySpivy, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.

Why? Have a read of http://www.excelguru.ca/content.php?184