See attached - a very basic sheet "PastedData".
I have a team of travelling salesmen who go from city to city (!) selling their wares.
The sheet shows the sales for each salesman/woman for each city.
The number of cities will vary - and this is the key to my problem.
I want a second sheet to show the Salesmans Name in column A.
Column C should show the RIGHT most city from the "PasteData" sheet.
Column B should show the second RIGHT most city data.