Maybe the error message tells you more: it gives the yellow triangle and the hoover over text is something as: "Due to move or delete there is an unva...
Yes of course I'd better make an example, but after trying again now for more than half an hour I quit. Because of named tables, lot's of vlookups ...
Thanks both Sunny and Catalin! This helps a lot. I need to figure out the working of your suggestion Catalin and see what it exactly does. Difficul...
Two questions now I'm working with this solution nr. 3. First I see it's an array formula and it works perfect (luckily I learned here at the MOTH ...
Hi Sunny, You're the man again! I downloaded earlier today, but due to strange behaviour of the website here on te workplace I couldn't reply at th...
Maybe this is the way to your solution. Hope you understand how it's build up as an example.
It's not clear to me what you want to achieve with the =M4-J4? Is it part of the first formula (an extra check or such?). Or do you want to calcula...
Don't understand you, I think. When you import your data in Excel, you can already have an Excel-table ready where you import the data in. In th...
maybe not the solution you're looking for (don't know if that is possible, I doubt it): is it possible to add a new column to your raw data in which y...
Catalin is right of course, but maybe the question is: can I 'translate' time format to normal numbers for instance to make calculations with? The ...
Tricky one, Mey. As I see it your data isn't consistent in the way that one set of rows sometimes is 10 rows and sometimes 11 rows big. You can ...
Hi uhrskov, Maybe this is a starter for you. On the lookup tab I first check if the number in column A exists in the next sheet. If it does, the...
I hope I understood you correct. Please see my example and look if this is what you are looking for.