listing 1 of value in column of multiples
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
|