Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
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
 



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 01:09 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