EXCEL VBA FUNCTION EXPERT - Need completion within 90mins
Budget: $10 – $30 USD
I Need a Excel VBA function to be written as follows:
The attached file is an example with fake data.
I need a function that will allow/create the following excel formula:
INTIMEBAND(person, time, bandsarray, [mins offset = default 0])
This function must return the Timeband name (string) or False if no applicable band was found.
mins offset is optional int.
so in the excel file cell C2 it would look like:
=INTIMEBAND(A2,B2,Bands!A1:D5,15)
The function should check the specified timebands and see where it matches the person and the time falls within the range. The range that the time should fall in should be start_band minus the specified offset and end_band plus offset minutes.
If the supplied person and time matches a band then we should return the time band name. as supplied to the function in parameter 3 array.
Basic flow:
loop thorough each supplied band and see if is matches person and if time falls into the band (including offset if specified).
If match then return band name
If no matches then return FALSE.
As mentioned above, the supplied file is an example. Final useage will be with actual person names and bands will contain more data. however I will ensure a person and band are unique and will not overlap. i.e. you WONT have A,05:00:00,10:00:00,BAND1 and another row with A,09:00:00,15:00:00,BAND2
Please let me know if you have any questions and I will clarify.
To show you have read this please start your reply with:
Yes, I can deliver this project in the next 90 mins and my BID amount is CORRECT!
The attached file is an example with fake data.
I need a function that will allow/create the following excel formula:
INTIMEBAND(person, time, bandsarray, [mins offset = default 0])
This function must return the Timeband name (string) or False if no applicable band was found.
mins offset is optional int.
so in the excel file cell C2 it would look like:
=INTIMEBAND(A2,B2,Bands!A1:D5,15)
The function should check the specified timebands and see where it matches the person and the time falls within the range. The range that the time should fall in should be start_band minus the specified offset and end_band plus offset minutes.
If the supplied person and time matches a band then we should return the time band name. as supplied to the function in parameter 3 array.
Basic flow:
loop thorough each supplied band and see if is matches person and if time falls into the band (including offset if specified).
If match then return band name
If no matches then return FALSE.
As mentioned above, the supplied file is an example. Final useage will be with actual person names and bands will contain more data. however I will ensure a person and band are unique and will not overlap. i.e. you WONT have A,05:00:00,10:00:00,BAND1 and another row with A,09:00:00,15:00:00,BAND2
Please let me know if you have any questions and I will clarify.
To show you have read this please start your reply with:
Yes, I can deliver this project in the next 90 mins and my BID amount is CORRECT!