MrExcel Publishing
Your One Stop for Excel Tips & Solutions

excel databases

Posted by xye on July 07, 2001 4:21 PM


i'm trying to use excel list as database and have problem how can i find and delete rows from list
how to search for row address
for example i havae list

a b c
1 x some text
2 y some other text
3 z more text

and i want to fin out the row number of row containing values
a=2 and b="y"

how can i do that

thanks in advance

Posted by Richard S on July 08, 2001 8:41 PM

With you cursor in the database, use Data|Form, click on the criteria button, and enter the criteria you want to find. The message at the top right of the form tells you which record you are looking at. HTH