Excel:To find cells with an entry and display [Closed]

 Trowa -
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.

1 reply

Use the autofilter option: Data>Filter>AutoFilter.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!