Re: Uniqe list

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Jason_at_Simcon
Date: 12/03/04 

Date: Fri, 3 Dec 2004 12:21:02 -0800

Am looking for the unique list to be automatic with no action on the users
part. This is only one step of many on this type of doc.

"JE McGimpsey" wrote:

> Check out Advanced Filter in Help, including the Unique Values only
> option.
>
> For more, see
>
> http://contextures.com/xladvfilter01.html
>
>
> In article <5CDB7AB1-26CD-4B41-875D-C4AA1218218C@microsoft.com>,
> Jason@Simcon <JasonSimcon@discussions.microsoft.com> wrote:
>
> > I have a large problem that I cannot find a simple formula for. Been looking
> > and trying now for over a year.
> >
> > As follows: A1:A100 is filled with data that is often repeated. There may
> > also be some blanks. In this data there may be anywhere from 2 to 100 unique
> > pieces of data that I would like to extract and put in column B1 thru
> > B....(however many unique pieces of data have been extracted).
> >
> > Example:
> > A B
> > 1 George George
> > 2 Sam Mike
> > 3 Mike Sam
> > 4 Sam Zachary
> > 5 George
> > 6 Mike
> > 7 Zachary
> > 8 Sam
> > 9 George
> > 10 Zachary
> >
> > It seems so simple and I cant believe Microsoft does not have a formula or
> > function for this. Keep in mind that this is an example and the real
> > worksheets have thousands of entries with 100s of unique pieces of data. This
> > appears to be a fundamental stopping point for me in creating spreadsheets
> > that automatically create reports for me without bogging down the computer.
> > I have gotten around it by using Rank, match, and index but it really bogs
> > me down and if it doesnt go into "not responding" then it could take up to 10
> > minutes to open. (Pent 4.., etc. state of the art up to date computers)
> >
> > Would very very much appreciate a simple formula that can achieve this.
> > Thank you
>

Relevant Pages

  • Re: WHY
    ... Every time Harlan posts a logical counter to one ... However, as previously agreed, repetitive reports would be ... >> implemented as database apps. ... >> prejudiced to learn that reports aren't the only thing spreadsheets ...
    (microsoft.public.excel)
  • Re: WHY
    ... However, as previously agreed, repetitive reports would be better ... > prejudiced to learn that reports aren't the only thing spreadsheets can ... Just the original loan amount and some ... > payment and principal balance after current payment, ...
    (microsoft.public.excel)
  • Re: why>?
    ... easier to do in a spreadsheet than it is to do in Excel. ... I can produce portable reports in PDF form quite easily.. ... Spreadsheets are poor platforms for writing complex ... databases don't NEED to store a different formula for each row. ...
    (microsoft.public.excel)
  • Re: Time for something new for Excel?
    ... production implementation of an html report, using Cache' Zen reports. ... In theory we can turn this into a pdf as well (just a tad bit of setup ... spreadsheets because they're Excel power users, ...
    (comp.databases.pick)
  • Re: WHY
    ... Can you do that in Excel? ... However, as previously agreed, repetitive reports would be ... > prejudiced to learn that reports aren't the only thing spreadsheets ... Just the original loan amount and some ...
    (microsoft.public.excel)