|
|
HELP!! VLOOKUP, INDEX or MATCH?? by
Kurt
I am trying to figure out how to get a piece of information into a cell
needed for a calculation.
This is what I have in one worksheet:
8 ...
|
|
8 |
138 |
|
|
Unable to create/use hyperlinks by
Siilverain
Note: Excel '03 SP2
I created a workbook in which each person who accesses it can use the
hyperlinks to find the information they require. Until recently,...
|
|
4 |
107 |
|
|
Linking worksheets in different workbooks by
changingtheworld
I have several worksheets that I need to link to multiple workbooks. Each
worksheet in each workbook has a different name. When I copy multiple cells
from...
|
|
0 |
78 |
|
|
|
|
1 |
94 |
|
|
|
|
4 |
111 |
|
|
sumif error by
tipoo
Hi Guys,
I have two sheets in an excel 2003 file. Sheet 1 has purchase order# and
relevant amounts. There can be more than 1 line record for same PO# on sheet...
|
April 13th, 2009 11:29 AM
by tipoo
|
4 |
95 |
|
|
|
|
1 |
104 |
|
|
Getting a value within a range by
Steve HKG[_2_]
What function can i use to determine a value from a range?
A B c
0 300 0.6
301 600 0.8
601 900 1.0
901 1200 1.2
So if i have a value of...
|
April 13th, 2009 10:32 AM
by Bernd P
|
5 |
103 |
|
|
|
|
2 |
85 |
|
|
|
April 13th, 2009 07:57 AM
by Kassie
|
1 |
79 |
|
|
test 2 ranges by
Dave
This should be simple but i can't see it.
How do I return TRUE/FALSE if the sum of 2 ranges are equal. The ranges are
different sizes (say) a1:a3 and b1:b6...
|
April 13th, 2009 07:19 AM
by driller
|
5 |
72 |
|
|
Copy of realtime data. by
sidd
Hi,
I have created a table with real time and percentage data get refreshed
every minute. I need to get the data in column D for that particular...
|
April 13th, 2009 07:06 AM
by sidd
|
4 |
70 |
|
|
Carrying last $$$ amount to another field by
Challenged
Hi... I'm working with a Billing Statement in Excel. Going down the colum is
the sum of charges and credits from the two columns from the left. The
billing...
|
April 13th, 2009 07:01 AM
by Kassie
|
4 |
87 |
|
|
conditional formatting in excel 2003 by
GrouchyMammy
I have column A that I want to turn the back ground red if the number of
months is = 12 in column I. If the number of months is = than 11 I don't
want a...
|
|
5 |
89 |
|
|
Headings to appear on next pages? by
Karen
How do I get the headings I choose for page 1 to appear on subsequent pages?
I'm sure its a protection thing, but need help!
|
April 13th, 2009 02:32 AM
by JLatham
|
2 |
85 |
|
|
Quick lookup for data by
Max
I have a worksheet that has row headers with Employee numbers, salary, names
etc. I want to create a quick lookup that allows me to type in the employee...
|
April 12th, 2009 08:50 PM
by Kassie
|
1 |
62 |
|
|
|
April 12th, 2009 07:52 PM
by Ivan
|
8 |
107 |
|
|
|
April 12th, 2009 07:21 PM
by Kassie
|
1 |
102 |
|
|
If Date Function by
Rose
I would like to add the dates that someone is employed which is easy if you
have a Job Start Date and Job End Date. I just go something like C1-B1 and...
|
|
5 |
76 |
|
|
Page Layout by
Chris
How do i make my work book get the most amout of rows and colums to print on
each page
--
Chris K
|
|
1 |
60 |