×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

I recommend intensive use of built in D-functions
3

I recommend intensive use of built in D-functions

I recommend intensive use of built in D-functions

(OP)
In excel there is a group of database functions which I think those of us who write spreadsheets aimed at playing with lists can take advantage of.

These functions usually end with a start with a "D", to mention a few

             DSUM
             DCOUNT etc.

Being database functions you usually can constrain it to some criteria, eg DSUM the list given that some number in the list does not exceed 5 for example

To get a feel for this, I suggest you click on fx in Excel and use the DSUM function following the user friendly instructions.

Respects

IJR

RE: I recommend intensive use of built in D-functions

IJR,

I have used these functions as well to good effect. The problem I have is that they don't allow you to obtain results from a table on another worksheet in the same workbook. I need this because I like to keep a neat calculation sheet at the front and then keep my steel sections table say on another sheet. My only work around is to transfer the sections table onto the front sheet but it's not ideal.

Carl Bauer

RE: I recommend intensive use of built in D-functions

2
Carl,

Try using the DGET function in excel97. It will allow you to retrive data from a table on another wooksheet.

Text below is pasted from excel help.

Extracts a single value from a column in a list or database that matches conditions you specify.
For more information and examples, click  .

Syntax

DGET(database,field,criteria)

Database   is the range of cells that make up the list or database. A database is a list of related data in which rows of related information are records and columns of data are fields. The first row of the list contains labels for each column.
Field   indicates which column is used in the function. Field can be given as text with the column label enclosed between double quotation marks, such as "Age" or "Yield," or as a number that represents the position of the column within the list: 1 for the first column, 2 for the second column, and so on.

Criteria   is the range of cells that contains the conditions you specify. You can use any range for the criteria argument, as long as it includes at least one column label and at least one cell below the column label for specifying a condition for the column.

Remarks

·    If no record matches the criteria, DGET returns the #VALUE! error value.
·    If more than one record matches the criteria, DGET returns the #NUM! error value.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login



News


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close