Thread: [Solved] other than number
View Single Post
 
Old 02-17-2012, 09:14 AM
gsrikanth gsrikanth is offline Windows XP Office XP
Competent Performer
 
Join Date: Dec 2011
Posts: 133
gsrikanth is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
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
Reply With Quote