|
|
Vlookup Count confusion ! by
Andy787878
The scenario is that i have 2 worksheets to link together.
In Worksheet 1 i have the following:
3 Columns, marked 1 (in B1), 2 (in C1), 3 (in D1)
5 rows...
( 1 2)
|
|
15 |
195 |
|
|
Help with using range names in sum function by
soteman2005
Hi,
I am creating a model in excel using range names for every row which
works really well. The model is run across several years which are
allocated a column...
|
|
2 |
195 |
|
|
|
|
2 |
195 |
|
|
|
|
0 |
195 |
|
|
|
|
12 |
195 |
|
|
copy/Paste references other worksheet by
Ivano
Hi,
I have a bunch of forumla's in a worksheet and when I copy either the tab or
select the entire worksheet and paste it into a new workbook it...
|
April 1st, 2006 01:06 AM
by Max
|
4 |
195 |
|
|
formula by
Kim
I am trying to create an IF formula that if a column is 16 but 49 then
multiple by .75 or if the number is 8 but 15 ten multiple by .50, if
greater than 50...
( 1 2)
|
April 7th, 2006 12:49 AM
by KL
|
13 |
195 |
|
|
MSN Stock Quotes Excel plugin broken? by
yozzdi
I have been using MSNStockQuotes on a few computers without any problems
for months.
Now (in the last day or so) , when I press "update Quotes" on any of
the...
( 1 2)
|
|
13 |
195 |
|
|
changing a cell to changing the link by
Jared
I have a cell refering to another workbook. example: April.xls
I want to change all cells with that refrence but without changing each one
individually, so i...
|
|
7 |
195 |
|
|
How do I enter formula for or numbers. by
Betty P.
I am trying to enter a formula in a worksheet. I want the formula to do the
following: IF A1=40 then enter 1, if less that 40 enter 0, OR IF A1=45 enter
2,...
|
November 27th, 2005 06:25 PM
by Betty P.
|
7 |
195 |
|
|
creating formula using if function by
juvena
I confused about creating formula using if function for the condition below.
Labor costs for items with material costs of at least $100 but less than
$500 are...
|
|
2 |
195 |
|
|
Weeknum by
MickeW
I work in a Swedish environment, and would like to use the function Weeknum,
the thing is, that Sweden uses a different way to number our weeks, for
example,...
|
August 23rd, 2005 08:50 PM
by hhalle
|
7 |
195 |
|
|
cell equation ? by
Custermd
If the value of a cell is less than zero, what is the easiest way to default it to zero?
example
b6 = -15
I want it to default to zero regaurdless of any...
|
|
5 |
195 |
|
|
|
|
4 |
195 |
|
|
|
|
1 |
195 |
|
|
sum product problem by
spirosu
---Date-------Individual-----Type of Work---Amount
____________________________________
7/26/2005---John Smith---Related Work---2
7/27/2005---John...
|
|
2 |
195 |
|
|
|
|
7 |
195 |
|
|
Problem, again by
Elbowhite
Hi again,
I've came up with another problem.
The thing is like this. In a worksheet I have 7 coulms to use
(a,b,c,d,e,f,g). The first one (a) is the most...
|
|
1 |
195 |
|
|
Auto number invoices in Excel by
Fay
How can Auto numbe an invoice I am working on in Excel. I use to be able to
do it in Office 97. View-Toolbars-invoice and then click on auto number. In
office...
|
|
1 |
195 |
|
|
#VALUE about function Find by
hui
I set A1="1978-9-22", B1="find("-",A1)" and return, but B1 shows #VALUE!,
why? How can I resolve it? thanks in advance.
A B ...
( 1 2)
|
September 12th, 2006 04:01 PM
by hui
|
14 |
195 |