Unique Entries
Thank you.
"JMB" wrote:
This appears to work, assuming the table is in A1:A5 and this formula is
entered in cell F1, copied down until you get #NUM errors
=INDEX($A$1:$A$5,SMALL(IF(FREQUENCY(MATCH($A$1:$A$ 5,$A$1:$A$5,0),MATCH($A$1:$A$5,$A$1:$A$5,0))0,ROW ($A$1:$A$5)-ROW($A$1)+1,""),ROWS(F$1:F1)))
If you want blank cells instead of #NUM, then
=IF(ROWS(F$1:F1)SUM(($A$1:$A$5<"")/COUNTIF($A$1:$A$5,$A$1:$A$5&"")),"",INDEX($A$1:$A$ 5,SMALL(IF(FREQUENCY(MATCH($A$1:$A$5,$A$1:$A$5,0), MATCH($A$1:$A$5,$A$1:$A$5,0))0,ROW($A$1:$A$5)-ROW($A$1)+1,""),ROWS(F$1:F1))))
both formulae are array entered (Cntrl+Shift+Enter).
"SJT" wrote:
On Sheet 1 of my worksheet in column A I have a list of names to which I add
every week. Many of these are duplicates. On Sheet 2, I would like to
maintain an ongoing list of unique entries of column A from Sheet 1. Since I
would like to be able to look at both the table that has the duplicates and
also a table w/ the unique names (which will have different information), a
filter of unique entries on Sheet 1 is not an ideal solution. How can I
accomplish this?
Example:
Sheet 1
Column A
ABC Company
XYZ Company
123 Company
ABC Company
XYZ Company
Results of Sheet 2
Column A
ABC Company
XYZ Company
123 Company
Thank you in advance for your assistance.
|