Using =IF() Function For Partial Match in Excel

In one of our previous blogs, we learned how to use the =VLOOKUP() function for Partial Match in Excel. To explore it, follow our previous blog on “Using =VLOOKUP() Function for Partial Match in Excel“. In this blog, we would explore and unlock the technique to use the =IF() function for a partial match in Excel. Many a time, you have an excel worksheet where you want to use the =IF() function in such a way that it should return the values even for a partial match of string in Excel.

Read moreUsing =IF() Function For Partial Match in Excel

Sort Rows in Excel – Sort from Left to Right

Generally, tables in Excel have headings on the top (i.e. column headings). In that case, it is very easy to sort the data from top to bottom. But, many a time, you may a table where the headings are on the left of the table. That means instead of the column heading, you have row headings. You cannot sort by the rows in excel directly. Then, how can you achieve this? In this tutorial, we would learn to sort the table by rows in Excel. To sort the table from left to right, we need to first make some changes in the settings so that excel can sort the table from left to right.

Read moreSort Rows in Excel – Sort from Left to Right