List of items that do not have certain values in the next column

Hello Excel Dynamo's

Looking to extract a list of the items in Col. A that do not have a 61 OR 62 in the corresponding Location column B next to it.

In this case, the answer would be 6587

There are about 200k line items. See attachment for a sample of the data.

Thank you for all ideas, large and small.

Pete

=iferror(index(a:a,aggregate(15,6,row($b$2:$b$27)/($b$2:$b$27<>61)/($b$2:$b$27<>62),rows($g$1:g1))),"")

Hi tim201110:
I placed it into F1 and copied down, it returned all the values in Col. A.

Got a plan B?

Thank you.
Pete

I apologize if I wasn't clear. I'm looking for a list of the items in column A that do not have a corresponding presence on column B that is either equal to 61, or 62.

4578 (A2:A8)does, so 4578 would not be on the list
6587 (A9:A17) does not have 61 or 62 in column B, so that will be on the list
ASOR45 (A18:A27) does have 61 and 62 present, so ASOR45 would not be on the list.

Thanks again.
Pete

Bo_Ry:

Looks super grande!! Thanks so much. And thank you tim201110 for the use of your grey matter as well.

Pete