UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Create a unique list of values with a formula    
 
   
Luceze
post Jun 2 2005, 12:35 PM
Post#1


UtterAccess VIP
Posts: 2,601
Joined: 30-July 03
From: Dallas, Texas USA


I have attached an example of how to create either an ascending or descending list of unique values from a list of numeric values.
It utilizes the SMALL or LARGE functions to determine the largest or smallest value in the list.
Then combining the SMALL or LARGE functions with a COUNTIF determines the next value in the list.
Oused a two formula approach to avoid errors in the demonstration, but in the case which the cell above the start of the unique list is blank, empty, or contains text, the second formula works fine by itself.
Attached File(s)
Attached File  UniqueValuesWithFormula.zip ( 24.29K )Number of downloads: 124
 
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 12:33 PM