| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula captures specified rows of data?
I need to capture rows of information from a worksheet, where the only
specific identification in the row would be (say) a word "Hot". I expect to have a quantity of rows of data (say) 20 rows, in one column each row would say either "Cold", "Warm" or "Hot" I would like to create a 2nd sheet that captures ONLY the "HOT" rows? Is this possible? Can anyone point me to reference material or examples please. Thank you in advance for your time... Kind Regards, Brian I am using MS Excel XP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sharing rows of data across multiple worksheets within a workbook | Excel Worksheet Functions | |||
| Matching Date From Two Groups | Excel Worksheet Functions | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
