Hi All,
I'm working on a little fun project - but have come to a sticking point.
i'll give an example with a small data set:
in B11-B15 I have the name of a golfer in C11-T15 I have where I want the automation to happen (scores over 18 holes)
in C2-H2 I have a table of data (C2 is the min score on a par 3 for example 1, D2 is the maximum score on a par 3 for example 4 (E2-F2) will be par 4, min 3 max 5 (G2-H2) will be scores for par 5's, min 3 max 6)
in C9-T9 I have the Par of each hole (3-5)
At the moment I just have a manually typed Randbetween function
Example:
If hole one was a par 5 i'd have in C11 (for golfer 1) =RANDBETWEEN($G$2,$H$2) and just copy that down.
but the problem I have is when I change the pars for the holes in row C9-T9 i'll have to manually change the data in C11-T11 to match the par.
I'd ideally like the spreadsheet to look at the par of the hole C9 and then return the correct random number between the min and max values in C2-H2
So if hole 1 was a par 3 it would return a random number between C2-D2, for a par 4 E2-F2 etc...
Hope this makes sense - it's just a bit of fun and just can't put it down until I can work it out ))
I've looked at index,match,randbetween, vlookups all on Youtube and am close but just can't quite get it, so will make do with a manual function for now!
Thanks in advance for any input.
I'm working on a little fun project - but have come to a sticking point.
i'll give an example with a small data set:
in B11-B15 I have the name of a golfer in C11-T15 I have where I want the automation to happen (scores over 18 holes)
in C2-H2 I have a table of data (C2 is the min score on a par 3 for example 1, D2 is the maximum score on a par 3 for example 4 (E2-F2) will be par 4, min 3 max 5 (G2-H2) will be scores for par 5's, min 3 max 6)
in C9-T9 I have the Par of each hole (3-5)
At the moment I just have a manually typed Randbetween function
Example:
If hole one was a par 5 i'd have in C11 (for golfer 1) =RANDBETWEEN($G$2,$H$2) and just copy that down.
but the problem I have is when I change the pars for the holes in row C9-T9 i'll have to manually change the data in C11-T11 to match the par.
I'd ideally like the spreadsheet to look at the par of the hole C9 and then return the correct random number between the min and max values in C2-H2
So if hole 1 was a par 3 it would return a random number between C2-D2, for a par 4 E2-F2 etc...
Hope this makes sense - it's just a bit of fun and just can't put it down until I can work it out ))
I've looked at index,match,randbetween, vlookups all on Youtube and am close but just can't quite get it, so will make do with a manual function for now!
Thanks in advance for any input.