View Single Post
  #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'