Dec 01 2022 12:56 PM
Hi,
This formula returns a #ERROR, and I can't see why.
I've tried at least five ways to find the minimum value from a separate sheet. From putting in all the numbers to MIN=(Sheet1!C2:C9).
I've used =MIN((SheetRawData!C2:C9)).
Any feedback would be so appreciated.
Dec 01 2022 01:29 PM
Solution=MIN(IFERROR(C2:C9,""))
Maybe there is an error in range C2:C9. You can add IFERROR to exclude errors. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.
Dec 01 2022 04:16 PM
Thank you so much!
It worked!
I really appreciate all of your help.
Let me know if I can assist you with anything. :grinning_face:
Nov 16 2023 12:05 PM
Dec 01 2022 01:29 PM
Solution=MIN(IFERROR(C2:C9,""))
Maybe there is an error in range C2:C9. You can add IFERROR to exclude errors. Enter the formula with ctrl+shift+enter if you don't work with Office365 or Excel 2021.