Excel: Count field size name .


Hello all , I am needing a function that can give me the result I have in col S . It needs to total the count of each different name in col U . Thanks . Sheet1

 SU
1FszRace Name
24FARMING SHOW-12-1 weekdays on Radio Sport 2170
34FARMING SHOW-12-1 weekdays on Radio Sport 2170
44FARMING SHOW-12-1 weekdays on Radio Sport 2170
54FARMING SHOW-12-1 weekdays on Radio Sport 2170
611TAURANGA CHRISTMAS RACES-BOOK NOW 1400
711TAURANGA CHRISTMAS RACES-BOOK NOW 1400
811TAURANGA CHRISTMAS RACES-BOOK NOW 1400
911TAURANGA CHRISTMAS RACES-BOOK NOW 1400
1011TAURANGA CHRISTMAS RACES-BOOK NOW 1400
1111TAURANGA CHRISTMAS RACES-BOOK NOW 1400
1211TAURANGA CHRISTMAS RACES-BOOK NOW 1400
1311TAURANGA CHRISTMAS RACES-BOOK NOW 1400
1411TAURANGA CHRISTMAS RACES-BOOK NOW 1400
1511TAURANGA CHRISTMAS RACES-BOOK NOW 1400
1611TAURANGA CHRISTMAS RACES-BOOK NOW 1400
179THEWAYYOUARE@WINDSOR PARK 1400
189THEWAYYOUARE@WINDSOR PARK 1400
199THEWAYYOUARE@WINDSOR PARK 1400
209THEWAYYOUARE@WINDSOR PARK 1400
219THEWAYYOUARE@WINDSOR PARK 1400
229THEWAYYOUARE@WINDSOR PARK 1400
239THEWAYYOUARE@WINDSOR PARK 1400
249THEWAYYOUARE@WINDSOR PARK 1400
259THEWAYYOUARE@WINDSOR PARK 1400
267YARDMASTER PUMPS BY REID & HARRISON 1200
277YARDMASTER PUMPS BY REID & HARRISON 1200
287YARDMASTER PUMPS BY REID & HARRISON 1200
297YARDMASTER PUMPS BY REID & HARRISON 1200
307YARDMASTER PUMPS BY REID & HARRISON 1200
317YARDMASTER PUMPS BY REID & HARRISON 1200
327YARDMASTER PUMPS BY REID & HARRISON 1200
336AZTECH SIGN-FAREWELL NOONS 1400
346AZTECH SIGN-FAREWELL NOONS 1400
356AZTECH SIGN-FAREWELL NOONS 1400
366AZTECH SIGN-FAREWELL NOONS 1400
376AZTECH SIGN-FAREWELL NOONS 1400
3812LENNY GOORD FAREWELL
3912LENNY GOORD FAREWELL
4012LENNY GOORD FAREWELL
4112LENNY GOORD FAREWELL
4212LENNY GOORD FAREWELL
4312LENNY GOORD FAREWELL
4412LENNY GOORD FAREWELL
4512LENNY GOORD FAREWELL
4612LENNY GOORD FAREWELL
4712LENNY GOORD FAREWELL
4812LENNY GOORD FAREWELL
4912LENNY GOORD FAREWELL
503CHRISTMAS PARTIES @ ELLERSLIE 1200
513CHRISTMAS PARTIES @ ELLERSLIE 1200
523CHRISTMAS PARTIES @ ELLERSLIE 1200
538COCA-COLA 1400
548COCA-COLA 1400
558COCA-COLA 1400
568COCA-COLA 1400
578COCA-COLA 1400
588COCA-COLA 1400
598COCA-COLA 1400
608COCA-COLA 1400
6113SCHWEPPES GREAT NORTHERN HURDLE
6213SCHWEPPES GREAT NORTHERN HURDLE
6313SCHWEPPES GREAT NORTHERN HURDLE
6413SCHWEPPES GREAT NORTHERN HURDLE
6513SCHWEPPES GREAT NORTHERN HURDLE
6613SCHWEPPES GREAT NORTHERN HURDLE
6713SCHWEPPES GREAT NORTHERN HURDLE
6813SCHWEPPES GREAT NORTHERN HURDLE
6913SCHWEPPES GREAT NORTHERN HURDLE
7013SCHWEPPES GREAT NORTHERN HURDLE
7113SCHWEPPES GREAT NORTHERN HURDLE
7213SCHWEPPES GREAT NORTHERN HURDLE
7313SCHWEPPES GREAT NORTHERN HURDLE
744LINDAUER 2100
754LINDAUER 2100
764LINDAUER 2100
774LINDAUER 2100
788MEADOW FRESH GREAT NORTHERN STEEPLECHASE
798MEADOW FRESH GREAT NORTHERN STEEPLECHASE
808MEADOW FRESH GREAT NORTHERN STEEPLECHASE
818MEADOW FRESH GREAT NORTHERN STEEPLECHASE
828MEADOW FRESH GREAT NORTHERN STEEPLECHASE
838MEADOW FRESH GREAT NORTHERN STEEPLECHASE
848MEADOW FRESH GREAT NORTHERN STEEPLECHASE
858MEADOW FRESH GREAT NORTHERN STEEPLECHASE



This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of September 21, 2014.


For more resources for Microsoft Excel