difference between the hi & low number in a column 2

[jhetfield]

I have three numbers in a column (ex. A1, A2, A3) then I have a blank row & then three more numbers, etc. Each 3 row group is a set. The number amounts are random. I'd like to be able to get the difference between the highest number and the lowest number to fill in the blank row below each set. Is there a way to search three numbers and provide the difference between the highest and lowest number. I could then cut and paste that formula after each 3 row set.

Thanks in advance

 

[Molby]

You want the min and max functions.

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

 

[KenWright]

You already have your answer on the functions, but if you want to save yourself some work in copy/paste effort, then put that formula in the first blank, copy the cell, then selecet the entire range of data in Col A and do edit / Go To / Special / Blanks, then do Edit / Paste

Regards
Ken................

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission

----------------------------------------------------------------------------