Min & Max

[pm83]

Hello!

I want a formula to find Min & Max for a certain criteria

Sample excel is attach




Thanks in Advance

[azumi]

For start, put this on J2 and copied down:
=IFERROR(VLOOKUP($I3,$A$3:$B$17,2,FALSE),"")

For End put this on K2 and copied down:
=IFERROR(LOOKUP(2;1/($A$3:$A$17=$I3);$B$3:$B$17);"")

[pm83]

This Formula is showing Error

For End put this on K2 and copied down:
=IFERROR(LOOKUP(2;1/($A$3:$A$17=$I3);$B$3:$B$17);"")

[azumi]

Sorry I'm forgot to change semicolon to commas because I'm using different system

[kvsrinivasamurthy]

ARRAY formula(Pl see note below) in I2 then drag down

Please Login or Register  to view this content.

Slight changes for J and K columns
In J3 then drag down

Please Login or Register  to view this content.

In K3 then drag down

Please Login or Register  to view this content.

[pm83]

# azumi

# kvsrinivasamurthy

Thanks to both, sure will work on it and will update you.

[pm83]

Hello
can you please show me the addition in this formula.
=IF($I3="","",IFERROR(VLOOKUP($I3,$A$3:$B$17,2,FALSE),""))
=IF($I3="","",IFERROR(LOOKUP(2,1/($A$3:$A$17=$I3),$B$3:$B$17),""))

In Data part (before) the data are not in sequence but i want that in result part(after) it shows me J as "A1" & in K as "A5"

Attachment 744972

Thank you

[CARACALLA]

H3=IFERROR(INDEX(LEFT($B$3:$B$100,1),MATCH(I3,$A$3:$A$100,0)),"")

Copy down

j3=IFERROR($H3&AGGREGATE(15,6,MID($B$3:$B$100,2,99)+0/($A$3:$A$100=$I3),1),"")

copy down

k3=IFERROR($H3&AGGREGATE(14,6,MID($B$3:$B$100,2,99)+0/($A$3:$A$100=$I3),1),"")

copy down

[kvsrinivasamurthy]

Pl see file. Formula starts from row2.

[pm83]

Thank you so much,yes this is useful for me as of now

[pm83]

Thank you so much for reply
if in data it is is in sequence A2,A3,A1,A4,A5 than the first value is taking A2 & not A1
any correction that whatever is the sequence but on applying it show value as A1 ?

[CARACALLA]

post # 8 works for you ?

[kvsrinivasamurthy]

Pl upload file with expected result and proposed data.