| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare a value and if is true copy the line to other worksheet
I have in worksheet 1 a list of names in order with more data, but there's
same places without a number, like this: 1 Mary AL 6665xxx 3 Peter PT 6654xx 4 William WE 12345xx 5 Henry SD 43564x 7 Mac SD 1442554 8 Dave OP 244234 10 Hank LS 343453 What I want is to make a new worksheet with all the numbers and the lines of the worksheet 1 with the same numbers must been copied to the new place like this: 1 Mary AL 6665xxx 2 3 Peter PT 6654xx 4 William WE 12345xx 5 Henry SD 43564x 6 7 Mac SD 1442554 8 Dave OP 244234 9 10 Hank LS 343453 Best regards. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare the value of 2 cells and get Flase/true statement | Excel Discussion (Misc queries) | |||
| compare data / MATCH(TRUE.. ROW.. | Excel Discussion (Misc queries) | |||
| copy an entire row IF a statement is true | Excel Worksheet Functions | |||
| ISTEXT TRUE then copy formula from cell X | Excel Worksheet Functions | |||
| Have a formula yield a true blank that disconnects graph line | Charts and Charting in Excel | |||
Threaded Mode
