|
|
|
|
|
|
 | Working with Database functions, DSUM 
Here is a lesson that you will learn a lot from, it is about how to use DSUM (Which applies to all other D-functions or Database functions)
Which getting the total of a column based on more than
From Microsoft Excel - Functions | Views: 195
Comments: 1
Stars:
Votes: 0
Duration: 8:25
Since: 3/17/2009
|
|
|
|
|
|
|
Multiple-Dual-Validations
Here is the project for the lesson in the same name Open Lesson.
It is to demonstrate how to do multiple validations in the same sheet, or as we want to ...
details
|
|
Views: 580
|
|
Downloads: 63
|
|
UI: En
|
|
Since: 5/14/2009
|
|
|
Convert Two-columns-table to Column-Row-table
This Excel file will convert a table of two columns into a Column-Row table
Using functions only and auto-updated once the Main table update
I needed this one few days ago and yYou will ...
details
|
|
Views: 270
|
|
Downloads: 39
|
|
UI: En
|
|
Since: 4/15/2009
|
|
|
Convert CamelCase to Title Case (Adding spaces)
It is all in formulas. Put additional spaces before any upper case letter. made specially for custom request. using functions LEFT, MID, FIND, SMALL, COUNT, COLUMN, IF, CHAR, ISERROR, ...
details
|
|
Views: 333
|
|
Downloads: 67
|
|
UI: En
|
|
Since: 3/31/2009
|
|
|
Excel Calendar
An Excel calendar that works for all months all years, you can select the month to show its calander for this year. Or, you can select the year to show all months for that year, You can also see what ...
details
|
|
Views: 1265
|
|
Downloads: 368
|
|
UI: En
|
|
Since: 1/1/2008
|
|
|
|
|
Unknown user
|
create a form to pull data from different worksheets
Hello. I am a teacher. I have 12 sections of students. I have grades in the first few columns, than I have behavior and attendance in later columns. (The behavior and attendance are referenced ...
|
|
|
File1 Answers
|
|
14 views
|
|
size=80
|
|
Answered
|
|
|
|
|
|
|
Unknown user
|
Converting text to formulae
A particular cell in my spreadsheet may contain text in the form of xdy, where x and y are whole, positive numbers. The cell, therefore, may read 1d6, 2d4, 3d8, etc... A second cell must be formatted ...
|
|
|
File1 Answers
|
|
85 views
|
|
size=80
|
|
Answered
|
|
|
|
|
|
|
tghtrad ing
|
Excel is adding wired ( round up maybe?
"hi, im tryng to do a simple cost sheet
and excel is doing somtehing strange
for example i have
Item Cost Order quanity and then total cost
so lets say =SUM(Itemcost*orderquanity) = ...
|
|
|
Yahoo! Answers
|
|
73 views
|
|
5/8/08 6:42 PM
|
|
|
|
Answer by 
VBAXLMan
|
|
|
|
HandyMa n
|
Excel AND function?
"I am creating an Excel spreadsheet to calculate binary numbers.
When I calculate the AND function of two cells that contain 0 or 1, I get the result of 'TRUE' or ...
|
|
|
Yahoo! Answers
|
|
92 views
|
|
5/10/08 9:24 PM
|
|
|
|
Answer by 
kaatt
|
|
|
|
|
|
|
What do you think of File1.net so far?
|
|
|
Help keep File1.net free
|
|
|
Featured
|
|
|
|
