Hi, I am using the max formula like max(B1:B10) to get the highest value.
but I want to look into column C as well. In Column C I have numbers, like
Column B Column C
12/05 1
12/05 3
12/9 3
12/6 2
now I want to get the max value from column B, but my look up number is 3. so basically chek out the value in column C, like how many number 3 I have and then give me max value for number 3 from column B.
Like my answer will be 12/9
Any help?
thanks in advance
but I want to look into column C as well. In Column C I have numbers, like
Column B Column C
12/05 1
12/05 3
12/9 3
12/6 2
now I want to get the max value from column B, but my look up number is 3. so basically chek out the value in column C, like how many number 3 I have and then give me max value for number 3 from column B.
Like my answer will be 12/9
Any help?
thanks in advance