Forum

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...

Hello, Welcome to MOTH. It is always better to upload Excel files than Word documents if you have some issues with Excel formulas. But let's giv...

Hello and happy new year! In order to get such rating average you need to calculate like this: 1. Multiply each response total with its rating v...

Hello Sunil, I hope below formula is what you are looking for. =(D4+E4)*IF(DATEDIF(B4,C4,"y")<5,0%,IF(AND(DATEDIF(B4,C4,"y")>=5,DATEDIF(B4...

Hello Charlie, My experience with using barcode and RFID scanners with Excel has not shown any problems other than that you sometimes need to defin...

Hello, I see no error in the attached file, nor do I see any index and match formulas either. Merry Christmas!

Hello, I am not sure I have understood your question correct, but I can at least advice you to not use that kind of data layout when gathering data...

Hello Laura, Welcome to this forum, I am pretty sure you will finf it resourceful. Try changing your formula a bit. As I am currently using a ta...