|
Conditional MAX
Hello
In COLUMN C from ROW 27 until ROW 64 I have numbers. In cell C5 =IF(C64=MAX(C60:C64),C64,""). What do I have to do when I have a new number in C65 and I like to have the same result in C5 =IF(C65=MAX(C61:C65),C65,"") without everytime fixing my formula in C5? -- Many thanks for your help in advance. Have a wonderful day! Zsolt |
Conditional MAX
Try
=IF(LOOKUP(10^10,C:C)=MAX(C60:C5000),LOOKUP(10^10, C:C),"") -- __________________________________ HTH Bob "Zsolt Szabó" wrote in message ... Hello In COLUMN C from ROW 27 until ROW 64 I have numbers. In cell C5 =IF(C64=MAX(C60:C64),C64,""). What do I have to do when I have a new number in C65 and I like to have the same result in C5 =IF(C65=MAX(C61:C65),C65,"") without everytime fixing my formula in C5? -- Many thanks for your help in advance. Have a wonderful day! Zsolt |
Conditional MAX
Bob,
Thanks your help. C5 = HH5 ( The last entered number is the highest from the last 5 entered numbers). If I type into cell C65 5, C66 1, C67 2, C68 3, C69 3.5, C70 4, than from the last 5 enterd numbers the last one is the highest and your formula result is "". I like to see as a result the 4. -- Many thanks for your help in advance. Have a wonderful day! Zsolt "Bob Phillips" wrote: Try =IF(LOOKUP(10^10,C:C)=MAX(C60:C5000),LOOKUP(10^10, C:C),"") -- __________________________________ HTH Bob "Zsolt Szabó" wrote in message ... Hello In COLUMN C from ROW 27 until ROW 64 I have numbers. In cell C5 =IF(C64=MAX(C60:C64),C64,""). What do I have to do when I have a new number in C65 and I like to have the same result in C5 =IF(C65=MAX(C61:C65),C65,"") without everytime fixing my formula in C5? -- Many thanks for your help in advance. Have a wonderful day! Zsolt |
Conditional MAX
I thought you wanted to check all the numbers, are you saying that you only
want to check the last 5? -- __________________________________ HTH Bob "Zsolt Szabó" wrote in message ... Bob, Thanks your help. C5 = HH5 ( The last entered number is the highest from the last 5 entered numbers). If I type into cell C65 5, C66 1, C67 2, C68 3, C69 3.5, C70 4, than from the last 5 enterd numbers the last one is the highest and your formula result is "". I like to see as a result the 4. -- Many thanks for your help in advance. Have a wonderful day! Zsolt "Bob Phillips" wrote: Try =IF(LOOKUP(10^10,C:C)=MAX(C60:C5000),LOOKUP(10^10, C:C),"") -- __________________________________ HTH Bob "Zsolt Szabó" wrote in message ... Hello In COLUMN C from ROW 27 until ROW 64 I have numbers. In cell C5 =IF(C64=MAX(C60:C64),C64,""). What do I have to do when I have a new number in C65 and I like to have the same result in C5 =IF(C65=MAX(C61:C65),C65,"") without everytime fixing my formula in C5? -- Many thanks for your help in advance. Have a wonderful day! Zsolt |
Conditional MAX
Yes, I like to check only the last 5 numbers and I would like to see the
result in C5 IF the last entered number is the highest compare to the last 5 entered numbers. -- Many thanks for your help in advance. Have a wonderful day! Zsolt "Bob Phillips" wrote: I thought you wanted to check all the numbers, are you saying that you only want to check the last 5? -- __________________________________ HTH Bob "Zsolt Szabó" wrote in message ... Bob, Thanks your help. C5 = HH5 ( The last entered number is the highest from the last 5 entered numbers). If I type into cell C65 5, C66 1, C67 2, C68 3, C69 3.5, C70 4, than from the last 5 enterd numbers the last one is the highest and your formula result is "". I like to see as a result the 4. -- Many thanks for your help in advance. Have a wonderful day! Zsolt "Bob Phillips" wrote: Try =IF(LOOKUP(10^10,C:C)=MAX(C60:C5000),LOOKUP(10^10, C:C),"") -- __________________________________ HTH Bob "Zsolt Szabó" wrote in message ... Hello In COLUMN C from ROW 27 until ROW 64 I have numbers. In cell C5 =IF(C64=MAX(C60:C64),C64,""). What do I have to do when I have a new number in C65 and I like to have the same result in C5 =IF(C65=MAX(C61:C65),C65,"") without everytime fixing my formula in C5? -- Many thanks for your help in advance. Have a wonderful day! Zsolt |
| All times are GMT +1. The time now is 06:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com