Moe1950
New Member
- Joined
- Mar 16, 2012
- Messages
- 6
I have a column in a spreadsheet that is either populated by either an #N/A (which is populated using a COUNTIF(XX:XX,"Value") ) or an actual number. I have no way of know what that number is.
What I need to do is find all of the rows in the spreadsheet where that particular column DOES NOT equal #N/A
What would be best way of accomplishing this?
This is Excel 2007
What I need to do is find all of the rows in the spreadsheet where that particular column DOES NOT equal #N/A
What would be best way of accomplishing this?
This is Excel 2007