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.

Okay so the easiest approach would be Create an array of these columns. (If these values are in a single column, then split it using “,”) Once you have an array, in one column, you can calculate no. of elements in the array (Call it ‘A’) Remove the element you want, say “48” (All occurren…

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

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…

Math problem

Ask for Help

Dilon_Perera August 21, 2022, 6:09pm 4

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

Topic		Replies	Views
Can i count the number of repeated items in array column Ask for Help	4	926	May 19, 2022
Count how many times a value appears Ask for Help	6	1475	October 6, 2022
How do I count occurrences in an array column? Ask for Help	13	2657	October 30, 2022
Calculating duplicated items in an arrow Ask for Help	4	160	September 28, 2023
How to count how many times a value is in an array Ask for Help	8	1643	January 27, 2022

Math problem

Related topics