Spotting Breaks in Formulae Progressions

  • Thread starter Thread starter TC
  • Start date Start date
T

TC

Something I was taught a few years back and can't remember
how to do:

Can anyone remind me how to get Excel to recognise and
highlight where sequences of formulae within spreadsheets
appear inconsistant and don't seem to follow the pattern
of the rest the sheet?

It's REALLY bugging me!

Thanks in advance,

TC
 
Hi TC!

I think that you might be referring to switching to R1C1 style
referencing.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi TC

Select the row/column and go to Edit / Goto / Special / and select Row
differences or Column differences.

Andy.
 
Back
Top