Excel - Find Highest Value of Text String in Group/Array (Pic) -
so head hurts trying make work after researching , through trial , error (mostly error). simple i'm missing.
i have column displays text string letters , numbers. value total of 13 characters last 2 numerical digits (i.e. 01, 02, 03, etc.). adjacent column indicate row contains largest value (based on last 2 numerical values) in group (see image).
i found similar example can't working in application (excel - find highest value of column in matching rows (with screenshot)). not sure if because of cell formatting.
please help--it appreciated!
you can array formula:
=if(numbervalue(right(a2,2))=max(if(left($a$2:$a$10,11)=left(a2,11),numbervalue(right($a$2:$a$10,2)))),true)
you need hit ctrl+shift+enter after entering formula. assumes 13-character strings 2 digits @ end.
Comments
Post a Comment