Hi,
I've been Googling for an answer, and I can't find the answer.
How can we make the spreadsheet find the next blank cell in Column E, in a row that has anything in Column C, on all tabs of a spreadsheet (it would be best if it just gave the first one, and then we could click on 'next' to go to the next one). It would be even better if it would either also return the value in Column D, or if we could tell it we wanted a specific value in that cell (in other words, if we were looking for that specific value).
I need a formula for this. In Excel Online, which does not seem to have a formula tab, if that makes sense.
Thanks,
Aragon
I've been Googling for an answer, and I can't find the answer.
How can we make the spreadsheet find the next blank cell in Column E, in a row that has anything in Column C, on all tabs of a spreadsheet (it would be best if it just gave the first one, and then we could click on 'next' to go to the next one). It would be even better if it would either also return the value in Column D, or if we could tell it we wanted a specific value in that cell (in other words, if we were looking for that specific value).
I need a formula for this. In Excel Online, which does not seem to have a formula tab, if that makes sense.
Thanks,
Aragon
