|
|
VLOOKUP with HLOOKUP by
XKruodo
Hi,
I thought this was simple and i could google it. but could not find a
solution.
Age 3 ( premium per years) 5 ( premium per year) ...
|
March 19th, 2010 03:41 AM
by XKruodo
|
2 |
310 |
|
|
subtraction returning incorrect calue by
Ashish_Vaidya
We have a spreadsheet that subtracts one number from another. We did not
understand why Excel is rounding the way it did so we decided to add decimal
places...
|
|
5 |
819 |
|
|
loan amortization template by
jjbud44
I can't find a loan amortization table that will accept a term of 40 years;
the max is 30. Can anyone help?
Thanks
--
Sue W.
|
|
2 |
780 |
|
|
Odd Drop Down Box Behavior by
Squeaky
I have a drop down box on a spreadsheet in a workbook with several
spreadsheets. For some reason the contents of the drop down box is beeing
bled through to...
|
|
4 |
996 |
|
|
Countif Function?? by
Kevan
I would like a formula which will allow me to calculate the number of mondays
in a month which are either C- closed, H- holiday. or TT- term from the...
|
|
3 |
773 |
|
|
Restrict data entry in a cell by
Ephraim
Hi,
I would like to ensure that a user can only input one of the following
numbers in a cell:
1, 2, 3, 4, 5, 6, 7 or 10
I'm using Excel 2003.
Thank...
|
|
3 |
803 |
|
|
|
|
20 |
1,636 |
|
|
Conditional Format for Blank Cells by
LSG
I am trying to figure out, if possible, to make certain blank cells in a
row/column to be filled-in (blacked out) if a certain cell contains a
particular...
|
March 18th, 2010 09:59 PM
by LSG
|
5 |
864 |
|
|
|
|
1 |
711 |
|
|
sumif concatenate formula by
Robb27
I have 3 cells in a row. We'll call them cell 1, 2 & 3. I need a formula in
cell 3 that is based on what is in cells 1 and 2. Example:
1 - If there is a...
|
|
4 |
686 |
|
|
|
March 18th, 2010 08:18 PM
by sly411
|
3 |
706 |
|
|
retrieving current data by
dave303159
i want to pull data from another workbook into a workbook. what formula can
i use that will pull only data from the current month that has data in it?
|
|
1 |
635 |
|
|
Average with Condition by
Curtis[_6_]
I have a report sheet where
Cell b10 represent the day of the month
I need a formula that will look to a prior month sheet for the corresponding
day as...
|
March 18th, 2010 06:48 PM
by Paul C
|
4 |
785 |
|
|
Average with Conditions by
Curtis[_6_]
I am using the following formula to calculate the average sales for a
specific point in time and it works
However when I close the sheet and reopen it and...
|
|
3 |
664 |
|
|
formula patterns with a gap of two by
Mr L Hibbert
"Mr L Hibbert" wrote:
hello im trying to compile a small folder consisting of different worksheets,
each worksheet is a different customers sales etc.......
|
|
0 |
658 |
|
|
|
|
1 |
756 |
|
|
|
March 18th, 2010 05:11 PM
by Pete_UK
|
1 |
694 |
|
|
Count with two criteria by
LisaK
I am working in Excel 2003, I am trying to count with two criteria and
multiple sheets.
I am using this formula: =SUMPRODUCT(('Sum 1Q10'!A2:A4="BKD")*('Sum...
|
March 18th, 2010 04:51 PM
by Pete_UK
|
2 |
671 |
|
|
|
March 18th, 2010 04:45 PM
by Kathy
|
0 |
708 |
|
|
Links do not recognize .xlsm extension by
BadBoy
Good morning,
I have a worksheet that has links to a file called JAN.xls
If someone saves the Jan file as a 2007 excel file which places the
extension .xlsm...
|
March 18th, 2010 04:41 PM
by Squeaky
|
1 |
695 |