Sorting with functions only
This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.
This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.
Using VLOOKUP + MATCH (HLOOKUP + MATCH, OFFSET + 2 MATCHes or INDEX + 2 MATCHes) to search a table in both axis. This post has been sitting for a …
A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the level of expertise in each
We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore We can use the new …
I have been asked for a while now to just put a simple VLookup function, here it is, I know this might be stupid to post it here, but we …