Microsoft Excel Range

  beastieboy 14:03 28 Feb 03
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 03

Say they are in A1:D1

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

  beastieboy 14:06 28 Feb 03

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now