Hope someone can help with this.
Is there a formula for counting how many times a particular word appears in a column and displaying the results which will autoupdate when new additions are made.
Quick example with 5 rows
paris
madrid
paris
madrid
london
My formula needs to show Paris = 2, and if I add another row with paris the formula will auto update to 3 and so on.
Thanks,
Andy
Is there a formula for counting how many times a particular word appears in a column and displaying the results which will autoupdate when new additions are made.
Quick example with 5 rows
paris
madrid
paris
madrid
london
My formula needs to show Paris = 2, and if I add another row with paris the formula will auto update to 3 and so on.
Thanks,
Andy