LinkBack URL
About LinkBacks
This should do your quest:
=MAX(IF($A$2:$A$42=A2,$C$2:$C$42-CODE(LEFT($B$2:$B$42,1))))=C2-CODE(LEFT($B2,1))
comfirmed with ctrl+shift+enter
Edit: note that criteria must be sorted alphabeticaly: CONP > DINP > INST > WARN
This should do your quest:
=MAX(IF($A$2:$A$42=A2,$C$2:$C$42-CODE(LEFT($B$2:$B$42,1))))=C2-CODE(LEFT($B2,1))
comfirmed with ctrl+shift+enter
Edit: note that criteria must be sorted alphabeticaly: CONP > DINP > INST > WARN
Last edited by zbor; 08-05-2010 at 06:05 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks