Highlight a Sample In a Range or Text that contain certain Values
Learning how to use conditional formatting in excel can save you a lot of time when you need to...
DAVERAGE vs AVERAGEIF & DCOUNT vs COUNTIF
We have been exploring on database functions for the last two articles ( EXCEL DATABASE...
EXCEL DSUM FUNCTION
If you are new to Database Functions, read this Introduction to Database Functions first before...
EXCEL DATABASE FUNCTION
Since their introduction in Excel 2007, DataBase functions have remained Overlooked &...
HLOOKUP, INDEX & MATCH OR VBA
Having done a series on Verticle lookup, it is only fair to touch on the Horizontal lookup....
REVERSE LOOKUP USING VBA
This is the last article in the series of reverse lookup in excel. Unless you are already versed...
REVERSE LOOKUP WITH DUPLICATES IN EXCEL
It is good to be able to do a Reverse Lookup but it is Awesome if you know how to return Multiple...
REVERSE LOOKUP IN EXCEL
In my research and tutoring excel, I have found that many people find the Reverse lookup concept...
2 WAY LOOKUP IN EXCEL
The ability to lookup values is a MUSTÂ have skills for all Excel users. If you cannot lookup you...
LOOKUP and SUM IN EXCEL
Array formulas come in handy when you want to look up and sum a large amount of data. Array...
COUNT UNIQUE DUPLICATE VALUES IN EXCEL
COUNTIF is an excellent function to count only those cells whose value meets certain criteria. But...
WILDCARDS IN EXCEL
A Wildcard is a symbol used to replace or represent one or more characters. Excel wildcards are...