|
|
|
|
5 |
75 |
|
|
|
|
3 |
95 |
|
|
Excel data sort by
Stacyb
I need to sort data alphabetically on a speadsheet and also add new data from
another excel spreadsheet. The problem is the column to sort is 4 lines
(column...
|
|
1 |
116 |
|
|
Conditional statements by
james[_4_]
I have three cells a1, b1 and c1 that should indicate green, yellow and red
respectively when values and range of values are given in say cell e1. The
values...
|
|
9 |
169 |
|
|
Highlight automatically a specific cell by
Frances Holden
i am working on a spreadsheet and need some help, it's hard to explain what i
want but i'll try my best, here goes! I have a sheet and on it i have several...
|
|
1 |
58 |
|
|
Formula by
james[_4_]
I am quiet new with excel. Please can anyone help me with writing a formular
for a cell that contains a range of numbers. I the cell to for example
indicate...
|
January 7th, 2008 03:44 PM
by Gav123
|
7 |
82 |
|
|
|
|
5 |
75 |
|
|
If Statements & Combining Cells by
Hark2k
I am trying to write a statement where if the values in column A equal a
certain value then it will combine the corresponding data in column B,
preferably...
|
|
2 |
58 |
|
|
Excel Formula Error by
Griffey5
What is wrong with this formula?
=SUM(IF(('Batch Log'!A2:A2001="February")*('Batch
Log'!G2:G2001="530204-03")*('Batch Log'!H2:H2001="3000272.02"),'Batch...
( 1 2)
|
|
15 |
160 |
|
|
worksheet to worksheet subtotals by
bernieb
I can't seem to figure out how to carry subtotals from a specific cell in
each worksheet over to a grandtotal cell on the last worksheet. ie. cell O33
on...
|
|
4 |
78 |
|
|
adding subtotals from several worksheets by
bernieb
I am trying to figure out how to create a "Grand Total" on my final worksheet
containing the sum of subtotals from several previous worksheets. Such as,
cell...
|
|
2 |
77 |
|
|
|
January 7th, 2008 08:50 AM
by sophie
|
4 |
103 |
|
|
Array extended formula - sort by
yshridhar
Hello everybody
The following is the debtors list
Invoice Debtor Amt Date Age
T001 DEF 140 11/09/2007 118
T002 BQE 0 25/12/2007 0
T003 ABC ...
|
|
3 |
84 |
|
|
Setting up Email Reminders by
millpa00
Hi. I have no idea if this can be done...but I created a schedule for our
team. Each person has a user id. They use drop-down lists to add their name
to a...
|
January 7th, 2008 05:06 AM
by FSt1
|
1 |
51 |
|
|
Help on data style issues.... by
golfdunwoody
Help please; when I change a data style in one cell, it changes the data type
in all cells. As an example if I change one cell to a date, all the cells...
|
|
2 |
63 |
|
|
If Formula question Excel 2003 by
Tom
What is the proper syntax in Excel 2003 for the following:
If cells A6:A20="Tom" and cells B6:B20="a" then count the number of "a" in
cells B6:B20.
Thanks!
|
January 7th, 2008 01:38 AM
by BIG D
|
4 |
82 |
|
|
Annuities by
Chip
I need help to make a function in Excel to do an annuity table for 218 month
showing each month the monthly payment divided in 2 figures: the down payment...
|
|
3 |
55 |
|
|
Nest SumIf by
[email protected]
Hello. I am trying to use a formula that will sum a colum if the
criteria in one column equals a cell and the criteria in another
column equals another...
|
|
3 |
70 |
|
|
|
January 7th, 2008 01:01 AM
by dim
|
3 |
83 |
|
|
|
|
5 |
67 |