Hi,
I have updated the next two cities sum according to your requirement. I will use excel functions to derive the first and last occurrence of the city name and from that I will calculate the sum in the first occurrence. Please confirm me I will start the work immediately
20 #N/A ABILENE, TX 41
13 #N/A ABILENE, TX
4 #N/A ABILENE, TX
3 #N/A ABILENE, TX
1 #N/A ABILENE, TX
3 Growth ABINGDON, IL 3
2 Managed ABINGDON, MD 2
6 Managed ABINGDON, VA 8
2 Managed ABINGDON, VA
5 Growth ABITA SPRINGS, LA 5
3 Growth ABRAMS, WI 3
2 Managed ABSECON, NJ 3
1 Managed ABSECON, NJ
17 Managed/Closed ACAMPO, CA 17
Regards,
Rajesh.
--------------------------
Hi,
I am interested to work on your project. Looks like the spreadsheet in attachment is missing. Could you please share the sheet to have more understanding? After reading the description I hope below format would be your requirement. I will use excel functions to retrieve the values.
20 #N/A ABILENE TX 41
13 #N/A ABILENE TX
4 #N/A ABILENE TX
3 #N/A ABILENE TX
1 #N/A ABILENE TX
20 #N/A Houston TX 61
13 #N/A Houston TX
24 #N/A Houston TX
3 #N/A Houston TX
1 #N/A Houston TX
10 #N/A Dallas TX 80
13 #N/A Dallas TX
53 #N/A Dallas TX
3 #N/A Dallas TX
1 #N/A Dallas TX
Please provide the sheet and other details to start the work.
Regards,
Rajesh.