Listing data based on a referneced criteria
I am trying to identify what function(s) to use to give me the data listed
in column B if column E, I & S meets my criteria.
e.g if column E = "NAME" and column I = "Batch 1" and column S = "No", then
return the entry in column B.
so on a different worksheet I would have a list of places that met the
criteria.
Any thoughts or has anyone done anything sinilar?
Many thanks
Mick
|