Filter by Formula

[danieley]

Hi. My worksheet has three different formulas in the same column. Can I somehow filter this column by formula? Thanks.

 

[CharlesChuckieCharles]

Do they produce different results as in if you changed the formula in a cell for one of the others would you get a different result?

 

[danieley]

Yes. I am using the column in a concantenation. So there are three different formulas that produce different results within the same column. I really need to keep the formulas visable when I highlight the cells so I can track my work but it would be very beneficial if I could filter down that column strictly by one of the three formulas. Hope this makes sense.

 

[CharlesChuckieCharles]

if you know a little vba

Paste the following into a new module

Public Function CellFunc(meme As Range) As String
On Error Resume Next
CellFunc = ""
If meme.HasFormula Then
   CellFunc = meme.Formula
End If
 
End Function

Then compile
and then save



in the spreadsheet Use it as

=CellFunc(A1)
it returns, as text, the formula in A1

 

[mikerickson]

You might use GET.CELL in a helper column.
http://www.mrexcel.com/forum/showthread.php?t=20611

If your formulas are in column B, select C1 and define this name
Name: bFormula RefersTo: =GET.CELL(6, Sheet1!$B1) (note the relative reference)

then put the formula =bFormula in C1, drag down and sort on column C.

 

[danieley]

Thanks for the help. I am working on these now.