LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 740
Default formula to count easily

in my formulation list workbook, i have one column filled with different
formulas...
result can be a text, number, and all sorts of known error types....e.g.

#NULL!
#DIV/0!
#VALUE!
#REF!
#NAME?
#NUM!
#N/A

I like to count (A1:A100) how many formula are bearing each error.type...
this may enlighten me how to clean the list of formula bearing correct
results...

pls. bear with me...

regards,
driller
--
*****
birds of the same feather flock together..

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
help to count easily driller Excel Worksheet Functions 2 June 9th 07 09:21 PM
anyway around this, easily? dribler2 Excel Worksheet Functions 1 January 9th 07 01:00 AM
how to count easily dribler2 Excel Worksheet Functions 21 January 1st 07 05:33 AM
Can this be done easily? yhtak Excel Discussion (Misc queries) 1 August 30th 06 02:14 PM
How to insert easily the text of a scientific formula William ASSAL Excel Discussion (Misc queries) 5 March 1st 05 03:48 PM


All times are GMT +1. The time now is 11:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"