Find last value in column
Hello hello i need some help. i need find last value in column be some criteria
4 DOG 950 - corect value whitch i needPHP Code:1 DOG 1000
2 ANT 800
3 CAT 900
4 DOG 950
5 ANT 750
1- criteria find all values with criteria DOG
2- show last in column value (last not biggest)
i finde this tu formulas:
but when i whrite i have hest error #N/AHTML Code:
i attach sample.
i don't whant any vba jest simple formula.
change this
={IF(ISNUMBER(G1);LOOKUP(9,99999999999999E+307;IF(Sheet3!$B$2:$B$6=E1;Sheet3!$C$2:$C$6));0)}
to this
={IF(ISNUMBER(G1);LOOKUP(9,99999999999999E+307;IF(Sheet3!$B$2:$B$6=D1;Sheet3!$C$2:$C$6));0)}
Happy with my advice? Click on the * reputation button below
Change E1 to D1 !
Oh dear what a fool I. thnx Crooza
If I understand what you want to do, this should work.
Data Range
This formula entered in E2:
=LOOKUP(2;1/(A2:A6=D2);B2:B6)
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks