IdentifyTypes of Formulas in a given range

[dluhut]

Hey Excel Experts,

I'm just wondering if there's a way to identify type of formulas.

For example, Say that in cell A1:A10 we have the following formulas. And I want to check if my range of formulas are =SUM(range).

That means that, if the formulas are not =SUM(range), then I'd like it to 'identify' - it can be just a simple 'true/false' beside it, or a highlighted row.

I've highlighted the same color for the "same type" of formula.

=SUM(A1:A3)

=SUM(A2:A100)

=IF(A1=1,B1,0)

=IF(A2=1,B2,0)

=INDEX(Range,MATCH(1,Range,0))

=INDEX(Range,MATCH(A1,Range,0))

=1000/12

=IFERROR(VLOOKUP(A1,lookup,col_index,0),"")

=IFERROR(VLOOKUP(A2,lookup,col_index,0),"")

=5892/12

[Sam Capricci]

would formulatext work for you? it will show the formula in a cell so it would show, rather than the results of the formula, the way you show them in the post.

[dluhut]

but formula text will give me 'unique' right since =SUM(A1:A2) is not the same as =SUM(A2=A3) as an example

[Sam Capricci]

not necessarily unique, if you have (for some reason) =SUM(A1:A3) in B2 and =SUM(A1:A3) in B3 and you put =FORMULATEXT(B2) in C2 and =FORMULATEXT(B3) in C3 it will show both.
formulatext will show the formula as text that is in each cell you reference.

[63falcondude]

Try this in B1:

=IFERROR("=SUM("=LEFT(FORMULATEXT(A1),FIND("(",FORMULATEXT(A1))),FALSE)

Drag the formula down to B10.

Edit: Here's another one that will return TRUE if SUM is found anywhere in the formula:

=ISNUMBER(FIND("SUM",FORMULATEXT(A1)))