Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
databse functions and tabular

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Databse functions and Tabular functions

Databse functions and Tabular functions

ResolvedVersion 365

Databse functions and Tabular functions

is it possible to have the formula answers for the Tabular function and Databas function used in worksheet 2.1

RE: databse functions and Tabular functions

Hi Kwame,

Thank you for your question in STL's forum. My name is Ron and I am one of the instructors at STL.

Kwame, I believe you either attended a course with Jens or with Marius. They are busy delivering training at the moment, so can't reply.

Kwame, could you tell me which course and exercise you are referring to in relation to your query? I might be able to retrieve the answer for you. It would also be useful if you remember who your instructor was.

Please reply to this post and I will see what I can do.

Kind regards

Ron Oldeboom
Learning and Development Comsultant
STL-training

RE: databse functions and Tabular functions

Hi Kwame,

I hope you are well. Thanks for your question. To create tabular data using database-type functions, I would actually use Sumifs, Countifs or Averageifs.

With Dsum, Dcount and Daverage, the criteria reference in the function makes it hard to copy down and across. Dsum, Dcount and Daverage are better for single cell results.

I hope this makes sense.

Kind regards
Marius Barnard
STL

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Tue 11 Aug 2020: Automatically marked as resolved.

Excel tip:

Add Text to Displayed Numbers in Excel 2010

To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.