#### bomberman411

##### Board Regular

- Joined
- Oct 23, 2007

- Messages
- 169

I have a worksheet that I have been using for almost 2 years. Over the years I have added a lot of little formulas here and there and they usually work great. Recently I have noticed that my formulas don't exactly work like I wanted, so it's time to try and fix them. Problem is, I had help creating them (from all the nice people on this website), and I don't really understand exactly what some of them do. That's why I still need help

Here below are the formulas that I have. They are in french, but I will try to post the translated formula as well, so please keep in mind that I'm working in french.

This cell formula is supposed to check out my whole spreadsheet and give me the number of the next empty row:

Code:

`=INDEX($A$10:$A$5000;EQUIV(1;1/(ESTVIDE($B$10:$B$5000));0))`

Code:

`=INDEX($A$10:$A$5000;MATCH(1;1/(ISBLANK($B$10:$B$5000));0))`

Please help if you can.