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
Pivot tables & Dynamic Ranges? by Me!
Hi, Does anyone know if pivot tables can be based on dynamic ranges (defined with OFFEST/COUNTA)? as I've tried but can't seem to get it to work. Many...
June 16th, 2009 12:58 AM
by Ashish Mathur[_2_] Go to last post
2 171
Printing non-contiguous rows at the top by Rich Burt
Using the 'rows to repeat at top' field of page setup, is there a way to print non-connected rows (i.e. rows 1, 2, 5, & 6)? The formula only allows for...
June 16th, 2009 12:42 AM
by Jim Cone[_2_] Go to last post
1 134
Goal Seek returning different results by Don Kline[_2_]
I am using Goal Seek to determine an interest rate for an investment stream that returns a zero. The investment is irrgular in amount but the period is...
June 16th, 2009 12:32 AM
by JoeU2004 Go to last post
3 188
Excel 2007 - copying filtered data to another workbook by texansgal
I am having an issue (all of the sudden) when I copy data from one worksheet to another. I have a spreadsheet that is filtered and I choose one of the 15...
June 15th, 2009 11:05 PM
by Bassman62 Go to last post
1 181
Hidden Background Data File by PSM
Can you get Excel to open another Excel file linked to the first automatically (preferably hidden and read only) in the background ?
June 15th, 2009 09:19 PM
by Dave Peterson Go to last post
1 130
If functions by Muskrat24
I want to set up a formual so that if H12 is yes, I want G12 equal to B11, If it is No i want it left blank, is that possible to do?
June 15th, 2009 08:14 PM
by Rick Rothstein[_2_] Go to last post
2 134
Using Functions by Muskrat24
I am trying to make a function so that if the cell is "yes" that it will be equal to another cell and if it is "no" than it is left blank. How do I do this?
June 15th, 2009 07:53 PM
by Rick Rothstein[_2_] Go to last post
4 171
Circular Reference : Puzzle to be solved ... by Naresh
Excel Gurus .. need inputs on this The following is the struture... B is calcualted as 65% on G H @ 40% of B C ( Max Value 800) A ( 5% on B) S(...
June 15th, 2009 07:31 PM
by Bernard Liengme[_2_] Go to last post
1 175
Hyperlink function not going anywhere by rel
I am using Excel 2007, but sharing document with 2003 users. I have a master list of ingredients on SHEET1. I have inserted hyperlinks to MSDS files located...
June 15th, 2009 07:31 PM
by Gary''s Student Go to last post
1 117
VLOOKUP format issues? by Craig4321
I am using the VLOOKUP function in Excel (office 2007) and it is not working for me. I checked the forums and they had the usual things to check: remove...
June 15th, 2009 07:06 PM
by Bassman62 Go to last post
4 166
How do I add a hyperlink (to a Word doc) to an excel spreadsheet? by A. Franklin
I am creating a spreadsheet and need to add links to Word documents. How do I do that?
June 15th, 2009 06:40 PM
by Jacob Skaria Go to last post
2 122
Loan amortization schedule for variable interest rates by Shaun
I am using a Amortization Schedule template from Microsoft Office online. While this template is helpful for cases of fixed rate of interest over the period,...
June 15th, 2009 06:16 PM
by JoeU2004 Go to last post
5 151
Sumproduct by ronnomad
Having 'brain freeze' with sumproduct...my formula is: =SUMPRODUCT(--L2:L306=$L309)--(N2:N306=N$308) column 'L' is a list of departments (and I can list as...
June 15th, 2009 06:04 PM
by ronnomad Go to last post
3 115
Formulas refuse to update by spartina_patens
I am using Excel 2003. I type in a simple formula and all I get is the text (i.e. =sum(D2:D43)) that I typed in, not the value. I have tried using F9 and...
June 15th, 2009 05:54 PM
by Luke M Go to last post
7 104
Keeping row number after inserting lines by MurrayBarn
I have a spreadsheet that has twelve sections (ie one per month of financial year). In each section there is data pasted in from another worksheet and below...
June 15th, 2009 04:17 PM
by MurrayBarn Go to last post
4 119
Rounding in Excel by Al Charbonneau
I have a table that has numbers "hard coded" back to another spreadsheet in the workbook. Excel says that the numbers (961+73-60=974) in the table. ...
June 15th, 2009 04:13 PM
by JoeU2004 Go to last post
2 92
repeated numbers or value by soodddddddddd
I have data in 45 coulmns and 3000 rows. I want to know which numbers are repeated in each row or coulmn.Please help me to solve this problem.
June 15th, 2009 03:46 PM
by sood Go to last post
2 99
Stock Calculation by Shah Alam
Suppose, ProductionDate Production Op Balance DelDate Party Qnty Cl. Balance 1.1.09 500 500 ...
June 15th, 2009 03:14 PM
by Fred Smith[_4_] Go to last post
1 99
Reminder by Vinod
Is there any provision to generate a reminder on my excel sheet for a particular date? eg: Date A value Previous Date ...
June 15th, 2009 03:09 PM
by Shane Devenshire[_3_] Go to last post
2 124
Linking Date with a Worksheet by Vinod
Can you pls tell me how the present date in my computer can be linked with a worksheet? Or Is it possible for me to set a reminder on my work sheet based on...
June 15th, 2009 02:58 PM
by Shane Devenshire[_3_] Go to last post
1 107
Post New Thread


Display Options
Showing threads 10101 to 10120 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 12:20 PM.


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