Lets say I have the following in a spreadsheet in Columns A, B & C:
HEADER ROW:
SEARCH TERM | IP ADDRESS | SEARCHED ON
EXAMPLE DATA:
iPhone10 | 51.255.65.20 | 2018-02-08 1:38:56
Shoes | 216.344.46.55 | 2018-02-20 0:14:03
Satellites | 105.216.96.122 | 2017-09-19 0:53:07
Satellites | 100.43.85.11 | 2017-06-20 21:10:07
Video songs | 108.140.38.3 | 2017-07-26 5:52:54
In column D, I need the formula that will count the number of times the 'SEARCH TERM' appears, so the example data above should show like this after applying the formula:
iPhone10 | 51.255.65.20 | 2018-02-08 1:38:56 | 1
Shoes | 216.344.46.55 | 2018-02-20 0:14:03 | 1
Satellites | 105.216.96.122 | 2017-09-19 0:53:07 | 2
Satellites | 100.43.85.11 | 2017-06-20 21:10:07 | 2
Video songs | 108.140.38.3 | 2017-07-26 5:52:54 | 1
Thanks