Formula or Code for writing the difference between the 2 highest number

[carole CD]

Good afternoon

I need some help with a file (betting scores). I need a formula or some code to be able to calculate the difference between the highest score (column W) and write it in front of the highest score in column Y.
But on the same page I have the different race (can be 7 or 15)I have empty rows between the races. If you do a code a need to go through every sheet in the workbook.
I have tried few thing but my code always come back like it's done nothing and my formula work if I give a range but I can not change all the time (daily file).

 

[Burrgogi]

Your photograph is missing row numbers. Assuming that your data starts on row 7, plug this into column Y:

=LARGE(W7:W13, 1)-LARGE(W7:W13, 2)

That's for the top section. Adjust the range as necessary for the bottom section.

 

[Burrgogi]

On further thought, that might not be the correct solution. You have 2 sections shown in that picture:
1) Amelia Park Plate
2) Bisley Workwear

Are you saying you want to find the highest number from each of the 2 respective sections I've listed and find the difference? Or are you saying you want to find the highest 2 numbers within each section and find the difference?

Some clarification from you would be nice.

=============================

EDIT: Nevermind. Use the 1st formula above if the case is the latter. On the other hand, if you mean the former use this instead:

=ABS(LARGE(W7:W13, 1)-LARGE(W22:W28, 1))

Note:
Please also make sure to include the row numbers in your original posting to make it easier for people to come up with a solution for you. I have no idea actual rows your data starts in so I had to take a best guess. Adjust the range in the formulas if necessary.

 

[carole CD]

Sorry for the rows. I need a formula without any specific range because i can have a lot of sections and i do not want to change all the time the formulas.

 

[Akuini]

Could you please post some example data as text instead of image, along with the expected results?
Please use the XL2BB tool to post your example or at least just copy your data and paste it here.

 

[Burrgogi]

Sorry for the rows. I need a formula without any specific range because i can have a lot of sections and i do not want to change all the time the formulas.

You don't want to deal with specific ranges??

The only solution would be to create named ranges for those sections like you have shown in your photo. (Or maybe a VBA solution instead).

Either way, you still have not answered my question above.

 

[carole CD]

I need to find the difference between the 2 highest within each section.

 

[carole CD]

Could you please post some example data as text instead of image, along with the expected results?
Please use the XL2BB tool to post your example or at least just copy your data and paste it here.

I can`t I am trying for few times before even sending my question

 

[Akuini]

I can`t I am trying for few times before even sending my question

Just copy your data (along with the expected result) and paste it here.
Something like this:

Name	No
Jack	2​

 

[carole CD]

							DOD	Points Total	No of 3's	High Pts Gap	Previous Form Points	Class
1​		AMELIA PARK PLATE [80,000]
		Type : 2 OPEN
11:59		1000m, TURF S(7)
Tab	Form L3	Wgt	Horse	BP	Jockey	Trainer
1	3x1	58.0	WEST STAR	5	CHRIS PARNHAM	S MILLER	-8	35	11		3	3
2	45x	58.0	BRAZEN BID	1	B PARNHAM	S MILLER	0	17	3		0	1
3	0x	56.0	SOUTHERN SCANDAL	2	W PIKE	DANIEL & BEN PEARCE	0	15	4		0	1
4	8	56.0	COONDLE	4	J WHITING	LOU LUCIANI
5	-	56.0	CAPORETTO	6	LUKE CAMPBELL (a2)	N PARNHAM	0	8	3		0	1
6	-	56.0	SALSA SMASH	4	J BROWN	J TAYLOR	0	9	2		0	1
7	-	54.0	FAVOURITE SONGS	3	JADE MC NAUGHT	LUKE FERNIE	0	6	2		0	1
2​		BISLEY WORKWEAR HANDICAP [80,000]
		Type : 2U BM78+
12:34		1000m, TURF S(7)
Tab	Form L3	Wgt	Horse	BP	Jockey	Trainer
1	846	59.0	BEADS	1	P HARVEY	S WOLFE	4	22	5		1	1
2	41x	58.0	YONGA LASS	7	W PIKE	G & A WILLIAMS	0	19	3		0	1
3	9x1	57.0	CASH AWAY	6	HOLLY WATSON	MISTY BAZELEY	2.5	26	7		3	2
4	17x	57.0	RUSSIAN TO THE BAR	5	CHRIS PARNHAM	LUKE FERNIE	0	20	4		0	1
5	90x	56.0	EEYORE WAYZ	4	P CARBERY	RAQUEL REID	0	18	5		0	1
6	x32	55.0	GODDESS OF GIVING	2	J WHITING	LOU LUCIANI	1.5	29	6		2	1
7	69x	55.0	TOP OF THE POPS	3	B PARNHAM	C & M GANGEMI	0	21	4		0	1
3​		NATIONAL PUMP AND ENERGY HANDICAP [60,000]
		Type : 2U 1MW
13:09		1000m, TURF S(7)
Tab	Form L3	Wgt	Horse	BP	Jockey	Trainer
1	25x	60.0	BAYEZID	2	MADI DERRICK (a1.5)	T ROBERTSON	0	25	6		0	1
2	421	59.0	CAPRE OMNIA	5	S PARNHAM	DYLAN BAIRSTOW	1.5	24	5		3	1
3	51x	58.5	BERBERE	4	W PIKE	G & A WILLIAMS	0	28	8		0	1
4	67x	57.5	OUR ROCKY BAY	3	B LOUIS	T MARTINOVICH	0	13	3		0	1
5	178	57.0	BARNEY'S WORLD	8	CHRIS PARNHAM	LUKE FERNIE	-0.5	26	6		1	2
6	x58	56.5	LITTLE STRAWBERRY	6	HOLLY WATSON	MITCHELL PATEMAN	3	19	4		1	1
7	65x	56.5	MISS DRAKOVA	7	B PARNHAM	N PARNHAM	0	20	4		0	1
8	0x6	56.5	ON THE FULL	1	LAQDAR RAMOLY	J TAYLOR	5	24	6		1	1

I need the result to be in the column Y (High Pts Gap)