Ctrl F to find array functions

[petereddy]

Hi,

If I want to find links to another sheet in a workbook, I search for "!". If I want to find links to other workbooks, I search for "[". I tried searching for "{" and "~{" to find an array formula, but they didn't work.

I'm trying to paste formatting from one table to several other tables, but Excel's not allowing it since there's apparently an array formula in the range (which is stupid, since formatting doesn't affect formulas, but that's beside the point), so I'm trying to figure out how to find it. I suspect it's a TRANSPOSE formula, so that's what I'll search for next, but is there a more general solution?

Thanks.

Peter

 

[ChrisFoster]

Try searching for "{*}"

 

[petereddy]

Try searching for "{*}"

Didn't work for me. Did it for you?

 

[ChrisFoster]

I haven't actually tried it, but the curly braces are used to identify array formulas, and the asterisk is a wildcard that will match any text within the braces so that should work.

 

[Fluff]

I haven't actually tried it

Then maybe it would help if you had.

Unfortunately there is no way, that I know of, for finding array entered formulae

 

[ChrisFoster]

Then maybe it would help if you had.

Unfortunately there is no way, that I know of, for finding array entered formulae

Ok fair enough, sorry.