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    
post Jun 2 2005, 12:35 PM

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    22nd March 2018 - 10:07 PM