Hi Sunny. Amazing again what you do. First you said you only could help on Q3 and after that you come with solutions for both the other two questions ...
Tricky one, but in your case it is: '#,#.K' (the custom format between the quotes). It's kind of contra-intuitive and I first used Mynda's page for...
Hi Troy, In the sheet where the error occurs, your reference to 'list' is to the A column and not to the proper CS column. I think when you fix th...
Hi Troy and Sunny, good to see Sunny provided a working solution for your case! You wrote: "how can I copy this formula to my master spreadsheet and g...
OK Troy, thanks for the hint to the explanation on this website! I converted it to your case and with this example, I hope you'll find your way. ...
Welcome on Myndas Forum Troy. You have four rows with words in column CY. Do you want to lookup on all those four? And where do you want to place the ...
Hi Mohamed, I made the time ranges in this example sheet a little different from your jpg, but you can do whatever you want of course if you unders...
Hi Brian, Welcome here at Mynda's Forum! There might be different ways to solve this. I tried it with a helper colomn D, where it gives a '1'...
Hi Elinor Ignacio, This is typical something for a Pivot Table. So I made a start for you to show you how that can work out. See attached file, tab...
Hi Lea, It's written in something else than English? Can't read it, can't help you. Sorry!
OK, this one is easy but for me a bit difficult to explain because I use Dutch language version and I'm not sure how thinks are called in the English ...
Hi Mitul Parikh, welcome here at Mynda's Forum... I think the purpose of these kinds of Forums is that you exchange the information on the Forum so...
Interesting! Can you explain how this works? (I see it does....)
Well the solution Sunny provided is exactly what I meant for this case. And I had seen this kind of solution (think in a video from Mynda), but couldn...