|
|
|
|
1 |
91 |
|
|
Conditional formula with multi tasks by
BadBoy
Hello all,
The formula below will add the number in cell A1 from a workbook called
‘Monthly Totals’ to A1 in a book called ‘Yearly Totals’.
Is there...
|
April 23rd, 2009 12:48 PM
by BadBoy
|
1 |
71 |
|
|
formulas do not work by
Baracuda
Look I am new to Excel so I will try to explain my problem on the example.
I have 1 big spreadsheet called "company" (where I keep all expenses like
diesel,...
|
|
2 |
71 |
|
|
Formula behind functions by
VolkerB
Hello,
my question belongs to worksheet-functions beginning with coup, for example
coupncd or couppcd and so on.
Is there any hint, how these functions...
|
April 23rd, 2009 11:14 AM
by VolkerB
|
3 |
96 |
|
|
Concatencation and formatting by
Bengt[_3_]
I am trying to concatenate two cells. One of the cells is formatted using the
"Special" option on Format Cells. The formatting I have been using is the one...
( 1 2)
|
|
17 |
117 |
|
|
Using V or H lookup by
katiapro93
Hi,
I have a chart which is a price list. in one column I have the size of the
product, next to it is a column with the product name, and next to it is a...
|
April 23rd, 2009 10:32 AM
by Pete_UK
|
3 |
83 |
|
|
|
April 23rd, 2009 10:23 AM
by Pete_UK
|
7 |
71 |
|
|
|
|
2 |
100 |
|
|
compare two or more ranges by
tywlam
How do I locate cells in a range where data is missing or mismatched with
other cells in another range?
Thanks.
|
April 23rd, 2009 10:18 AM
by Stefi
|
3 |
115 |
|
|
List Box and IF function by
Jenny Beech
I need to use the results of a list box choice in an IF statement. How can I
do this?
|
|
1 |
94 |
|
|
|
|
1 |
77 |
|
|
linked data by
nidabland
I have the following information on one worksheet that I need to transfer to
a new worksheet in another format.
Refer Acct Amt
80312 43700 -36,500.00
80312...
|
|
0 |
70 |
|
|
|
|
0 |
119 |
|
|
Compare ranges by
tywlam
How can I locate the cells where the data is missing or not matched with
other cells in another specified range?
Thanks in advance.
|
April 23rd, 2009 04:07 AM
by tywlam
|
0 |
59 |
|
|
Cleaning a list in Excel by
Shawnt
I need some help in deleting rows from a list by comparing two lists.
I have two worksheets and both contain the same type of info. Just First
Name, Last...
|
April 23rd, 2009 04:00 AM
by Shawnt
|
1 |
80 |
|
|
|
|
9 |
95 |
|
|
Custom Number Format by
TeddyTash[_2_]
Hi,
Hope you guys can help.
If I have the following info:
A1 = 5
A2 = -4
A3 = 0
|
|
2 |
98 |
|
|
create table of selected rows by
TBA
Hi there. I have a sheet 'patients' with 'A' Row being an ID taking the form
S002, S003 etc. I have another sheet 'selected' with a selected list of IDs
in...
|
April 23rd, 2009 02:20 AM
by TBA
|
1 |
73 |
|
|
Conditional Function by
Lisa H
I am trying to create a formula that will multiply a portion of a cell by a
percent and the other portion by another percent. For example, when the value...
|
April 23rd, 2009 02:14 AM
by JLatham
|
4 |
89 |
|
|
sum table by
Bonita
Need a single formula that will return the sum of all items lbs/hr
(lbs*rate)/hours
Goal is not to have Col D as lbs/hr and total the column
...
|
April 23rd, 2009 01:27 AM
by smartin
|
1 |
72 |