LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RBG RBG is offline
external usenet poster
 
Posts: 9
Default Creating Formulas from Filtered Data

I am trying to create a formula, say in cell B1 that would return the same
info that is returned from my filter. For example if i filter my data on
colors and I return a 'red' result, I would like cell B2 to read 'Colors -
Red'
 
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
Applying formulas to filtered data Keith Excel Discussion (Misc queries) 4 August 2nd 07 05:02 PM
Creating a numbered list on a filtered worksheet Louise Excel Worksheet Functions 12 May 3rd 07 02:40 AM
Formulas, for filtered worksheet Paul S Excel Discussion (Misc queries) 0 March 1st 07 05:50 PM
creating a filtered list ASU Excel Discussion (Misc queries) 1 September 14th 06 10:59 AM
Help to sort out filtered data from the data contained in another sheet of the same workbook No News Excel Worksheet Functions 1 July 28th 06 04:04 PM


All times are GMT +1. The time now is 07:26 AM.

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"