| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to identify text from a autofiltered list using formulas
I have a worksheet with 8 columns of information.
I am using the AutoFilter command to display only specific information from the list. Is there a way, using formulas, to extract information from only the displayed data? Ex: One of the columns being sorted contains state names, using the Autofilter command, data for the state of New Jersey is displayed. Is there a way, using formulas, to extract the state name from the displayed data so it can be used in concatenating descriptions and used as a lookup criteria in other formulas? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converting concatenated text strings into formulas | Excel Worksheet Functions | |||
| display text depending on coice from drop down list | Excel Discussion (Misc queries) | |||
| add text to cell by clicking a choice in drop down list | New Users to Excel | |||
| need a refresher: text boxes on charts that use relational formulas? | Charts and Charting in Excel | |||
| Counting Repeated text or duplicates in a list | Excel Discussion (Misc queries) | |||
Threaded Mode
