Hi,
I have a simple question on Excel 2007.
I have a very very large spreadsheet e.g. 10000 rows x 10000 columns. Almost all the cells store the same value e.g. "APPLE" but a few cells contain other "unknown" values. Now, i just want to locate the cell that is not equal to "APPLE". i.e. The cursor goes to one of the cells that doesn't contain "APPLE". Conditional formatting doesn't help as spread sheet is huge. Maybe all the cells contain "Apple" or just 1 cell does not contain "Apple"
We can simply use FIND to locate "APPLE" but is there any other way to locate the cell which doesn't store "APPLE" ?
Thx.
MANAHMAN
I have a simple question on Excel 2007.
I have a very very large spreadsheet e.g. 10000 rows x 10000 columns. Almost all the cells store the same value e.g. "APPLE" but a few cells contain other "unknown" values. Now, i just want to locate the cell that is not equal to "APPLE". i.e. The cursor goes to one of the cells that doesn't contain "APPLE". Conditional formatting doesn't help as spread sheet is huge. Maybe all the cells contain "Apple" or just 1 cell does not contain "Apple"
We can simply use FIND to locate "APPLE" but is there any other way to locate the cell which doesn't store "APPLE" ?
Thx.
MANAHMAN