I am using DCOUNTA to count quot;recordsquot; (rows) in an Excel spreadsheet using
three criteria:
- Dec 25 Tue 2007 20:41
count records meeting three criteria
- Dec 25 Tue 2007 20:41
if, sumproduct, help by date
Hello,
- Dec 25 Tue 2007 20:41
Using Lists/Validation
I've seen someone use a list, but when you selected something from the list,
another value went in the cell.
- Dec 25 Tue 2007 20:41
formulae to copy cells from 1 worksheet and paste into another?
I have rows of data and coluims and would like to copy from 1 format to
another on a diffrent sheet via a formula to minimise the amount of copying
- Dec 25 Tue 2007 20:41
Max number of columns?
Is the max no of columns in a spreadsheet really only 256, or is there some
devious way of tricking Excel to allow more?
- Dec 25 Tue 2007 20:41
Change date format
Hi,
I need some help changing the date format in xls.
- Dec 25 Tue 2007 20:41
Need help writing formulas in excel using ratios
Help !!!
I wish to auto calculate $ values using ratios. Basically, i would like to
- Dec 25 Tue 2007 20:41
Copying a conditional format to several cells
Ok, I have a spreadsheet that is 11,000 rows long. I create the conditional
format on cell J2 to shade grey if cell J2 is less than cell AU2. Format
- Dec 25 Tue 2007 20:41
converting seconds in hh:mm:ss
Hi,
- Dec 25 Tue 2007 20:41
Can you chart an equation (y=mx b)?
I am trying to set up a graph in MS Excel where you can enter in the values
for X and B and it will graph the line, like a graphing caluclator would. Is