Filter Data
 

I have a database w/ column headers and I want to filter the data based on
unique entries in the first column. For example rows 2 & 3 have the same
client name in column A but different product and price information in
columns b & c. I would like the result to be that row 3 doesn't show up in
my results because the client name is the same even though the information in
the other columns is different. How would I accomplish this? Thank you in
advance for your assistance.

Filter Data
 

Use the Advanced Filter to filter on unique values.

Goto DataFilterAdvanced Filter
Fill in the info

To "unfilter"
Goto DataFilterShow All

Biff

"SJT" wrote in message
...
I have a database w/ column headers and I want to filter the data based on
unique entries in the first column. For example rows 2 & 3 have the same
client name in column A but different product and price information in
columns b & c. I would like the result to be that row 3 doesn't show up
in
my results because the client name is the same even though the information
in
the other columns is different. How would I accomplish this? Thank you
in
advance for your assistance.