hsandeep
Well-known Member
- Joined
- Dec 6, 2008
- Messages
- 1,213
- Office Version
- 2010
- Platform
- Windows
- Mobile
In column C, I generate various values through C%:C9999. Lot of generated values are EXACT.
How to COUNT the number of various generated values in column C.
"Ledger" & "LEDGER" should be counted separately.
Similarly, "Led ger" & "Ledger" should be counted separately.
Similarly, " Ledger" & "Ledger" should be counted separately.
If a blank is generated in column C, it should be counted separately.
If a "#N/A" is generated in column C, it should be counted separately.
If a "#Ref!" is generated in column C, it should be counted separately.
Thanks in advance.
How to COUNT the number of various generated values in column C.
"Ledger" & "LEDGER" should be counted separately.
Similarly, "Led ger" & "Ledger" should be counted separately.
Similarly, " Ledger" & "Ledger" should be counted separately.
If a blank is generated in column C, it should be counted separately.
If a "#N/A" is generated in column C, it should be counted separately.
If a "#Ref!" is generated in column C, it should be counted separately.
Thanks in advance.