| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Searching equations
Is there a formula that can identify if a cell is using a particular function
- example mid() ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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() ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equations appear as text | Excel Discussion (Misc queries) | |||
| Equations | Excel Discussion (Misc queries) | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| How can I do a system of equations? | Excel Discussion (Misc queries) | |||
| Function equations | Excel Worksheet Functions | |||
Linear Mode
