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