How to compare Microsoft Excel columns with the EXACT function EXACT is a text-based function in Microsoft Excel. It's a stickler for details compared to the IF function.