| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can you display entire rows that match a certain criteria...
Not sure if this is possible so just want to throw the question out to you guys.
If I've got masses of data in say sheet1, could I in sheet2 use any kind of formula that would display every row of sheet1 where that meets a condition. i.e... In Cell A1 of Sheet2 : IF('Sheet1'A1=1, **DISPLAY HOLE ROW**) This could result in high number of matches for what I'm trying to do but is there any way that Excel could display all of these in rows B2:B*HOWEVER MANY MATCHES** Thoughts? Cheers. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Remove Rows that match a criteria | Excel Discussion (Misc queries) | |||
| Delete rows that do not match criteria | Excel Programming | |||
| Copying an entire row or Rows based on column criteria | Excel Programming | |||
| Deleting entire rows based on certain criteria | Excel Programming | |||
| Get rows which match selection criteria | Excel Programming | |||
Threaded Mode
