Carol has attended:
Excel Intermediate course
Excel Advanced course
Project Intro Intermediate course
Project Advanced course
Databases
How do you tell excel a data selection is a 'database' to then be able to use dsum etc
RE: databases
Hello Carol,
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