Forum

Hello Gary, I used an INDEX & MATCH formula to get the value for cell I2. Use conditional formatting on the cell to catch the correct colour ba...

Hello, Seems likely to be some macro code that causes this. Did a search and found this topic in a different forum. Perhaps it can help you forward...

Hello, You need to use VBA to build such solution, but just so you know, it is not secure as it can be cracked easily. I just did a web search for ...

Hi, Something like this?

Hi Dave, I have ungrouped the date and have instead formatted the view using with ordinary number formatting. Even though you see the dates in the ...

Hello Jay, I think you will find the answer in this blog post.

Hello David, I am not sure I understood your question to the fully, but let's do a try. Please see attached file for an example. I have put your...

Hello, I would really suggest you to reconsider your design, why have two identical worksheets when you can have one? For more guidance in how t...

Hello Julie, A strange problem indeed. The reasons to this kind of behaviour can of course be several, below scenario is based on my own experience...

Hello, Please see attached example.

Hello, The problem with your approach is that you need to tell Excel where to look and I can imagine that next time a laptop is populating the list...

Hello, I can not replicate this scenario with a table, but with a range looking as a table, i.e. a table that has been converted to a range. If I t...

Hello Daneille, Please take a look at this nice blog post, you will find your answer there. In regard to the linked article, I find the Index &...

Hello Julie, There is no file attached.

Hello Frans, Nothing to be sorry about, the more replies the better. It is always nice to see different solutions and approaches to a problem and y...