How to count how many times a number appears in a spreadsheet?
Solved/Closed
kimipapineau
Posts
3
Registration date
Thursday July 14, 2016
Status
Member
Last seen
July 15, 2016
-
Jul 14, 2016 at 03:44 PM
kimipapineau Posts 3 Registration date Thursday July 14, 2016 Status Member Last seen July 15, 2016 - Jul 15, 2016 at 11:20 AM
kimipapineau Posts 3 Registration date Thursday July 14, 2016 Status Member Last seen July 15, 2016 - Jul 15, 2016 at 11:20 AM
Related:
- Excel formula to find how many times a number appears
- Number to words in excel formula - Guide
- Formula to calculate vat in excel - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel color formula - Guide
- Excel mod apk for pc - Download - Spreadsheets
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Updated on Dec 12, 2018 at 12:43 PM
Updated on Dec 12, 2018 at 12:43 PM
kimipapineau, Good evening.
Try it:
MATRICIAL FORMULA
Press SHIFT + CTRL + ENTER at final o formula
Please, tell us if it worked for you.
I hope it helps.
Try it:
MATRICIAL FORMULA
=SUM(LEN(B6:M59)-LEN(SUBSTITUTE(B6:M59,1,"")))
Press SHIFT + CTRL + ENTER at final o formula
Please, tell us if it worked for you.
I hope it helps.
Jul 15, 2016 at 09:18 AM
Updated on Dec 12, 2018 at 12:44 PM
Did you remember that is an array formula?
In this case you need press CTRL+SHIFT+ENTER to enter them into your cell.
Take a look at it and tell us if it's working now.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jul 15, 2016 at 11:20 AM