Searching equations
 

Is there a formula that can identify if a cell is using a particular function
- example
mid() ?

Searching equations
 

Hi,

None built into Excel, you could probably write a VBA function to do this.
How are you going to handle long, complex formulas as for example:

=IF(ROW(A1)COUNTIF(B$1:B$10,E$1),"",(SMALL(IF((B$ 1:B$10=E$1)*A$1:A$10<0,(B$1:B$10=E$1)*A$1:A$10,"" ),ROW(A1))))

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Brad" wrote:

Is there a formula that can identify if a cell is using a particular function
- example
mid() ?