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
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 04:41 AM
by XKruodo Go to last post
2 305
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 799
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 760
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 969
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 746
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 792
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 1,587
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 844
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 694
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 665
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 681
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 613
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 767
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 653
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 641
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 736
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 672
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 650
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 689
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 682
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 10:03 AM.


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