|
|
|
April 23rd, 2009 05:05 PM
by ABA
|
5 |
86 |
|
|
per centages and sums error by
DebC
In excel 2003, I need to calculate per centages of a number, and add the
sums of each together. The results may be off a penny or two each time. Can...
|
|
5 |
97 |
|
|
search data and display colunm headers by
c_diver
I work with Boy Scouts. They have lots of requirements to earn badges. I
have a spreadsheet which lists a summary of requirements in the first column
and...
|
|
5 |
76 |
|
|
Vlookup Different tabs based on Dates by
andy
I am looking for a vlookup that will look up different tabs based on dates.
I have been looking through the INDIRECT questions but I cannot get my
formula...
|
|
5 |
121 |
|
|
Counting rows that meet multiple criteria by
sabow71
I have a strength report that generates counts based on multiple criteria.
The workbook has 2 sheets (Roster contains the personnel names and position...
|
|
5 |
114 |
|
|
|
April 23rd, 2009 04:29 PM
by JennE
|
2 |
84 |
|
|
Nesting IF funtions by
loweightes
I am trying to automate a price list, and get the sheet to return a selling
price on the variable cost price and markup amount. I have the...
|
|
2 |
83 |
|
|
How to sum cells based on conditions by
tjd59
I have a database that consists of the following:
Col A: case number (e.g. 1993-01-115, 2002-11-078, etc.)
Col B: username (e.g. John Henry, Jane Doe,...
|
April 23rd, 2009 03:56 PM
by tjd59
|
2 |
82 |
|
|
|
April 23rd, 2009 03:38 PM
by Jock
|
0 |
75 |
|
|
bug in excel 2007 for sorting function? by
javamama
Hi, I believe there is a bug in excel 2007 for sorting function. I have a
worksheet with the first column being a building code. Some of the codes
consist...
|
|
3 |
83 |
|
|
2007/macros not working by
hughesdm
i have update to 2007 office from 2003. Now the macros that were saved in
2003 are not functioning or can't find them. Can anyone help?
|
|
1 |
75 |
|
|
Sumif based on value in cell by
Jane
I am trying to add values in one column, if the second column matches the
criteria. This is what I have written and I know this is wrong. Can anyone
please...
|
|
4 |
115 |
|
|
Date open file with date saved by
Rita
I am using the =today function in one of my spreadsheets. Is there anyway to
make it show the date that it was saved when you reopen it? For instance, it...
|
April 23rd, 2009 03:13 PM
by Rita
|
3 |
86 |
|
|
|
|
1 |
78 |
|
|
Check Box by
Lois
Hi
How do i make a tick appear in a check box when it is clicked? what macro
code do i use?
--
Lois
|
|
1 |
72 |
|
|
|
April 23rd, 2009 01:36 PM
by Eduardo
|
1 |
102 |
|
|
|
|
0 |
93 |
|
|
Conditional Formatting by
ROPL
I have a spreadsheet which I need to have conditional formatting. It is excel
2003 but is only allows me to have a 3 conditions / colour.
1st conditions I...
|
|
2 |
69 |
|
|
Automatically insert a line by
aeddave
Hi,
Is there a function or formula to automatically insert a new line in Excel.
In this instance, I have a spreadsheet with three sections (top to bottom). ...
|
April 23rd, 2009 01:09 PM
by JLatham
|
5 |
96 |
|
|
|
April 23rd, 2009 12:56 PM
by Mukesh
|
2 |
92 |