Sort Out Specific Data from an Array and Re-Format

**Leathermyth** · 07-08-2013, 08:48 PM

Okay, bear with me while I try to explain.

We have a set of reps that have to meet a certain quota individually and some -- but not all also work as partners and have a different quota point to make as partners.

Now, because of the individual quotas and the requirement (not my idea) that everyone be listed alphabetically, I have to start with an array that is set up more for the individual quotas. However, in a different format, I have to display the partners and the partner quotas.

So, basically, I have to: A) copy only those reps that are partners onto another work page, listing them in the same row; B) Not duplicate partners (as in "John" listed first and "Anne" listed second, then "Anne" listed first and "John" listed second); and, of course, C) their total as partners.

I managed to attach an Excel.png -- thought a visual might help.

**vlady** · 07-08-2013, 10:01 PM

Moderator's Note:

I think it's better to post the real workbook than pictures.
Typing data from a picture or paste text from your post into a spreadsheet as a hindrance to helping.
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

Regards,
Vladimir

**Leathermyth** · 07-08-2013, 11:30 PM

Unfortunately, the work pages/work book contain data that is considered highly sensitive; even if I removed that data, I'd have to go through and eliminate (or at least rename) a number of the columns for the same reason (and rename the book).

I will try to create a "dummy," for you, but it is going to take me a while.