|
|
|
|
5 |
109 |
|
|
another sumifs plea by
Dave W
I'm struggling to convert a sumifs line from 2007 to excel 2003.
The line I have working correctly in 2007 is:
=SUMIFS('Washing MC...
|
|
6 |
166 |
|
|
Count Data in Series by
Demosthenes
Hi,
I'm trying to write a formula that will go down a column and count the
number of one value cells that occur between those of another value. For
example,...
|
|
2 |
133 |
|
|
|
|
1 |
119 |
|
|
|
|
6 |
103 |
|
|
|
March 31st, 2010 03:58 PM
by Tony
|
2 |
152 |
|
|
Checkbox - Output results to a csv file by
Ephraim
Hi,
I have a small spreadsheet with 20 check boxes in Column A (A1-A20).
They are all linked to corresponding cells in Column B which give TRUE
or FALSE...
|
March 31st, 2010 03:51 PM
by Ephraim
|
4 |
99 |
|
|
VBA Macro help by
Sundarvelan
Hi Friends,
I have taken a project using Excel.
Now wt i need is that if i click a command button in excel the macro
coding must open a excel file from one...
|
|
1 |
80 |
|
|
Populating Row with dates by
Ant
Hello,
I am attempting to automatically fill a row with dates.
In Cell A5, I enter the first day of the month eg 1 April 2010.
I then want the adjacent...
|
|
1 |
98 |
|
|
Adding certain cells in one column by
JT
In my spreadsheet cells in the range E1 through E80 contain total dollar
calculations from each of the columns to their left. Corresponding cells in
column...
|
|
4 |
113 |
|
|
Folder listing by
Esradekan
I want to get a folder listing (from a specific folder) that shows sub
folders in the next column (under the parent folder). How do I do
that does anyone...
|
|
5 |
134 |
|
|
|
|
1 |
127 |
|
|
|
|
4 |
178 |
|
|
|
|
0 |
93 |
|
|
Protected Sheets by
Ann
I am protecting certain cells (Locking) in a workbook that is shared with
many people. I have allowed for them to be able to select locked cells,
sort, use...
|
March 30th, 2010 11:09 PM
by Ann
|
2 |
80 |
|
|
|
|
3 |
78 |
|
|
|
March 30th, 2010 10:54 PM
by WT
|
4 |
113 |
|
|
GETPIVOTDATE Funtion by
[email protected]
I have a formula in spreadsheet to pull data from a pivot table. Part of the
formula is a Date function. I would like to copy this formula down the...
|
|
4 |
103 |
|
|
|
March 30th, 2010 10:33 PM
by Marcelo
|
2 |
104 |
|
|
Sumif with a or condition. by
Mike
I have the equation below which tallies the number of records that meet the
criteria Server Hardware, Internal Issue and Limited Functionality. This
works...
|
|
6 |
80 |