I have an issue with referencing an excel spreadsheet:
I have data in columns A and C that's (mostly) equal, I want to isolate and create a separate list for the rows that are not equal.
For example, I have :
A B C 1- 5 John Lane Joe Bloggs 5 John Lane 2- 6 John Lane Mary Lamb 35 Woopwoop Court
For the rows where A and C are equal, for this particular exercise, I don't care about. The rows where A and C are not equal, (row 2 above) I would like to compile a list of these, somewhere else.
I began with
This should have returned as column f (otherwise blank) returning either a value of 0 or of the contents of column c for that particular row, it didn't and I'm wondering what I'm doing wrong.
I would like to end up with a truncated list of all rows (columns A, B and C) in a separate worksheet for where A and C are not equal so I can list those properties where the owners live somewhere else.
Any thoughts or suggestions on how to achive this would be appreciated