Creating an Array from range, no duplicates, filtered by location

**gottnoskill** · 10-06-2015, 01:32 AM

I feel like what I'm after should be easily accomplished but I can't seem to wrap my head around this. I've messed around with arrays very rarely.

http://i.imgur.com/Leu1xTe.jpg

So from here we have Job No., Location, DF Name

This is a sample of the data this comes up to about 300-400 Jobs so far. Locations are fixed data from about 24 different locations. DF Name are values that can have duplicate information.

I would like to filter by location and take out the duplicate DF Names from each location and create a small list.

So Ideally the selection in the end would look like this for the "Brown" Location. For the sake of simplicity lets say I want the data below on column D for Location and column E for the DF Name results.

Location DF Name

Brown 01DF1
Brown 01DF2
Brown 01DF4

Thanks!

**skywriter** · 10-06-2015, 03:24 AM

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

**gottnoskill** · 10-06-2015, 09:27 AM

Here is a little bit more data to get the idea in the sample book provided in attachments.

There is a 'Before Sheet' showcasing the raw data.
A 'VBA Filter Process' Sheet to just explain the idea im going for.
and a 'After Results' sheet for the desired results.

**skywriter** · 10-06-2015, 01:34 PM

Okay, Alt + F8 to bring up the macro list. When you run the macro you will be asked to type a location into an input box. We can do this other ways, it doesn't have to be an input box.

Please Login or Register  to view this content.

**gottnoskill** · 10-13-2015, 10:14 AM

At the moment I made it work for what I was looking for. However It would probably be best I looped through the entire list of possible locations to give me a list. I just created an extra excel sheet with a table of each location and another table to place all the DFI data in. From there I ran my report macros and got the lists to populate the way I wanted. Thanks for the help!