FORMULAS I HAVE ALREADY LEARNT:

=SUM

=SUMIF

=COUNTIF

=UNIQUE

=FILTER

=SORTBY

=IFNA

=IFEEROR

=VLOOKUP

=XLOOKUP

=SUBTOTAL

=RIGHT/=LEFT

=CONCATENATE

=TEXT

=MONTH/=YEAR



Comments

Post a Comment

Popular posts from this blog

 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
 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
Read more