Search / Compare / Copy Value Up (cpm)

[sandy_eggo]

I have an xls of 150,000 lines similar to

B1 *
C1 AFIFI,ADEL
B2 1005063
C2 AFIFI,ADEL Q
B3 *
C3 AGARWAL,RAVINDER
B4 1000268
C4 AGARWAL,RAVINDER K

<PRE>
B C
* AFIFI,ADEL
1005063 AFIFI,ADEL Q
* AGARWAL,RAVINDER
1000268 AGARWAL,RAVINDER K
</pre>

I have a requirement to look for an asterisk in A:A, when found
compare the cell value in C2 with the cell above it B2. If there's a
"close match" between B2 & B1, copy the value in B2 to B1... over and
over and over again. By "close match" I mean, if the characters before
the comma match (lname), and the characters after the comma match
(fname) less the middle initial, copy the value in B2 to B1.

Appreciate ANY help--I've tried a number of macros and can't get it to
work properly.

 

[Sean Timmons]

If C1=LEFT(C2,FIND(" ",C2,FIND(",",C2)+2)-1)
Then B1=B2
End If