INDEX & MATCH! I'll bet Zubin loves this one 🙂 🙂 Clever though!
Best wishes to you and the people who are near to you as well! And I understand your motivation and agree with it. On the other hand I doubt it if not...
And as an extra with drop down list! 🙂
Beautiful solution as always Sunny! And exactly what Zubin wanted. However I would prefer working with variables for the grade/percentage and date....
I think Sunny has the most simple and efficient solution for this case. But I wondered maybe David wants a weeklist and then only the Tuesdays and Wed...
Hi Adrian, Try this it will help you Conditional Formatting with a formula Good luck!
As I understand it: The identifier is the unique key? Then you can use probably the Vlookup on the summarize sheets, depending on which identifiers...
Tricky one, also because of the exceptions. Was thinking of the 'day' function works here also? I try some things out, but that'll take some more time...
OK, thanks. That 'SLA' I was searching for was only in the name of the attachment, so (?) it wasn't found.... 🙂 Tricky case. My reaction is there...
I'm not familiar with the PQ you're talking about and also not with the snapshots you make, but one thing came in mind when reading your case. Is i...
Everybody learns in his/her own way, that first. But I think Mynda is right: look the video first complete. If something isn't clear with the first...
I remember that case, but can't find it back to have a look again if I know something. Can you give the link?
Oh no a misunderstanding: I'm using 2013 and 2016/365, but I wondered because the guy who asked it probably used the 2003 version as you noticed yours...
I was thinking of some conditional formatting with the colors green (improving), yellow (constant) and red (dropping). But I'm not sure if this is ava...
Hi Sunny, Nice solution your second one! Didn't know how to use the 'time' function in a clever way and here it is. Only thing is (of course) you h...