I have a large bunch of data.
Lets say it looks like it:
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 :
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