I just want to convey that the content of this site is completely copyright free. You can use the content the way you want without seeking any permission. Whether you are using it commercially or non-commercially, personally or within your organization, it doesn't matter. There is no need to give any acknowledgement either that you…
Tips & Tricks 210 – Sort Month Name
Formula to be used =SORTBY(A2:A13, –(1&A2:A13)) Sample File – T&T_210
Excel Quiz 62
Tips & Tricks 209 – Not Common in A and B both
Formula to be used =UNIQUE(TOCOL(A2:B9),,1) Sample File – T&T_209
Excel Quiz 61
Tips & Tricks 208 – Present in A but not in B
To find if an entry is present in one column but not in another =UNIQUE(VSTACK(A2:A9,B2:B9,B2:B9),,1) =FILTER(A2:A9, ISERROR(XMATCH(A2:A9,B2:B9))) =FILTER(A2:A9, COUNTIF(B2:B9,A2:A9)=0) Sample File – T&T_208
Excel Quiz 60
Challenges have a new Home
I have been posting daily challenges on Linkedin since last 3 years. You can access more than 1000 Excel + Power Query Challenges here. The best part if learning by reading through the solutions posted by other leading experts. https://www.linkedin.com/in/excelbi/
Tips & Tricks 207 – Common Across Two Columns
Following formulas can be used to find common entries across 2 columns =TOCOL(XLOOKUP(A2:A9,B2:B9,B2:B9), 2) =FILTER(A2:A9, COUNTIF(B2:B9, A2:A9)) =FILTER(A2:A9, IFNA(XMATCH(A2:A9,B2:B9),)) Sample File – T&T_207
Tips & Tricks 206 – Running Total Using Dynamic Arrays
Running Total for a Range = SCAN(, A2:A10, SUM) Running Total for a Filtered Range = SUBTOTAL(9, TAKE(A2:A10, SEQUENCE(ROWS(A2:A10))))