|
|
Document Numbering by
adnav
How can I make template in Excel which will allocate a new document reference
everytime I create a new document from the template?
|
December 13th, 2006 05:18 PM
by RagDyeR
|
1 |
48 |
|
|
Compare columns, count matches by
adodson
I'm looking to compare two lists (a1:a10 compared to b1:b10, unnamed). Then,
return the count of original matches between the two lists. For example, if...
( 1 2 3)
|
|
20 |
231 |
|
|
sum column based on single cell match? by
adodson
This seems so simple and yet the solution eludes me...
In row 2 I want Excel to match a cell's contents (ex: find 3200). Once
finding the column that...
|
|
1 |
90 |
|
|
Sumif on Formula instead of Value by
adodson
What I'm looking for is a way to sum the cells that contain =Ceiling.
I've tried SUMIF(range,"*CEILING*",range) but the formula returns 0. I'm
guessing it...
|
May 30th, 2006 05:28 PM
by SteveG
|
4 |
100 |
|
|
MRound and Roundup by
adodson
I can't seem to get these functions to work in conjunction with each other to
get my desired results, so I'm putting it out there for someone else's...
|
April 11th, 2006 12:13 AM
by adodson
|
4 |
59 |
|
|
|
March 29th, 2005 10:55 PM
by Worm
|
3 |
142 |
|
|
|
December 2nd, 2008 11:08 PM
by adre77
|
4 |
61 |
|
|
Using ISTEXT across separate Spreadsheets by
Adrena1in
Hi there,
I've got a customer with a single spreadsheet, which uses the ISTEXT
function to query lots of other spreadsheets. This appears to be
failing, and...
|
|
1 |
82 |
|
|
Data in list w/same A:B move to column by
Adresmith
Hi,
I have a list of source data that I need to change to format of and I
am not sure how to do it. Maybe a pivot table? What I want to do is
have each Pers....
|
|
1 |
82 |
|
|
|
December 19th, 2005 01:56 AM
by Adrew
|
4 |
141 |
|
|
Fill cell with a worksheet name? by
Adri S.
I have a workbook that will be used for employee evaluations. Each sheet is
for a different employee, and the sheet is named for the employee. I would
like...
|
January 16th, 2008 06:12 PM
by CLR
|
4 |
63 |
|
|
|
|
1 |
256 |
|
|
|
June 10th, 2006 06:47 PM
by Country
|
8 |
73 |
|
|
Grouping by
Adrian
I have a spreadsheet which we used to be able to group the rows of data which
is not current. In the past, we were able to group these unwanted data and
on...
|
|
2 |
119 |
|
|
|
|
3 |
129 |
|
|
Formating cells by
Adrian
Is there a way to utomatically remove boarder if there is no value in the
cell and place a boarder i there is?
|
May 1st, 2008 01:34 AM
by Adrian
|
6 |
72 |
|
|
Index/Match Formula across 2 worksheets by
Adrian
New to all this so any help would be really appreciated. (Using Office 2003)
I have 2 worksheets and need a formula (possibly index/match) to add up
total...
|
June 19th, 2008 11:34 PM
by Adrian
|
4 |
103 |
|
|
|
|
3 |
63 |
|
|
|
October 16th, 2005 09:37 PM
by Adrian
|
0 |
129 |
|
|
|
March 17th, 2005 04:46 PM
by JulieD
|
1 |
120 |