LinkBack URL
About LinkBacks
tlafferty 
Earlier post was solved:
http://www.excelforum.com/excel-2007...html?p=2762754
The problem I didn't count on was repeated ID numbers. Please see attached for a better problem description.
Earlier post was solved:
http://www.excelforum.com/excel-2007...html?p=2762754
The problem I didn't count on was repeated ID numbers. Please see attached for a better problem description.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
bump...did I do something wrong? Perhaps I should give a better explanation?
No. You just didn't wait long enough (only an hour?) for people to get home from work and eat dinner before recreation.
Ben Van Johnson
Hello Lafferty,
I am not sure I fully understood the query, because of the difference in my answer & yours.
This is what my understanding.
Look for the first instance of ID entered in A3, and display the last <>0 number from that row which is B3:R3.
In A4 it become 2nd instance, which is B12:R12
In A5, B15:R15, in A6 B4:R4, in A7 B5:R5
If so try this in B3 with CTRL+SHIFT+ENTER. then copy down
And the output i got is. 3, 2, 1, 2, 1 respectively.
=IFERROR(1/LOOKUP(2,1/INDEX(TableOfVals!$B:$R,SMALL(IF(TableOfVals!$A$3:$A$19=A3,ROW(TableOfVals!$A$3:$A$19)),COUNTIF(A$3:A3,A3)),0)),"No Number <>0")
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks