Hello.

I have a large bunch of data.

Lets say it looks like it:

Banana

Kiwi

Apple

Banana

Banana

Kiwi

…

I want to use this data to fill a table counting the occurence of every item.

In Excel, I would build a table like this :

Kiwi :

Apple :

Banana :

… :

And use a "CountIf formula to check how many “A1” there is (3 bananas), then how many “A2” there is (2 kiwis), etc.

I saw here a way to do the CountIf on Coda (Coda's equivalent to Excel's SUMIF, COUNTIF, and AVERAGEIF), but I don’t know how to do it the Excel way (like copy-pasting a formula to change it dynamicly).

In the example I saw I need to put manually the content (“kiwi”) in the formula instead of refering to another cell (“A1”) like in Excel and then copy-pasting it. So in my situation it would be very long to change manually the formula for all the options I have (let say I have a very long list of fruits).

=> What would be the correct “Coda way” of doing it?

Thx for your help in my switch