Formula to count the duplication of a value in a range
Closed
ARZANM
Posts
9
Registration date
Tuesday November 17, 2015
Status
Member
Last seen
December 8, 2015
-
Nov 17, 2015 at 07:32 AM
ARZANM Posts 9 Registration date Tuesday November 17, 2015 Status Member Last seen December 8, 2015 - Nov 18, 2015 at 11:22 PM
ARZANM Posts 9 Registration date Tuesday November 17, 2015 Status Member Last seen December 8, 2015 - Nov 18, 2015 at 11:22 PM
Related:
- Formula to count the duplication of a value in a range
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
Nov 17, 2015 at 11:37 PM
=COUNTIF(range,"*a1*")
Please help me out with this.
Thanks
Arzan
Nov 18, 2015 at 11:29 AM
Even if I replace "a1" with "x a1 x" in the cells and use:
=COUNTIF(range,"*a1*")
I still get an answer of 9.
Perhaps if you post your spreadsheet to a site like speedyshare. This way we can see what's really going on.
Sorry I'm not more help.
Nov 18, 2015 at 11:22 PM
Thanks for the revert but am still getting 6 as the answer. Forgot to mention that I am using Excel 2007. Anyway I will try and post it on speedyshare as you suggested.
Thanks
Arzan