Hello all,
Excuse me if I am in breach of any etiquette by posting this here (I am somewhat new to this site) -let me know if I am.
I have a question on summing absolute differences, I am looking for a slightly more elegant solution than the one I have currently
=SUM(ABS(C$73-C$72),ABS(C$72-C$71),ABS(C$71-C$70),ABS(C$70-C$69),.....
Please note, I'm not trying to sum absolute differences between each pair in the range, only differences between adjacent pairs
Any help/guidance much appreciated!
Thanks
Bookmarks