Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning value from single row of filtered table, given the column header
Hi, I have a table of data by regions (regions are the column headers) that is always filtered to return only one valid row of data. If a region is selected in elsewhere in a cell, I'd like to be able to return the relevant value from the single row of the filtered table. Any suggestions appreciated.. TIA
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning value from single row of filtered table, given thecolumn header
I've found that the SUBTOTAL function is useful because it works with filtered data, ignoring filtered values. So far, it looks like this:
=SUBTOTAL(9, Tbl_AreaCover[Area 1]) I need to replace [Area 1], which is a fixed column of the Tbl_AreaCover table, with a value selected in a cell, so that the formula is dynamic. Any suggestions? TIA. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning value from single row of filtered table, given thecolumn header
I have replaced Tbl_AreaCover[Area 1] with INDIRECT("Tbl_AreaCover[" & SelectedArea & "]", but find SUBTOTAL inadequate for text values. So I'm still stuck.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Column Header based on Row and Value | New Users to Excel | |||
Returning multiple values that are NOT in a single column or row | Excel Worksheet Functions | |||
Conditionally format header when column is filtered | Excel Programming | |||
Returning Column Header | Excel Worksheet Functions | |||
Returning column header as result | Excel Worksheet Functions |