Hello,
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.
Configuration: Windows Vista Internet Explorer 8.0
Ecel cell to display text not #value! Excel compare two cell values Excel conditional formating cells change colors as time Excel find and replace values in cells greater than Excel find blank cells Excel find multiple cells Excel find number of time an entry is in an array Excel find rows that have the exact same values Excel find value column put link Excel find vba fltered Excel formula find next cell in a column that has a value Excel formula if cell color Excel macros compare cell in two worksheets Find last cell in column value at bottom in excel Finding a word within a cell in excel Formula for displaying a file path in excel spreadsheet cell How to lock a cell in excel sheet if cell contains formula Vba excel down each cell to bottom