Depends on the amount of data, too.

If you've sorted and used data|subtotal to get subtotals, then you'll be
surprised how easy your life will become after an hour playing with pivottables.

There's lots of links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx

JMB wrote:

a much faster solution. I've never used pivottables much.

"Dave Peterson" wrote:

Ahhhh. The OP wants just the customers that have bought both author--not either
author.

I think I'd create a pivottable (with authors in the column field if they fit)
and then filter by those columns to show 0 for both columns (dickens and
twain).



JMB wrote:

those are the lines along which I was thinking, but some additional work
would be needed to identify the customer id's w/both Dickens and Twain.
filtering w/this criteria will result in customer id's that purchased either
author.

"Dave Peterson" wrote:

Maybe just apply Data|filter|autofilter to the range.

filter to show Dickens or Twain

If you need more, you could try Ron de Bruin's easyfilter.
http://www.rondebruin.nl/easyfilter.htm

ronb wrote:

i have a spreadsheet with 2 columns, cust id and author.
how can i find all cust id's that have purchased from 2 specific authors
such as Dickens and Twain

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson