View Full Version : Exclude One Name From List

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

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 ?

2017-01-30, 11:10 AM
cross posted without links and solved elsewhere:
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