Anbuselvam K
Member
Hi
I have numbers from 1 to 100, 1000 to 3000, and 4000 to 5000 in column B. I need the highest value from the number 1000 to 3000 in cell C5. Expected answer in cell C5 is 2999.
Please find the attached sheet.
Can anyone help me out?
Thanks in Advance.
I have numbers from 1 to 100, 1000 to 3000, and 4000 to 5000 in column B. I need the highest value from the number 1000 to 3000 in cell C5. Expected answer in cell C5 is 2999.
Please find the attached sheet.
Can anyone help me out?
Thanks in Advance.
Attachments

8.5 KB Views: 5