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
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Wonderful
Very Good solution
thank you
Posting Permissions
Reply With Quote
Bookmarks