excel - How to select a value given a set of criteria -
i have following table , select $ products when index = max:
id product $ max? 1 1 no 2 b 2 no 3 2 no 4 c 4 no 5 d 5 no 6 3 yes 7 b 6 yes 8 c 8 yes
how results in column identified max?
regards.
upd:
the results should based on max id , not max $. sorry confusion
if need formula max
column based on max id, try next one:
=if(max(if(b:b=b2,a:a))=a2,"yes","no")
where b:b
column products, a:a
- column id.
just select d2
, enter formula in formula bar, , press ctrl+shift+enter evaluate , drag down.
note, if know exact ranges of data, can change b:b
, a:a
e.g. $b$2:$b$100
, $a$2:$a$100
Comments
Post a Comment