Excel Forum
Similar Content
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...
Make All Numbers in a List Positive in Excel
Tutorial: Take a list of numbers and make them all positive, regardless of whether the list contains...
Highlight and Sort the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allow...

Mr Excel & excelisfun Trick 29: Existing Customers In Prospect List?

See Mr Excel and excelisfun compare a customer list and prospects list to see if customers are in the prospects list. Then remove the duplicates. See the MATCH, VLOOKUP and COUNTIF functions.

Got a Question? Ask it Here in the Forum.