Filtering data in a database
It will show Beef twice if you used Beef as the top cell in the column.
Excel treats that cell in each column as a title.
Insert a row above the first Beef and try again.
If you leave it blank Excel will ask you what to do with it. Click Yes to leave
it a label cell.
Gord Dibben MS Excel MVP
On Sat, 6 Jan 2007 21:09:01 -0800, khaled shaheen
wrote:
Dears,
can you show me how to do this using my below example as when i tried to use
advanced filter with unique values it generated unaccurate results because it
displayed the first item in column A twice
Thanks
Khaled
"CLR" wrote:
Try Data Filter AdvancedFilter UniqueValues.............
Vaya con Dios,
Chuck, CABGx3
"khaled shaheen" wrote in message
...
Dears,
here below my exmple
Items Received Items
A B
Beef .....
Tuna ......
Chicken ......
Beef
Beef
etc....
i enter manualy the items received from the warehouse in column "A" and i
need to filter these items in column "B" without duplication so that
Column
"B" will only include all kinds of items i use im my shop and only items
that i received from warehouse(column "A") haven't beed received before ,
to
be displayed in column "B"
Column "B" includes only all kinds of products i have used in my shop
without regard to how many times i received these items
regards,
Khaled
|