Helpppppp

[MAK]

Hi there...

What I´m trying to do its pretty simple, but not to me.


i m havin 2 sheets in excel. in one of those UNIQUE records are there wit
some corresponding values in another column.... bt in another sheet there is
only one column and t data is nt unique.
ex....
COLUMN 1 COLUMN 2

ACTB005 1
ACTB009 2 UNIQUE RECORDS
ACTB010 3
ACTB018 4
ACTB020 5
ACTB025 6




and

ACTB005
ACTB009
ACTB010
ACTB010
ACTB018 Repeted records
ACTB018
ACTB020
ACTB020
ACTB025
ACTB025

and the output is supposed 2 be lke tis

ACTB005 1
ACTB009 2
ACTB010 3
ACTB010 3
ACTB018 4
ACTB018 4
ACTB020 5
ACTB020 5
ACTB020 5
ACTB025 6

 

[Bill Kuunders]

A simple "if" function should do the trick

enter 1 in the first cell in column B
enter .....=IF(A3=A2,B2,B2+1)

and extend it down the column

greetings from New Zealand

 

[Murray]

Alternatively, and especially if the repeated records might not be
sorted, use VLOOKUP.

Assuming your unique records are in A1:B6, and the first repeated
record is in A10, then put

=VLOOKUP(A10,$A$1:$B$6,2,FALSE)

in B10 and then copy it down

Regards

Murray

 

[Jim Cone]

http://www.cpearson.com/excel/newposte.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"MAK" <[email protected]>
wrote in message
Hi there...
What I´m trying to do its pretty simple, but not to me.

-snip-