3 Ways To Work With Duplicate Data in Microsoft Excel

Apr 19, 2019 | Excel, Excel General

Sometimes when we perform data entry task, or copying data from somewhere, we occasionally encounter the issue where some data are duplicate. Unfortunately, In Excel, dealing work duplicate records aren’t that difficult.In this tutorial, I will show you 3 ways...

Perform a Lookup Based On a Value Between Two Values

Apr 15, 2019 | Excel, Excel General

By default, when you perform a look up (VLOOKUP or INDEX/MATCH) in Excel, you can only match a value either by exact match or approximate match. If you want to look up a value in a range or between two dates, you can use something called array formula. In this...