Microsoft Excel Range

  beastieboy 14:03 28 Feb 2003
Locked

Hi,

I have a row of numbers with different values, I want to create a function which automatically creates the difference between highest and lowest number.

Cheers.

Janusz

  VoG™ 14:05 28 Feb 2003

Say they are in A1:D1

=MAX(A1:D1) - MIN(A1:D1)

  beastieboy 14:06 28 Feb 2003

Just figured out how to do it as soon as I posted it - cheers though

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?