# How to count any column repeated data **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [May 2, 2021, 5:41pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773 "2021-05-02T17:41:34Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [May 2, 2021, 5:41pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/1 "2021-05-02T17:41:34Z")
Hi Everyone, I’m using air table and I want to count the repeated data.I have 2 type of data in column 1.Closed 2.Open I want count number of Closed and Open. I have used length of column on condition but it’s showing all row count. ! ![IMG_20210502_230727](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/4/44d65e709a51c5264fffbc5cebc2ae0aa53050f6.jpeg) Through the condition block if output showing in list viewer I’m getting prefect results but on count it’s not working If anyone have idea please help or share example block. Thank You ---
**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\ **Post date:** [May 2, 2021, 5:57pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/2 "2021-05-02T17:57:11Z")
Try making a variable and increasing it every time you see a closed row. Or get the length of the list when you’re done making it. Column is all the rows. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [May 2, 2021, 6:19pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/3 "2021-05-02T18:19:45Z")
Why are you using Length of [column] You want the count of the ones meeting the condition so use Length of [app variable dataList] ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [May 2, 2021, 6:31pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/4 "2021-05-02T18:31:10Z")
Hi Thanks for revert, @catsarisky actually i don’t have much knowledge about variable count even i will try . @muneer if i am using {app variable data list } output is showing “0” ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [May 2, 2021, 6:35pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/5 "2021-05-02T18:35:36Z")
Then it means something in you data that makes you condition **false** all the time. Remember: both property names and values are case sensitive. So “Cell Status” and “User ID” should be exactly the way it is written in the Airtable table. The same for “Closed” and the user ID, if they are not the same case as in the table the condition fails. ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [May 2, 2021, 6:49pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/6 "2021-05-02T18:49:52Z")
@muneer yes all values are same what i have written in Airtable . Because the same condition i am using list viewer and getting proper output like How may ROWs have closed or open data its showing related rows only and both condition is getting true on list viewer. ---
**Author:** ![vikkun](https://avatars.discourse-cdn.com/v4/letter/v/7993a0/32.png) [@vikkun](https://community.thunkable.com/u/vikkun)\ **Post date:** [May 2, 2021, 6:59pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/7 "2021-05-02T18:59:21Z")
hi @muneer if i am using GetAllRow in place of GetColumn and i have used length of {app variable data list } its working and both condition is getting true. Thanks you for your support, Regards, Vikku ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [May 2, 2021, 7:15pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/8 "2021-05-02T19:15:22Z")
Now it’s better. With GetColumn the second condition (User ID) is always **False** because you are getting only “Cell Status”. In the other hand, GetColumn return a normal list and you should not use Get property [Cell Status] of [j]. Glad that it is solved now. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 1:22pm UTC](https://community.thunkable.com/t/how-to-count-any-column-repeated-data/1258773/9 "2024-11-08T13:22:43Z")