Hello,
I am creating a music chart list that contains numbers like 1, 2b, 3, 4, 5b....
I am using this formula to get the peak position in a range:
=MIN(L129:DE129)
It works when there is no "b" in the numbers, is there a way to tell it to ignore the "b"?
Thanks in advance for your help,
I am creating a music chart list that contains numbers like 1, 2b, 3, 4, 5b....
I am using this formula to get the peak position in a range:
=MIN(L129:DE129)
It works when there is no "b" in the numbers, is there a way to tell it to ignore the "b"?
Thanks in advance for your help,