Key Assign Function

%3CLINGO-SUB%20id%3D%22lingo-sub-2560023%22%20slang%3D%22en-US%22%3EKey%20Assign%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2560023%22%20slang%3D%22en-US%22%3E%3CP%3ESo%20I'm%20trying%20to%20find%20a%20way%20to%20have%20Excel%20assign%20a%20Key%20%23%20(For%20this%20instance%20it'd%20be%20something%20like%20Keys%20%231-5)%20for%20a%20specific%20TMR%20%23%20line%20based%20on%20availability.%26nbsp%3B%20So%20for%20instance%20if%20Key%20%231%20is%20out%20on%20the%20first%20TMR%2C%20and%20it's%20return%20time%20is%20greater%20than%20the%20report%20time%20for%20the%20next%20line%2C%20it%20would%20issue%20out%20Key%20%232.%20However%2C%20if%20Key%20%231's%20vehicle%20return%20time%20is%20before%20the%20vehicle%20report%20time%20for%20the%20second%20TMR%20then%20it%20would%20be%20reused.%26nbsp%3B%20Hopefully%20someone%20out%20there%20might%20know%20a%20solution.%20Unfortunately%20my%20systems%20administrator%20has%20disabled%20macros%20for%20our%20excel%20usage%20as%20well.%26nbsp%3B%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2560023%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2560162%22%20slang%3D%22en-US%22%3EBetreff%3A%20Key%20Assign%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2560162%22%20slang%3D%22en-US%22%3EWith%20your%20permission%2C%20if%20I%20can%20recommend.%20It%20can%20help%20us%20all%20if%20you%20upload%20an%20Excel%20file%20(without%20sensitive%20data)%2C%20no%20picture.%20Even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20cases.%20You%20could%20get%20a%20precise%20solution%20much%20faster%20with%20a%20file%20(w%2Fout%20sensitive%20data).%20This%20would%20also%20be%20a%20blessing%20for%20all%20of%20us%2C%20as%20we%20can%20understand%20the%20problem%20much%20better%2C%20a%20win-win%20situation%20for%20everyone.%3CBR%20%2F%3EKnowing%20the%20Excel%20version%20and%20operating%20system%20would%20also%20be%20an%20advantage.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%20for%20your%20understanding%20and%20patience%3CBR%20%2F%3E%3CBR%20%2F%3EWish%20you%20a%20nice%20day.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
New Contributor

So I'm trying to find a way to have Excel assign a Key # (For this instance it'd be something like Keys #1-5) for a specific TMR # line based on availability.  So for instance if Key #1 is out on the first TMR, and it's return time is greater than the report time for the next line, it would issue out Key #2. However, if Key #1's vehicle return time is before the vehicle report time for the second TMR then it would be reused.  Hopefully someone out there might know a solution. Unfortunately my systems administrator has disabled macros for our excel usage as well.  Thank you!

2 Replies
With your permission, if I can recommend. It can help us all if you upload an Excel file (without sensitive data), no picture. Even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some cases. You could get a precise solution much faster with a file (w/out sensitive data). This would also be a blessing for all of us, as we can understand the problem much better, a win-win situation for everyone.
Knowing the Excel version and operating system would also be an advantage.

Thank you for your understanding and patience

Wish you a nice day.

Nikolino
I know I don't know anything (Socrates)
Thank you for the suggestion; I've uploaded it while also striking the sensitive data. Hopefully it still makes sense by replacing locations with numbers and times with past dates and times.

Thank you!