Kwame has attended:
Excel Intermediate course
Excel Advanced course
Excel Advanced - Formulas & Functions course
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.