So I am trying to find numbers that appear in more than two columns, I have a formula that works for two columns and I need to expand on that so that it looks into three columns.
The formula I have gives me either the number if it is found in the other column or a blank if it only appears in the one.
Here is the formula:
=IF(ISERROR(MATCH('[Excess Water Usage Spreadsheet.xls]Excessive_Users_2014'!G3,'[Excess Water Usage Spreadsheet.xls]Excessive_Users_2014'!$H$3:$H$4000,0)),"",'[Excess Water Usage Spreadsheet.xls]Excessive_Users_2014'!G3)
Any help is greatly appreciated.
Thanks,
Scott
The formula I have gives me either the number if it is found in the other column or a blank if it only appears in the one.
Here is the formula:
=IF(ISERROR(MATCH('[Excess Water Usage Spreadsheet.xls]Excessive_Users_2014'!G3,'[Excess Water Usage Spreadsheet.xls]Excessive_Users_2014'!$H$3:$H$4000,0)),"",'[Excess Water Usage Spreadsheet.xls]Excessive_Users_2014'!G3)
Any help is greatly appreciated.
Thanks,
Scott