Dynamically Extract Table Range and Remove Duplicates

[jdppep]

I am trying to extract a column of data from a table to another range and remove duplicates dynamically.

Suggestions?

 

[Hui]

Have a read of Challenges 8 & 11 at: http://chandoo.org/forum/forums/excel-challenges/

 

[SirJB7]

HI, jdppep!

I've done such a few things with formulas only, let me see if I can find the links (it so easy to find anything here, ha!)....
(a lot of time later)
... here it's one, the others are alike this but the technique of building the unique list and removing dupicates it's clearer here:
http://chandoo.org/forum/threads/find-out-unique-words-in-excel.14001/#post-82909

Just advise if any issue.

Regards!

 

[jdppep]

I have been referring to the challenges Hui mentioned above; however, have been unsuccessful applying these to my dashboard.

I have uploaded a sample file to SkyDrive (it was too large to upload on here at 3.54mb):
https://skydrive.live.com/redir?res...62&authkey=!AB-Co6dqFrPR-n4&ithint=file,.xlsm

#1 My data originates on the 'RawData' tab. From this, I am trying to create tables of specialties, practices, and months on their respective tabs (UniqueSpecialties, PracticeSites and Calendar), which extract only unique values dynamically (as information is added to the 'RawData' tab).

#2 Additionally, I want to reference (named range) the information on the 'RawData' tab as unique lists to their respective table heading via formula for purposes of charting. I was attempting to apply this formula; however, am not sure how to apply it to the individual table headings on 'RawData':

=T(OFFSET(A1,SMALL(IF(MATCH(t,t,0)=ROW(t),ROW(t)),ROW(INDIRECT("A1:A"&SUM(1/COUNTIF(t,t)))))-1,))

I am hoping to accomplish this with minimal VBA coding.

Thank you for any assistance!