Databases

Resolved · Low Priority · Version Standard

Fri 28 Mar 2008, 17:00 Delegate Carol said...

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

Mon 31 Mar 2008, 01:57 Trainer Mara said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Viewing Many Worksheets

If there are more worksheets in your workbook than there is room to show all their tabs at the bottom of the screen - Right click on the navigation arrows. A list of all your worksheets is shown. You just click on the one that you want to access. If you have more than 15 worksheets, select in the list and choose your worksheet from hundreds.

View all Excel hints and tips