Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2012, 09:09 AM
Colin Legg's Avatar
Colin Legg Colin Legg is offline other than number Windows 7 32bit other than number Office 2010 32bit
Expert
 
Join Date: Jan 2011
Location: UK
Posts: 369
Colin Legg will become famous soon enough
Default

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.
Reply With Quote
  #2  
Old 02-17-2012, 09:14 AM
gsrikanth gsrikanth is offline other than number Windows XP other than number Office XP
Competent Performer
other than number
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
number to text acki Excel 1 01-26-2012 07:47 AM
other than number convert to number gsrikanth Excel 1 01-09-2012 01:01 AM
number change 11 to 12 uoume Office 0 10-30-2011 06:33 PM
other than number Mailing: how to make the "page number" in Word is the same as "row number" in excel w Jamal NUMAN Word 1 09-03-2011 11:37 AM
other than number Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:11 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft