I have following on a1
001. Andrew Fisher
(AUS)
002. Adam Kretschmer
(AUS)
003. Karen Richards
(AUS)
I need formula on b1 drag down to give me result as follows
, AUS in not only the country , the list is long enough
001. Andrew Fisher(AUS)
002. Adam Kretschmer(AUS)
003. Karen Richards(AUS)
Bookmarks