Re: Unique combinations of records in a list

Tech-Archive recommends: Fix windows errors by optimizing your registry


tom:

haven't seen posts from you in a while.

good to see you back.
--


Gary


"Tom Ogilvy" <TomOgilvy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0C7468DE-2E41-4D08-9DAF-1B64C856077E@xxxxxxxxxxxxxxxx

Sorry, didn't read closely enough

in F2
=IF(SUMPRODUCT(--($A$2:A2&$C$2:C2=A2&C2))>1,"X","")

then drag fill down the column.

--
Regards,
Tom Ogilvy




"Leon" wrote:

I have a Excel list made of 6 columns.
Records are added to that list daily.

I want to be able to create a helper column that will show an "X" next to a
row that has 2 records, let's say on column A and C ONLY, identical to those
in previous rows.

Example:
A B C D E
John 06/18/08 $ 590.00 256 A
Jack 06/19/08 $ 700.00 300 C
Mark 06/18/08 $ 590.00 256 A
Miles 06/19/08 $1,1190.00 300 C
Jack 06/18/08 $ 700.00 256 A...............X
(Identical records on Col A AND C than row 2
Lee 06/19/08 $1,1190.00 300 C

Any help or pointer will be gratefully appreciated



.

Relevant Pages

  • Re: Fuel mileage again - was Combination braking
    ... >>Tom may THINK gearing is the explanation, ... >>offset the added drag of a somewhat higher speed. ... Most civil things I've seen these two do -- ever! ...
    (rec.outdoors.rv-travel)
  • Re: Drag and drop into an HTA
    ... Tom, this is a surprise, you are usually answering rather ... O.K. On that page you are supposed to be able to drag some ... reference dropped from explorer onto a running HTA? ... The best I have been able to do is use a registry hack ...
    (microsoft.public.scripting.vbscript)
  • Re: Fuel mileage again - was Combination braking
    ... The faster you go, the less wind resistance. ... >>explained it then and I remember the explanation, but we'll see if he want ... >Tom may THINK gearing is the explanation, ... >offset the added drag of a somewhat higher speed. ...
    (rec.outdoors.rv-travel)
  • Re: A feature Id like to see
    ... iCal's attendee field should auto-complete names from your ... Drag a person to an even description (on the side of the iCal window) to ... Tom "Tom" Harrington ...
    (comp.sys.mac.apps)
  • Re: Fuel mileage again - was Combination braking
    ... >>>Tom may THINK gearing is the explanation, ... >>>offset the added drag of a somewhat higher speed. ... >The Curmudgeon of Sill Hill ...
    (rec.outdoors.rv-travel)