Completely stuck with the following - & it's a little hard to explain! (it might require VBA)
I'm trying to copy & paste my raw data (G1:J26) - using the time as a reference - into A1:D171 (i.e. if 14:30, paste HH, T, 4 (drag down for all values of 14:30))
I've added the ideal result into M1:P171
Any questions feel free to ask
Mdn
At 14:20, it is H,A,5 but why you expect it to be H,A,4 and H,A,6 (range M14:P15)?
Quang PT
That's a good spot
That's my mistake. H, A, 5 is what it's meant to be
In B2, then drag down and accross
Please Login or Register to view this content.
Amazing stuff, really appreciated bebo
bebo Please explain the above for my understanding.
There's a very thorough explanation here: http://www.excelforum.com/excel-form...ml#post3398950
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks