#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 61
Default Unique Values

Is there a formula or macro I can use that on 'Sheet 1' column F will give me
each unique value from column D in sheet 'Exp Data' .... in other words it
will go through and list each different input from Column D in 'Exp Data' in
Column F of 'Sheet 1'...

Any help?

Thanks!
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Unique Values

Does it have to be a formula?

I'd use data|filter|advanced filter.

Debra Dalgleish describes it he
http://contextures.com/xladvfilter01.html#FilterUR

lightbulb wrote:

Is there a formula or macro I can use that on 'Sheet 1' column F will give me
each unique value from column D in sheet 'Exp Data' .... in other words it
will go through and list each different input from Column D in 'Exp Data' in
Column F of 'Sheet 1'...

Any help?

Thanks!


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default Unique Values

Assuming your data is in Range A1:A12 - yype the hereunder suggested
Array-Formula and press CTRL+SHIFT+ENTER, at the same time, rather then just
ENTER.
DO NOT type the curly braces { }. Excel will display them automatically !
Now you are ready to copy down along col. B
=LARGE((FREQUENCY($A$1:$A$20,$A$1:$A$20)0)*($A$1: $A$21),ROW())
Micky


"lightbulb" wrote:

Is there a formula or macro I can use that on 'Sheet 1' column F will give me
each unique value from column D in sheet 'Exp Data' .... in other words it
will go through and list each different input from Column D in 'Exp Data' in
Column F of 'Sheet 1'...

Any help?

Thanks!

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Count Unique Values but not Filtered or Hidden Values Lee Excel Worksheet Functions 3 June 2nd 09 11:18 PM
Unique values Eric Excel Discussion (Misc queries) 0 February 15th 08 11:09 PM
Unique Values trumb1mj Excel Discussion (Misc queries) 3 May 30th 06 11:52 PM
Count unique values and create list based on these values vipa2000 Excel Worksheet Functions 7 August 5th 05 01:17 AM
create list of unique values from a column with repeated values? Chad Schaben Excel Worksheet Functions 1 July 8th 05 10:25 PM


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"