Results 1 to 12 of 12

Return Unique Text Values without Advanced Filter

Threaded View

  1. #1
    Registered User
    Join Date
    04-17-2009
    Location
    Dallas
    MS-Off Ver
    Excel 2007
    Posts
    9

    Return Unique Text Values without Advanced Filter

    Hey guys I have spent the last 30 minutes searching and found answers too simple and too complicated. I think what I need is simple code, but I don't know how to write it:

    I have a list of Window sizes and types in Range B4:B:43. The descriptions repeat because in Column K I am listing a location for each window in a house.

    Example:
    B K
    3050 SH 1/1 Dining Room
    3050 SH 1/1 Kitchen
    2030 Fixed Foyer
    2030 Fixed Living Room

    In the Same sheet Starting on B:45 I want a list of only Unique Window Types:

    B:45 and Down:
    3050 SH 1/1
    2030 Fixed

    I'd like this to automatically appear after populating the first list. I used an advanced filter the first time and it worked, but it is not reliable and sometimes returns duplicate values or give me an error message. Plus once again having it happen automatically as the list will change each time I access the sheet would be great.

    Thanks,
    Nick
    Last edited by nicknick5219; 05-21-2009 at 10:13 AM. Reason: New problem - but related

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1