F
Farhad
Hi,
i have a range say A1:A100 containing numbers and i have a number in a cell
say B1, what i want to do is to have smillest number in the range A1:A100
that is bigger than the number that i have in B1, i tried the formula below
as an array formula but it does not work
=MIN(A1:A100>B1)
any help would be appreciatd.
Thanks,
i have a range say A1:A100 containing numbers and i have a number in a cell
say B1, what i want to do is to have smillest number in the range A1:A100
that is bigger than the number that i have in B1, i tried the formula below
as an array formula but it does not work
=MIN(A1:A100>B1)
any help would be appreciatd.
Thanks,