Hide Duplicates from Filtered Data

[tahir573]

hello all,

dear please solve my problem i need some help in "Excel 2003"... i have filtered data with column A, now i want to remove duplicate rows in Column C from this filtered data

i.e

in Column A i have date, and in column C i have Items Sold, now i have filtered data (Column A) with Dated 1st, and i see i have sold (Column C) pen, pen, pencil, pen, eraser, pencil, copy, notebook, copy, copy, pencil.... i want to hide duplicate rows in column Cc

can anybody help me?

 

[Peter_SSs]

One way would be to use Advanced Filter instead of AutoFilter.

Set up like below.
The date of interest is in E2.
F1 must be empty
F2 contains the formula shown.

Then use Advanced Filter with the Criteria range of F1:F2.

Before applying the Advanced Filter:

Excel Workbook
	A	B	C	D	E	F
1					Date
2	Date	Other	Item		4/10/11	FALSE
3	1/10/11		eraser
4	1/10/11		pen
5	4/10/11		pencil
6	4/10/11		pen
7	4/10/11		pencil
8	4/10/11		pen
9	4/10/11		book
10	5/10/11		paper
11
Filter

After applying the Advanced Filter:

Excel Workbook
	A	B	C	D	E	F
1					Date
2	Date	Other	Item		4/10/11	FALSE
5	4/10/11		pencil
6	4/10/11		pen
9	4/10/11		book
11
Filter

If you want to try this but need more help with the Adv Filter steps, post back again.

 

[tahir573]

Thanks Peter for your reply... i have put f1:f2 in criteria rang but peter what value should i put in "list range"..

again thanks for your quick and positive reply...

 

[Peter_SSs]

Thanks Peter for your reply... i have put f1:f2 in criteria rang but peter what value should i put in "list range"..

You select the list you want to filter. So for my setup that would be A2:C10

 

[tahir573]

thanks peter... i got it, but dear i have one more problem and i have to explain you with my exact data...

i have data as below, column A (Name), Column B (MSISDN), Column C (Date) Column D (time) and Column E (Location)..

Table removed

Now First i filter by SPO Name (Column A) then Date (Column D) and then Hide duplicate locations (duplicate Rows in Column F)..

Thanking you
tahir573

 

[Peter_SSs]

Firstly, is any of that data private so that it shouldn't be shown publicly like this?
If so, post back and I will remove it.

With data like that, try this ...

1. Take off your Autofilter.

2. Insert 3 new rows at the top so your original headings and data start at row 4.

3. Fill in A1, B1 and C2 as I have below.

4. Enter your name of interest in A2, date of interest in D2

5. Select cell A4 and then press Ctrl+A (This should select all the main table)

6. Run the ASdvanced Filter. Having selected the main table, I think the range should then populate into the Adv Filter dialog but if not manually select the range or type the range address. The criteria range is now G1:G2.

Excel Workbook
	A	B	C	D	E	F	G
1	Name			Date
2							FALSE
3
4	Name	MSISDN	Dated	Date	Time	Location
Filter (2)

 

[tahir573]

Thank you so much dear Peter, you solved my problem... and yeah Peter kindly remove that data it should not publicly shown

thanks for time and consideration.. may God bless you