LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Returning Column Header based on Row and Value Chad DiGregorio New Users to Excel 3 July 6th 09 07:09 PM
Returning multiple values that are NOT in a single column or row crispino Excel Worksheet Functions 8 April 24th 09 02:45 AM
Conditionally format header when column is filtered jday Excel Programming 2 March 3rd 09 09:26 PM
Returning Column Header [email protected] Excel Worksheet Functions 4 February 12th 08 04:00 AM
Returning column header as result Patricia Excel Worksheet Functions 4 July 6th 06 05:36 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"