Questions: create 'map' of area members and refining donor list

Welcome to the forum:

If the addresses of the donors include the zip codes, you could get a listing of all the zip codes for the area that you are responsible and then use possibly use COUNTIF to count the members within each zip code or partial zip code.

As far as "mapping" with a real map, I have no idea how you would accomplish that.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Hi and welcome to the forum.

You'll need to upload the csv file at least. And to avoid us wasting time it would be useful to know what YOU mean by a 'chart of some kind'. Even a picture of a sketched example would do.

I have created a Pivot table that summarizes your data and then from that table extracted the 20 top contributors. You can extract more than that if you like.

Thank you for the feedback.

Column C of the Pivot table with the ranking was obtained by including a second insertion of the Amount in the values then right clicking in the column for that second amount and selecting Show Values As and then select Rank Largest to Smallest. The side table of top contributors is based on those values.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.