# Math problem

**URL:** <https://community.glideapps.com/t/math-problem/47386>\
**Category:** Ask for Help\
**Created:** [August 21, 2022, 6:00pm UTC](https://community.glideapps.com/t/math-problem/47386 "2022-08-21T18:00:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![M.V\_Consulting\_SRL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m.v_consulting_srl/32/3613_2.png) [@M.V\_Consulting\_SRL](https://community.glideapps.com/u/M.V_Consulting_SRL)\
**Post date:** [August 21, 2022, 6:00pm UTC](https://community.glideapps.com/t/math-problem/47386/1 "2022-08-21T18:00:11Z")

</div>

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 ? 🤔

Thank you  
M.V.

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [August 21, 2022, 6:01pm UTC](https://community.glideapps.com/t/math-problem/47386/2 "2022-08-21T18:01:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![M.V\_Consulting\_SRL](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m.v_consulting_srl/32/3613_2.png) [@M.V\_Consulting\_SRL](https://community.glideapps.com/u/M.V_Consulting_SRL)\
**Post date:** [August 21, 2022, 6:08pm UTC](https://community.glideapps.com/t/math-problem/47386/3 "2022-08-21T18:08:08Z")

</div>

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…

---

<div class="post-metadata">

**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\
**Post date:** [August 21, 2022, 6:09pm UTC](https://community.glideapps.com/t/math-problem/47386/4 "2022-08-21T18:09:15Z")

</div>

@gvalero has the solution for you! : [🔢 Count duplicate elements in an array or list](https://community.glideapps.com/t/count-duplicate-elements-in-an-array-or-list/41313)

---

<div class="post-metadata">

**Author:** ![ShantanuIyengar](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/shantanuiyengar/32/35546_2.png) [@ShantanuIyengar](https://community.glideapps.com/u/ShantanuIyengar)\
**Post date:** [August 21, 2022, 6:12pm UTC](https://community.glideapps.com/t/math-problem/47386/5 "2022-08-21T18:12:47Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 22, 2022, 6:13pm UTC](https://community.glideapps.com/t/math-problem/47386/6 "2022-08-22T18:13:23Z")

</div>

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