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
calculator Errors by Kat and the Calculator
When I enter an equation in c1 such as: =product(a1,b1), when a1 is 1000 and b1 is .10, the answer in c1 should be 100, but it comes out to 102.04. ...
October 9th, 2005 04:13 AM
by Kat and the Calculator Go to last post
3 91
October 9th, 2005 03:58 AM
by Alex Go to last post
5 153
create a conditional formula by Matt H.
Trying to create a formula that when depending on what word is selected from a list I created, then another list will appear in that cell
October 9th, 2005 03:57 AM
by Max Go to last post
1 181
IFSum(Vlookup... by J Shrimps, Jr.
Need to divide a value in a column by a set of running sum values in an adjacent column. Data looks like this: Product Month Bal RemBal ...
October 9th, 2005 02:52 AM
by Biff Go to last post
7 185
October 9th, 2005 02:16 AM
by David McRitchie Go to last post
1 234
October 9th, 2005 02:14 AM
by David McRitchie Go to last post
2 167
How do I convert word data (not in tables) into excel format? by resret29
I have MS Word/Excel 2003 and a 250 page document extracted from a proprietary software system with numerous fields. Unforunately, when I open it in Word or...
October 9th, 2005 01:25 AM
by David McRitchie Go to last post
2 134
How to use FV function to find a payment to reach a specific goal by Duke20
I have a goal to save $50,000.00 in eight years. My annual interest rate is 6.35%. What amount would I need to put away monthly, to obtain this goal? How would...
October 9th, 2005 12:43 AM
by Fred Smith Go to last post
2 131
vlookup returns column to the left by Brisbane Rob
I thought this would be easy but still can't get it. How do you get a vlookup to return a value from a column to the left of the array? Thanks -- Brisbane...
October 9th, 2005 12:33 AM
by Brisbane Rob Go to last post
3 131
how do I use Goal Seek in a Pivot Table? by TJ
I am trying to use Goal Seek in a Pivot Table but Excel won't let me, any suggestions on how to get it to? Thanks, TJ
October 8th, 2005 11:07 PM
by Conrad Carlberg Go to last post
1 114
cell text completion by nospam
Hi, I am making an index of worksheets tat I use for my pupils. When I type in some cells excel offers me some text that is in previous cells in the...
October 8th, 2005 10:38 PM
by Gord Dibben Go to last post
1 104
visual basic by jiwolf
I have a file where one of the worksheets is set to invisible. ( 0 - xlSheetHidden). how ca I switch it to visible? every time I try to change it a warning box...
October 8th, 2005 09:12 PM
by jiwolf Go to last post
2 119
How do I sum a range if the date is is greater than today's date? by S2
Greetings - trying to evaluate a range of cells that contain dates, and if the date is equal to or greater than today's date, sum a second range of cells:...
October 8th, 2005 08:11 PM
by S2 Go to last post
4 157
How to Copy a Password Protected Excel Worksheet by [email protected]
I need to copy the worksheet but I need to copy not only the values but also the formulas . Also I do not know the password . I hope there is a way to do this...
October 8th, 2005 08:02 PM
by Otto Moehrbach Go to last post
1 157
How do I import a list of names into a separate form that prints . by Paul Smith
I have a list of names on one worksheet. I have a second worksheet that is basically a form. I would like to print out each page with the names from worksheet...
October 8th, 2005 07:22 PM
by Bernie Deitrick Go to last post
1 159
sum with 2 criteria by Dave
With the below eqn do the dates have to be a cell reference or is it possible to use a specific date? One...
October 8th, 2005 07:16 PM
by Ken Wright Go to last post
2 130
Highest Score for each Test by abqhusker
Is there a formula/function to to this? Each student get 3 attempts at a test and I take the highest score. I want a formula that will display the highest...
October 8th, 2005 06:25 PM
by Dave Peterson Go to last post
4 120
Excel needs to let the user set the sort default to "NO HEADER ROW by subtleone
When I grab a selection to Sort within an Excell worksheet and click my Sort button arrow I never know if Excel will arbitrarily decide that I have a header...
October 8th, 2005 05:55 PM
by subtleone Go to last post
0 233
How can I display a number as a ratio of x:1 in Excel? by Neil
I want to display the result of a calculation as a ratio, i.e 16:1 Any ideas on how I can write a function that will allow this to display?
October 8th, 2005 04:50 PM
by Neil Go to last post
2 106
How to copy the hyperlink of a list of cells in another column by jaya
How to copy the hyperlink of a list of cells in another column
October 8th, 2005 03:34 PM
by Dave Peterson Go to last post
1 134
Post New Thread


Display Options
Showing threads 67781 to 67800 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 01:47 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.