April 2020 – PKTechXel

Advanced Filter in Excel

Post author:Pankaj Kumar
Post published:12th April 2020
Post Category:Other Excel Tips
Post Comments:1 Comment

The advanced filter is the best solution for the multi-criteria filter. Instead of using basic filter function of MS Excel and applying filter at multi level one by one you…

How to compare two Lists in MS Excel

Post author:Pankaj Kumar
Post published:10th April 2020
Post Category:Formula
Post Comments:0 Comments

There are many ways to compare two lists but the easiest way to compare two lists is by using conditional formatting with the help of "Countifs" function. You can follow…

Advanced Filter in Excel
How to compare two Lists in MS Excel