|
Search / Compare / Copy Value Up (cpm)
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. |
Search / Compare / Copy Value Up (cpm)
If C1=LEFT(C2,FIND(" ",C2,FIND(",",C2)+2)-1)
Then B1=B2 End If "sandy_eggo" wrote: 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. |
| All times are GMT +1. The time now is 12:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com