XMATCH Function Archives

XMATCH Function

How to Go to Last Non Empty Cell in Column in Excel

Dec 12, 2022 Excel Basics

Users often need to find the last non-empty cell of a column. In a long dataset, it is quite time-consuming to find the last non-empty cell or the ...

How to Do Reconciliation in Excel (12 Effective Techniques)

Dec 6, 2022 Excel Formulas

Reconciliation is a very common term in accounting, especially in the banking sector. There are many ways in excel to do reconciliation. In this ...

How to Reconcile Two Sets of Data in Excel (9 Simple Ways)

Dec 6, 2022 Excel Formulas

While working in Microsoft Excel you may need to compare two sets of data and reconcile any missing or matching items. As with Excel, there are ...

Different Types of Lookup to Apply in Excel (8 Types)

Feb 9, 2023 Excel Basics

Certainly, one of the frequent uses of Excel is looking up a value in a table or data range. Now, Excel contains a couple of dedicated lookup ...

How to Compare Addresses in Excel (11 Possible Methods)

Feb 9, 2023 Excel Formulas 2

To perform any data analysis task comparing data in excel is common. It is most required for banks to check the background of a customer depending on ...