T Teddy-B Oct 15, 2009 #1 I just want to go to a certain row that contains data meeting certain criteria. (Example: =h3). How do I do this?
I just want to go to a certain row that contains data meeting certain criteria. (Example: =h3). How do I do this?
T trip_to_tokyo Oct 15, 2009 #2 1. In EXCEL 2007 I have entered:- =h3 - into cell C23. 2. Click out of cell C23 say into cell L19 (this can be any cell). 3. Ctrl F (simultaneously). 4. Find and Replace should launch. 5. Enter:- =h3 - into the Find what: field. 6. Hit Find Next. 7. EXCEL will take you to cell C23. - and so on. Please hit Yes is my comments have helped. Thanks!
1. In EXCEL 2007 I have entered:- =h3 - into cell C23. 2. Click out of cell C23 say into cell L19 (this can be any cell). 3. Ctrl F (simultaneously). 4. Find and Replace should launch. 5. Enter:- =h3 - into the Find what: field. 6. Hit Find Next. 7. EXCEL will take you to cell C23. - and so on. Please hit Yes is my comments have helped. Thanks!