Using formulas to create 3 rows of spacing between different events

R

RUMPOLE

New Member
Joined
Oct 4, 2017
Messages
25
Hi

I have a excel data set which is data on horse racing in the UK.

The data set is listed row by row, with each horse in the race listed one after the other.

When the data for the next race begins, it starts on the row immediately below the previous race. This is my problem

I would like to create 3 lines of spacing between each race, using formulas. So this would mean creating another worksheet that is a replica of the original data sheet, but which is entirely formula based, with 3 lines of spacing between each race.

The data set has the time of the race as one of the data fields, which I was using as the identifier as to where the spacing should go, in my attempts to solve the problem myself.

I have attached a link to a photo of the data set, as I could not work out how to upload a excel file sample set

The solution has to be formula based, as the workbook cannot cope with macros.

The link to the data set jpeg is directly below.

https://imgur.com/a/KYVum6H

Any assistance greatly appreciated.

Kind Regards
Rumpole.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
Sort by date Sort by votes
We cannot manipulate data in a picture. Please use XL2BB (look in my signature) to upload your sample data.
 
Upvote 0
Data Set for Spacing.xlsx
ABCDEFGHIJKLMNOPQ
1Course countryCourse dateAbandonedRunnersNon-runnersCourse nameCourse timeHorse nameCourse countryCourse dateAbandonedRunnersNon-runnersCourse nameCourse timeHorse name
2EnglandSunday July 5, 2020FALSE70Haydock12:00CobhEnglandSunday July 5, 2020FALSE70Haydock12:00Cobh
3EnglandSunday July 5, 2020FALSE70Haydock12:00ShobizEnglandSunday July 5, 2020FALSE70Haydock12:00Shobiz
4EnglandSunday July 5, 2020FALSE70Haydock12:00Serious IntentionEnglandSunday July 5, 2020FALSE70Haydock12:00Serious Intention
5EnglandSunday July 5, 2020FALSE70Haydock12:00UbariEnglandSunday July 5, 2020FALSE70Haydock12:00Ubari
6EnglandSunday July 5, 2020FALSE80Haydock12:30Bungee Jump
7EnglandSunday July 5, 2020FALSE80Haydock12:30Dark Regard
8EnglandSunday July 5, 2020FALSE80Haydock12:30Magical Journey
9EnglandSunday July 5, 2020FALSE70Haydock13:00Brad The BriefEnglandSunday July 5, 2020FALSE80Haydock12:30Bungee Jump
10EnglandSunday July 5, 2020FALSE70Haydock13:00Snazzy JazzyEnglandSunday July 5, 2020FALSE80Haydock12:30Dark Regard
11EnglandSunday July 5, 2020FALSE70Haydock13:00BielsaEnglandSunday July 5, 2020FALSE80Haydock12:30Magical Journey
12EnglandSunday July 5, 2020FALSE70Haydock13:00Fighting IrishEnglandSunday July 5, 2020FALSE70Haydock13:00Brad The Brief
13EnglandSunday July 5, 2020FALSE80Sandown13:15Risk Of ThunderEnglandSunday July 5, 2020FALSE70Haydock13:00Snazzy Jazzy
14EnglandSunday July 5, 2020FALSE80Sandown13:15Jojo RabbitEnglandSunday July 5, 2020FALSE70Haydock13:00Bielsa
15EnglandSunday July 5, 2020FALSE80Sandown13:15NorthboundEnglandSunday July 5, 2020FALSE70Haydock13:00Fighting Irish
16EnglandSunday July 5, 2020FALSE80Sandown13:15Tanfantic
17EnglandSunday July 5, 2020FALSE80Sandown13:15Significantly
18EnglandSunday July 5, 2020FALSE80Sandown13:15Gussy Mac
19EnglandSunday July 5, 2020FALSE170Haydock13:30Young MerlinEnglandSunday July 5, 2020FALSE80Sandown13:15Risk Of Thunder
20EnglandSunday July 5, 2020FALSE170Haydock13:30TheatroEnglandSunday July 5, 2020FALSE80Sandown13:15Jojo Rabbit
21EnglandSunday July 5, 2020FALSE170Haydock13:30Monsieur LambraysEnglandSunday July 5, 2020FALSE80Sandown13:15Northbound
22EnglandSunday July 5, 2020FALSE170Haydock13:30Night Of GloryEnglandSunday July 5, 2020FALSE80Sandown13:15Tanfantic
23EnglandSunday July 5, 2020FALSE170Haydock13:30Gabrial The OneEnglandSunday July 5, 2020FALSE80Sandown13:15Significantly
24EnglandSunday July 5, 2020FALSE80Sandown13:15Gussy Mac
25
26
27
28EnglandSunday July 5, 2020FALSE170Haydock13:30Young Merlin
29EnglandSunday July 5, 2020FALSE170Haydock13:30Theatro
30EnglandSunday July 5, 2020FALSE170Haydock13:30Monsieur Lambrays
31EnglandSunday July 5, 2020FALSE170Haydock13:30Night Of Glory
32EnglandSunday July 5, 2020FALSE170Haydock13:30Gabrial The One
RatingTheRaces-Races-2020-07-05
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
Extract Data from Row
Replies
5
Views
276
Fluff
Fluff
C
  • Question
Index Match formula help
Replies
1
Views
245
Alex Blakenburg
A
G
  • Question
Embedded Range or Array Lookup
Replies
5
Views
348
Fluff
Fluff
K
  • Question
Conditional Formating - Dynamic "not between"
Replies
3
Views
236
dreid1011
dreid1011
O
  • Question
Running through a Config and pulling out the relevant information using keywords into smaller sheets
Replies
0
Views
119
oitbc
O

Forum statistics

Threads
1,214,424
Messages
6,119,400
Members
448,893
Latest member
AtariBaby

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top