Quote:
Originally Posted by Colin Legg
Okay. An easy way to extract distinct values is to put a column heading in Row 1 of that column and then use the advanced filter to extract unique values. Extract it to a different range and the results will not contain the duplicates.
|
it is not useful to me (there is a gaps)
firstly coming number data should then after not
plz take my attachment do it for me