27/03/2025

=SUBTOTAL(109, column name)

I am also going back to using power query and realised that that data guy from the NHS was a complete idiot lol. 

POWER QUERY

Comments

Post a Comment

Popular posts from this blog

FORMULAS I HAVE ALREADY LEARNT: =SUM =SUMIF =COUNTIF =UNIQUE =FILTER =SORTBY =IFNA =IFEEROR =VLOOKUP =XLOOKUP =SUBTOTAL =RIGHT/=LEFT =CONCATENATE =TEXT =MONTH/=YEAR
Read more
 SHORTCUTS I HAVE LEARNT 04/04/2025:   Format Painter Shortcut (Keyboard): 🔹 Alt → H → F → P (αλτχουφουπου) ✅ AutoFit Row Height: Alt + H + O + A (αλτχόα) ✅ AutoFit Column Width: Alt + H + O + I (αλτχόι) ✅ Alt + O + A → AutoFormat (αλτοέι)
Read more