Knowing the number

  • Thread starter Thread starter sadman49
  • Start date Start date
S

sadman49

Calling on all excel experts.
I have a sheet starting from A1 to J100, in these boxes random numbers are
entered, i.e: 4, 56, 34, 56, 23 and so on.
What i want is a box to tell me how many times and number 56 has appered,
i've tried using index but can't get it working.
John
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

box combination formula 8
Exporting to text file in multiple lines 3
please help.is it possible re-edit macro to convert text like1530-2200 to time format automatically? 1
Changing the Dataset. 3
Formula for summing purchases and sales 8
Matching call data based on date, time and number called to give c 1
Having trouble formatting times 5
Using Filters 2

Back
Top