#1
|
|||
|
|||
Matching last in a list
Hi,
I have a list of lessons that occurred like such Client Name | Date Occurred | etc. Bill | 5/25/14 Bill | 5/31/14 Tom | 4/26/14 Bill | 6/12/14 Tom | 7/13/14 I need to determine for each row whether or not it is the last lesson in a new column called "last lesson?" which can just be yes or no. Right now I've been able to do it with: =INDEX(A:B,SUMPRODUCT(MAX((A1:A5=A1)*(ROW(A1:A5))) ),B) to give me the date of the last lesson, and then another function checking that date against the date occurred but this makes excel grind to a halt as this data set has 25k rows. Is there an efficient way to do this? Thanks! |
#2
|
|||
|
|||
You could try:
=LOOKUP(2;1/(A1:A5="Bill");B1:B5) |
#3
|
|||
|
|||
I tried a few lookup functions like this before and although it worked, having each row search each other row seems to slow the sheet down so much, is there any other way?
|
#4
|
|||
|
|||
I do not think there is any better way by formula, maybe by VBA, I don't know. For me the lookup formula works absolutely fine with 25K rows.
Do you have a lot of other formulas or other things that could cause the slow down? |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mis-matching merge fields | BarbNH | Mail Merge | 8 | 01-09-2015 01:56 PM |
Record Matching | Excel | Excel | 13 | 08-21-2014 09:44 PM |
Pge numbers on pages and in TOC not matching | Marshalee | Word | 2 | 04-23-2014 10:40 AM |
Need help matching text to the Character Map | Bobosmite | Word | 1 | 07-12-2012 08:12 AM |
How to merge matching cells vertically? | Odiseh | Excel | 1 | 01-02-2010 02:41 PM |