Eliminating #N/A errors in =MIN STOCKHISTORY results
I am using the STOCKHISTORY function to find the minimum value during a set period. On occasion and for some stocks, there may be errors or missing data on a given day. This returns #N/A value, I would very much like to eradicate these errors and/or count the errors as zero. Period of time covered in this instance is previous 365 days, C17 is referencing the ‘stock’ ticker.