Hi Elinor, As I understand you want on your sheet 2 the information of the different Plate No's as presented, where the information comes from shee...
Ah, of course! I compared the two values in this table. But you're right (of course) it's budget versus actual which made it confusing. Thanks! Fra...
Sorry, for the second time in a short time I was too fast with my question. Found the answer here in the PivotTable section (information of Mynda's...
I sometimes encountered the similar problem. In your case Excel can calculate with the dates in column A! (put another date in column B and substract ...
I think Mynda will come up with her statement that this is something typical for Power Query 😉 Not sure, but when you have your three worksheets....
Maybe it's an idea you color the cell before you leave that one? And then after finishing the work remove the color from all colored cells. And ...
Nice one Sunny. I would have thought about adding an extra column to the data and from there show it in the Pivot Table. But your solution sticks b...
As far as I know you can't with the normal Excel functions. Depending on how the different cells became red you can think of making a normal or nes...
I was thinking if it might be possible you touched some different Shortkey (other than Ctrl-V for instance) which might causes this? I'm not so famili...
Hi Lea, Not sure why you want to go for the pivot table? Here a possible solution with summing the countifs. It doesn't look nice, but works goo...
Learned something again Mynda! Thanks!
I think it doesn't work because you give two criteria on the same column. If you evaluate the formula, you'll see that it finds the first criterium (F...