These telephone numbers have changed so I want to add new numbers to the numbers in column with red color
These telephone numbers have changed so I want to add new numbers to the numbers in column with red color
I'm sorry, but I did understand nothing
Simply
I want these numbers like this
Use C2=INDEX(Sheet2!$B$1:$B$61,MIN(IF(LEFT(A2,LEN(Shee t2!$A$1:$A$61))=""&Sheet2!$A$1:$A$61,ROW(INDIRECT( "1:"&ROWS(Sheet2!$A$1:$A$61))),"")))&A2 as array formula with the following sheets layout
So create a list like this in a sheet, say Sheet2
60 6 61 6 62 6 63 6 64 6 65 6 66 6 67 6 68 6 69 6 77 6 70 6 50 6 51 6 59 6 58 6 554 6 555 6 556 6 558 6 559 6 550 6 90 9 91 9 92 9 93 9 94 9 95 9 96 9 97 9 98 9 99 9 71 9 72 9 73 9 74 9 75 9 76 9 78 9 79 9 44 9 24 2 25 2 26 2 29 2 36 2 37 2 38 2 39 2 43 2 45 2 46 2 47 2 48 2 49 2 52 2 53 2 54 2 55 2 56 2 57 2
and in Sheet1 you have your list of phone numbers like this
Mobile Name 6051504 Peter 7162761 Chan 9633574 Andrew 2483957 Li
Attached example for reference
Wonderful
Very Good solution
thank you