First off,
This is my first post at this forum. Herro everyone!
I'm generally able to Google my Excel questions and figure out how to do it, but I'm not sure what to even search for to figure this one out.
I am looking for an excel function that [in a range] will display the first occurance of data in a range of data.
I.e:
Apple
Apple
Apple
Apple
Orange
Orange
Orange
Apple
Tomato
Plum
Plum
Plum
Tomato
Orange
I would like to see:
Apple
Orange
Tomato
Plum
Is this an index function?
Thanks in advance!
You can generate a unique list by advanced filtering. If you need a dynamic formula list this array in B2
=IFERROR(INDEX(A1:A34,MATCH(0,COUNTIF($B$1:B1,A1:A34),0)),"")
and copied over a range of cells will give a list of unique values. (Presuming your data is in A1:A34)
Remember to enter an array with CTRL, SHIFT and ENTER
Sarcasm - because beating the **** out of someone is illegal.
It's slightly complicated that just INDEX
Look here:
"Relax. What is mind? No matter. What is matter? Never mind!"
Re: Looking for Excel function that displays first occurrence of data in a range of d
Advanced Filtering was exactly what I needed.Originally Posted by sweep
I couldn't get the formula you provided to do anything but display a 0.
The formula evaluated down to =IFERROR("Apple","")
edit: forgot to say Thanks!
Last edited by Murq; 03-15-2010 at 10:55 AM. Reason: Thanks.
This is great too! Thanks very much. Will study.It's slightly complicated that just INDEX
Look here:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks