Excel advanced - Database functions

Hello Ro,
I hope you enjoyed your Excel training sessions with us.

To answer your question, Excel will see any contiguous data table as a database for function purposes. This means that as long as there are no blank rows in your data, Excel will recognise the status.

I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.

Have a great day.

Regards,
Mara
Microsoft Office Specialist Master Trainer