Emulating or replacing the EXACT function to return TRUE to a close match
Is it possible to emulate the EXACT function to return TRUE to a close match? I have a spreadsheet with two ranges and I need to find matches between two cells, one in Column G and one in Column K. I can't use "=EXACT(G267,K267)" because they contain different ways of displaying the same time.
G267 displays "20:14" and the formula says "8:14:00 PM"
K267 displays "08:14 PM" and the formula says "08:14 PM"
Is there any way to get Excel to return TRUE in this situation? I know I can use VBA to apply the same format for both cells or I can create helper cells to do the same thing but it would be nice to be able to do it without resorting to either of those workarounds.