Consolidating sheets without Power Query

[@RenierWessels]

Thanks Dim. I enjoyed your solution. That IF(SEQUENCE trick was a new learning for me. Thanks for taking the time!

[@DimEarly]

That's worth remembering - very handy for adding the labels when you unpivot anything (i.e. not just multi-sheet stuff like this). Thanks for the case, it was a good one!

[@RenierWessels]

@@DimEarly thanks Dim 🙏🏻

[@drkazza5533]

This was great - but have you ever tried CTRL-# quick formatting to dd-mmm-yy would have made the bit at 17:00 much cleaner to work out what month it is. Given I work with sheets from Americans and RoW it's been a lifesaver

[@DimEarly]

Yes, I use it all the time! The challenge here was that I was comparing one date formatted as a date (which meant it adapted to my settings) with another date that was part of a text string (which meant that it didn't). I misinterpreted the fact that the dates were in 'my' format to mean that they had been written that way, but it was just Excel adapting to my settings.

[@Simon-vc1wk]

Amazing

[@sledgehammer-productions]

So now it's *Dark* magic? I'll follow you to any light intensity 😉

[@DimEarly]

😂

[@billash5132]

V stack across tabs 😮

[@DimEarly]

This is the appropriate reaction! : )