A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Worksheet Functions Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
March 19th, 2010 01:40 AM
by Fred Smith[_4_] Go to last post
5 149
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.
March 19th, 2010 12:44 AM
by Dana DeLouis[_3_] Go to last post
2 171
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...
March 19th, 2010 12:17 AM
by Gord Dibben Go to last post
4 222
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...
March 18th, 2010 11:35 PM
by T. Valko Go to last post
3 188
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...
March 18th, 2010 11:05 PM
by T. Valko Go to last post
3 251
How to omit blank cells when calculating weighted averages by Suzy
Hello, new to Excel and need help with function. I am calculating grades for my students, and if they were absent, I do not want them penalized. What function...
(Multi-page thread 1 2 3)
March 18th, 2010 11:00 PM
by T. Valko Go to last post
20 431
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 10:59 PM
by LSG Go to last post
5 263
Hlookup with Merged cell as look up value by srs
Hopefully someone can help me out on this one. I have a spreadsheet that looks similar to this: 2/15/2010 3/15/2010 . . . Site#...
March 18th, 2010 10:51 PM
by T. Valko Go to last post
1 206
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...
March 18th, 2010 10:36 PM
by Lars-Åke Aspelin[_4_] Go to last post
4 190
Conditions Not Accurate when subtracting time by sly411
When I subtract two times e.g. b1 is 21:35 a1 is 20:55 the answer shows correctly i.e. 40:00 (using :ss format) but when I set the condition b1-a115 the...
March 18th, 2010 09:18 PM
by sly411 Go to last post
3 201
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?
March 18th, 2010 08:40 PM
by Otto Moehrbach[_2_] Go to last post
1 184
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 07:48 PM
by Paul C Go to last post
4 227
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...
March 18th, 2010 06:31 PM
by T. Valko Go to last post
3 169
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.......
March 18th, 2010 06:29 PM
by Mr L Hibbert Go to last post
0 175
Sumproduct but only first time corresponding value is seen e.g. un by ker_01
Using XL03 Sample Data: Name Race Speed Avg Speed Track Month Joe 2:12 2:15 OFCF Jan Joe 2:28 ...
March 18th, 2010 06:20 PM
by T. Valko Go to last post
1 211
LookUP function with multiple variables and worksheets by mjwk
I am trying to create a formula for the following: If Col A on worksheet 1 = Col B on worksheet 2 AND Col B on worksheet 1= Col C on worksheet 2 then the...
March 18th, 2010 06:11 PM
by Pete_UK Go to last post
1 212
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 05:51 PM
by Pete_UK Go to last post
2 183
Conditional Formatting for a dashboard with a drop down menu by Kathy
I am formating a dashboard where you select which dash board from a drop down menu (P&L, KPI's etc.). When I change the dash board with the drop down menu...
March 18th, 2010 05:45 PM
by Kathy Go to last post
0 215
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 05:41 PM
by Squeaky Go to last post
1 234
=AND($B$12"",$B$12TODAY()+60) What does the mean in this? by Cbeckwith
Formula above has and then the double quotes. In the context of the cell B12, what does the mean and does the Double Quotes mean, the current cell of...
March 18th, 2010 05:34 PM
by Bob Phillips[_3_] Go to last post
3 269
Post New Thread


Display Options
Showing threads 2001 to 2020 of 87787
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright ©2004-2018 OfficeFrustration.
The comments are property of their posters.