Math problem

Ask for Help
1

Hello,

I have a row with different values (numbers), some of them for many times. I need to know how many times a certain value (number 5 for example) appear in this row… How can I do this ? :thinking:

Thank you
M.V.

2

If you could give an example and what exactly you are trying to achieve, I might have a solution!

3

I have this row
1,55,12,48,5,48,65,11
and the number 48
Which is the formula for calculating how many times the number 48 is contained in the above row. Can I use an Excell formula ? I’m stuck here…

4

@gvalero has the solution for you! : 🔢 Count duplicate elements in an array or list

2 Likes
5

Okay so the easiest approach would be

  1. Create an array of these columns.
    (If these values are in a single column, then split it using “,”)

  2. Once you have an array, in one column, you can calculate no. of elements in the array (Call it ‘A’)

  3. Remove the element you want, say “48”
    (All occurrences of 48 will be removed)

  4. Re-calculate no. of elements in the array (Call it ‘B’)

  5. So A - B, should give you no. of occurrences of 48

2 Likes
6

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.