Thread: #N/A In Cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default #N/A In Cells

I am using Excel 2007 on a Windows 7 desktop.

I have this enormous main spreadsheet which is linked to many other
ones. Sometimes there are a few cells in the main spreadsheet with
"#N/A" in them.
Is there a formula that will quickly point out to me which cells of the
main spreadsheet have the "#N/A" in them?
--
tb