Hi,
is there a way of listing 1 of items that may be be in multiples in a column?
example:

Column A Column B
1234 £5000
5644 £7600
1234 £5000
1234 £5000
6875 £7800

i have column a listed via data validation so the sum next to it will always
read the same as any matching figure in the column. i only want it to list
the number once giving me:
1234 £5000
5644 £7600
6875 £7800

thanks in advance

NS

Use Advanced filtering:

Pull-down:
Data Filter Advanced Filter€¦

Click copy to another location
Click List range, clear it, and highlight your table
Clear Criteria range or leave it blank
Click Copy to and select an un-used area in the worksheet
Click unique records only

--
Gary''s Student


"Nigel" wrote:

Hi,
is there a way of listing 1 of items that may be be in multiples in a column?
example:

Column A Column B
1234 £5000
5644 £7600
1234 £5000
1234 £5000
6875 £7800

i have column a listed via data validation so the sum next to it will always
read the same as any matching figure in the column. i only want it to list
the number once giving me:
1234 £5000
5644 £7600
6875 £7800

thanks in advance

NS

C1: = A1
C2: =IF(ISERROR(MATCH(0,COUNTIF(C$1:C1,$A$1:$A$20&""), 0)),"",
INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH( 0,COUNTIF(C$1:C1,$A$1:$A$2
0&""),0)))

which is an array formula, so commit with Ctrl-Shift-Enter, and copy doun

D1: = IF(C1="","",INDEX(B:B,MATCH(C1,A:A,0)))

and copy down

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nigel" wrote in message
...
Hi,
is there a way of listing 1 of items that may be be in multiples in a
column?
example:

Column A Column B
1234 £5000
5644 £7600
1234 £5000
1234 £5000
6875 £7800

i have column a listed via data validation so the sum next to it will
always
read the same as any matching figure in the column. i only want it to list
the number once giving me:
1234 £5000
5644 £7600
6875 £7800

thanks in advance

NS