I'm having a problem with a 700,000 row worksheet. I have a column of addresses. From them, i want to find the cells having say, New York and display them only. Its because, I want to enter value 'New York' in a new column of states, for all such cells or addresses in the state of New York and similarly for all other states.
I can find the cells using ctrl+F find box, but can't do anything to display only found entries.
Please respond soon. I'm just hacked off with this giant worksheet. If I do it in the present way, it would take me 2 months.