|
|
Merging different sheets by
vassilis
hello everybody,
I have to work with 2 sheets. In the 1st one my data are arranged as follows:
Payment...
|
|
5 |
204 |
|
|
|
|
2 |
185 |
|
|
vlookup, concatenated named range by
patti
My function:
=VLOOKUP(G7,"Asset"&F7,1,FALSE)
"Asset"&F7 is a concatenation for a named range. If i type in manually, it
works. Concatenated, it does...
|
|
4 |
191 |
|
|
Control On Cell Input by
Laura11
Hi, how do I put a control on a cell so that only a "-" i.e. -8 can be
entered or conversely a control so that only a positive number can be entered.
Thanks...
|
March 14th, 2010 03:18 AM
by Laura11
|
0 |
149 |
|
|
hypothesis testing by
Jaybird
The question is: using a 0.10 level of significance, is there evidence that
the population mean is above $300
values given: sample of 25 students, X(bar) =...
|
|
1 |
178 |
|
|
Info between worksheets by
Eileen
All i want to do is fill a cell with a number and that number to go into a
cell on another sheet as well.
|
|
1 |
176 |
|
|
Sumif Question by
stevestr
I need help with a sumif formula. I have two spreadsheets. On my report
spreadsheet I want to use a sumif function that looks at two columns in the
other...
|
|
1 |
148 |
|
|
|
March 13th, 2010 07:28 PM
by SRU
|
0 |
148 |
|
|
Highlight cells by
Goyo
I am trying to highlight a cell if it is empty. However, the cell in
question is pulling data from another page in the worksheet, so the cell is
not empty...
|
|
1 |
135 |
|
|
Percentages by
Don
I have a spreadsheet that I use to track manpower usage. I have been asked to
reduce hours or days worked by 3% on average per month and not to exceed or...
|
|
2 |
127 |
|
|
|
|
1 |
127 |
|
|
Multiple IF function by
Anthony
Hi,
I'm trying to create a Life Insurance Calculator within Excel. I've already
done a VLOOKUP to get the Relevant Premium Rate, but now I need to be able to...
|
|
5 |
155 |
|
|
|
|
2 |
120 |
|
|
|
March 13th, 2010 01:11 AM
by Dave
|
1 |
131 |
|
|
|
March 13th, 2010 01:07 AM
by Dave
|
2 |
174 |
|
|
Reconstructing a table by
Ted Metro
I can pull a table out of a repository that looks like this --
Bill Mike Sarah Jill Tom
Project 1 0 10 0 0 0
Project 2 40 0 0 12 0
Project...
|
|
4 |
131 |
|
|
On Time Calculation by
Teri
I have two columns, one is Sched Dely Date/Time (O5) and the other is Actual
Dely Date/Time (N5).
If my Sched Dely Date / Time is 04-Mar-10 05:00 PM and...
|
|
1 |
121 |
|
|
numbering pages in footer by
StarZ_Keeper
In the old excel, 1997, we could start a new page with a different page
number rather than 1. I have many pages in one worksheet and many worksheets.
I want...
|
|
1 |
124 |
|
|
Hiding worksheets by
Curtis[_6_]
Is there any way to keep users from un-hiding worksheets in a workbook?
However they do require access to other sheets (not hiiden) within the
workbook...
|
March 12th, 2010 08:38 PM
by Mike H
|
7 |
173 |
|
|
|
March 12th, 2010 07:46 PM
by Mike H
|
1 |
149 |