Why would it matter? I can enter two similar formulas without copying. I
think your question should be can you recognize that a formula is used more
than once in a workbook. It is extremely difficult unless you are looking
for an EXACT match. You can check to see if specific locations are
referenced like "B4" but you have problems if it is reference in different
sheets like Sheet1!B4 verses just B4. If you search for B4 you will get both
locations.


"Bony Pony" wrote:

Hi everyone,
Happy New Year to all who believe that sort of thing!

Is there an easy way to determine if adjacent formulas are copied or unique?
Or perhaps the question is - Is someone willing to share an easy way of
determining if adjacent formulas are copied or unique?

Thanks in advance!
Bony