Is there a formula that can identify if a cell is using a particular function - example mid() ?
B Brad Mar 4, 2009 #1 Is there a formula that can identify if a cell is using a particular function - example mid() ?
S Shane Devenshire Mar 4, 2009 #2 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))))
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))))
