| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select rows that has particular number in Col D
In my Column D i have numbers. Normally most of the rows for Col D will have single numbers eg 2 or 12 or 22 and so on. However on some occasion it will have more two or more number eg 2, 4,12. The numbers in the cell are separated by commas.
Example Col D Row1 1 Row2 4 Row3 2,12 Row4 11,1 Row5 2,1 Row6 3 Row7 21 Row8 1,11,15 Row9 10,1,9 Row10 1,16 How can I select all the rows that has in Col D the number 1 ie in the above example it would select row1,row4,row5,row8 and row10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select Large Number of Rows | Excel Discussion (Misc queries) | |||
| Using VBA to select dynamic number of rows | Excel Programming | |||
| Select number of rows in a graph? | Excel Programming | |||
| select block of rows w/data between blank rows | Excel Programming | |||
| Unable to select rows in the repeat rows on top option | Excel Discussion (Misc queries) | |||
Threaded Mode
