View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Progster Progster is offline
external usenet poster
 
Posts: 3
Default Filtering on Formulas (makes messy sheets)

P.S. Advanced Filtering and formulas such as '=X2<=V2'

Is there any way, inside Excel, via a macro, or via an add-on, that I can
do filtering on such formulas (you can see I'm just comparing two values in
different columns) WITHOUT having to place the formula first into a cell in
the spreadsheet itself.

Alternatively, if someone can offer general advice about where to best place
such formulas so as to reduce the likelyhood of messing up the spreadsheet
now or in the future, I'd appreciate that advice.