EXTRACTING UNIQUE RECORD BASED ON CONDITION
Here's a way doing it with advanced filter, assume the data starts in A4
with a header, in for instance G2 put
=AND(A5="AP",COUNTIF($B$5:B5,B5)=1)
leave G1 blank, then apply the filter, select $G$1:$G$2 as the criteria
range and select copy to another location
--
Regards,
Peo Sjoblom
"SSJ" wrote in message
...
Hello everyone!
I would like to extract unique records based on a condition. For example,
how to extract unique record from column 'B' when column 'A' has "AP" or any
other desired condition.
The data is as follows:
A B
MI 70056542
MI 70056543
AP PATRICK CUDAHY INCORPORATED
AP PATRICK CUDAHY INCORPORATED
AP SUGAR CREEK PACKING CO
AP SUGAR CREEK PACKING CO
AP VICTORYS KITCHEN
AP VICTORYS KITCHEN
AP BRIGHT CHEESE HOUSE
AP BRIGHT CHEESE HOUSE
AP CAPPOLA FOODS INC
The final result should look like this:
C
PATRICK CUDAHY INCORPORATED
SUGAR CREEK PACKING CO
VICTORYS KITCHEN
BRIGHT CHEESE HOUSE
CAPPOLA FOODS INC
Thanks
SJ
|