Accounting Pakistan

20/11/2023

Excel Pro Tricks: XLOOKUP to return Multiple Columns and Rows in Excel formula with XLOOKUP Function

Follow https://bit.ly/3HseKDn for daily Excel tips

04/05/2023

Make Excel Charts with Threshold / Target Range / Bands in the background
Follow https://bit.ly/3HseKDn for daily Excel tips

22/03/2023

Dynamically extract columns from multiple ranges
Watch: https://youtube.com/shorts/_j59rir3G0E
Subscribe: http://bit.ly/3z2rzRw

16/12/2022

SUM + XLOOKUP: Learn Three-way XLOOKUP to SUM values!
https://youtube.com/shorts/eWjRIjdHXbs
Subscribe: https://bit.ly/3z2rzRw

09/12/2022

Find and Return Differences between two lists in Excel
https://youtube.com/shorts/5kLod2-Aug8?feature=share
Subscribe: bit.ly/3z2rzRw

08/12/2022

Excel Drop down lists WITHOUT blanks! Learn the trick!
https://www.youtube.com/shorts/iSPlI8iVI1c
Subscribe: https://bit.ly/3z2rzRw

05/12/2022

Ever heard of two-way or 2D LOOKUP? Learn the trick!

https://youtube.com/shorts/7muhs6qbOsI/

Subscribe: https://bit.ly/3z2rzRw

24/11/2022

Easiest way to make Drop Downs Lists without Duplicates!
https://youtube.com/shorts/z-Ok5hS9ff4
Subscribe: https://bit.ly/3z2rzRw

10/11/2022

Excel DSUM: The SUM Function you never heard of!
https://youtube.com/shorts/x5yIV8QWyGM
Subscribe: https://bit.ly/3z2rzRw

25/10/2022

Yes to another amazing LOOKUP trick!
How to get the LAST value from a list in
https://www.youtube.com/shorts/qS_5bA6R6N0
Subscribe: https://bit.ly/3z2rzRw

08/10/2022

Stop doing it manually! Learn the shortcut!
Subscribe: bit.ly/3z2rzRw

03/10/2022

Learn the Fastest method to compare lists in !
https://youtube.com/shorts/d19ut7eWw_I
Subscribe: https://bit.ly/3z2rzRw

There are number of ways to compare two lists or multiple lists in Excel, We can also compare two columns or multiple columns in Excel. Similarly to compare ...