| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Selecting rows with the same criteria
Dear All,
I got a list of data like: A B C D 1 1 ABC 55 Wilson 2 AFD 60 Adams 3 1 DGC 76 Korinth 4 AFV 83 Smith 5 1 URD 45 Hertz .... and I would like the Excel automatically compose table on a new sheet that will show all rows with "1" in A column. Without Pivot Table. In other words, what formula should the cell in new sheet have to choose the first row with "1" then the next "1" and etc. Rgds, Ruslan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting Rows that meet criteria | Excel Worksheet Functions | |||
| Selecting data that matches certain criteria in one column | Excel Discussion (Misc queries) | |||
| after selecting 50 rows of a column i can't reference the cells in the rows | New Users to Excel | |||
| Selecting rows based on criteria | Excel Discussion (Misc queries) | |||
| Selecting a criteria range over two sheets? | Excel Discussion (Misc queries) | |||
Threaded Mode
