Forum

Please see attached. It's not a very neat solution but it works with the example you provided. Start by unpivoting the table and tidy up a bit. The...

This occurs as you are referencing an array in the IF condition. I assume you enter the formula in B16. Excel compares each cell in A10:A15 to the ...

That's by design, but you can hide the slicer buttons if there is no data for them. Select the slicer, then on the Slicer ribbon press Slicer Setti...

Hi, The query in your file connects to a Table1 that is not part of the file. That makes it difficult to follow through what you are trying to achi...

Think of it this way. DataTbl is your very first empty table. You append the DataEntryTbl table and load it back to Excel. That table is now called...

I haven't been able yet to resolve the issue, though I could create a pivot table that identifies the sensors for each base value. See if this is some...

When I open your file and look at the formula in A2 I see this: =DATE(M2,M4,1) & " " & TEXT(M6,"gggg") & MID(A2,1,5) Let's break thi...

There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.

The easiest way to convert 24.05.2029 in A2 to 24/05/2019 would be to use SUBSTITUTE =DATEVALUE(SUBSTITUTE(A2,".","/")) Do the same for the end ...

Same thing here! Doesn't seem to do anything.

The error message did not come through. Please try again.

I couldn't replicate your issue with files of my own. Can you upload three or four of your files (remove anything confidential but leave their structu...

Could you share a file please?

Hi Pieter, You can automate the helper column so that you don't need data validation with Yes,No on every row. Use SUBTOTAL to count the number of ...

The attached file contains a pretty straight forward solution. It makes no used of more advanced techniques but I believe it will work just fine in th...