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
Multiple criteria by Solar Man
Hi, I'm trying to find the formula for entering a value in a cell based on multiple criteria. I'm working on a solar heating sheet. I have a drop down menu...
August 25th, 2008 05:37 PM
by T. Valko Go to last post
7 106
Webquery by Neale
I am attempting to get data from an internal webpage. When I do I get the following message: "The page you have requested requires JavaScript to function...
August 25th, 2008 05:26 PM
by Neale Go to last post
3 72
Format Cell contents as MM by Sandy
Hello I have a monthly file My File mm-yyyy.xls. I am trying to reference last months file using cell C1 (Named month) and indirect.ext using...
August 25th, 2008 05:16 PM
by John Bundy Go to last post
4 90
Sum by Sum problem
I would like to sum a common cell, by defined name, accross a set of different sheet. The cell name is the same, with a scope to the sheet only. ...
(Multi-page thread 1 2)
August 25th, 2008 04:39 PM
by Spiky Go to last post
10 191
MAtch drop down list selection to data sheet by SMOKN_ENG_MOM[_2_]
I am trying to match a selected item from a drop down list (sheet 1) to a column on another sheet(2) and return information from another column on sheet 2 to...
August 25th, 2008 04:16 PM
by Gav123 Go to last post
1 125
//autoaverage. by sansk_23
Hi !! If i have a table like below : WEEKS EAST NORTH SOUTH...
August 25th, 2008 04:06 PM
by bpeltzer Go to last post
2 121
What is the formula for compounding interest with annual additions by charrismd
Would appreciate help with learning the formula for how to compound interest with annual additions. I would like to know the future value of an interest...
August 25th, 2008 04:00 PM
by Duke Carey Go to last post
1 316
how can I disable "cutting cells" and "drag and drop "in excel ? by mwoody
I need to disable the "cut" and the "drag and drop" functions on all worksheets in the entire workbook. However, I want the copy and paste function to remain...
August 25th, 2008 03:53 PM
by Spiky Go to last post
4 206
payback period for a 10 years investment by tlgoh
I need help to set up a table to calculate a payback period of an investment of $1.0 Million. what are the parameters and assumptions I need to consider
August 25th, 2008 03:34 PM
by Duke Carey Go to last post
1 100
//pivot - unique records . by sansk_23
Hi !! I have a table like this : Location Order Invoice Week A 1 X1 20 A 1 Y1 20 B 2 X2 ...
August 25th, 2008 03:28 PM
by Herbert Seidenberg Go to last post
3 115
excel 2007 pivot table wizard by CIL
Good Afternoon. Thanks in advance for your help. I am being forced to go to 2007 since the work environment has updated their software packages and I am...
August 25th, 2008 03:27 PM
by CIL Go to last post
2 213
Start, Finish including break time by Ricardo
Hi all, I currently have a excel spreadsheet set up to take the following. Just an example: Cell A1 - Time Started (In 24 hour time) - "06:30" Cell A2 - Break...
August 25th, 2008 01:26 PM
by Teethless mama Go to last post
2 117
When inserting column I get "cannot shift object off sheet" by Oz
When inserting a column in excel I get a message that says "Cannot shift objects off sheet".
August 25th, 2008 01:24 PM
by Dave Peterson Go to last post
1 135
Help with changing a formula by JBoyer
The current formula I have is... =IF(COUNTBLANK(INDEX(F:L,ROW(),))COUNTBLANK(INDEX(F:L,ROW()+1,)),"PENDING CREDITS","") I want to make one addition to this...
August 25th, 2008 12:16 PM
by JBoyer Go to last post
4 138
auto step sum by confused deejay
hiya i am writing a spred sheet where if i select a drop down list then enter a sum the sum would be inserted into then appropriate cell. my problem is i...
August 25th, 2008 12:02 PM
by confused deejay Go to last post
3 101
formula help by RayB
I'm a novice Excel user. This is probably basic, but.. whats the proper formula for this activity? row 3 - column c is a number - 20 column d is a number...
August 25th, 2008 10:35 AM
by Sandy Mann Go to last post
3 96
Using If then to change cell colors in Excel 2007 by Randy
I'm creating a worksheet to calculate money.. If the amount is negative I want Excel to display the number in 'Red'.. If Positive I want to have Excel...
August 25th, 2008 08:49 AM
by David Biddulph Go to last post
5 132
Worksheet Functions by Steve Peel
My simple formula referencing the value of another cell is written over by that value when the value of the referenced cell is changed? This is a strange...
(Multi-page thread 1 2)
August 25th, 2008 05:06 AM
by Max Go to last post
12 201
Formula to enter names in a column specific # of times by Steve
I’m using the following to produce a random picking of names in the B column. =INDEX($B$1:$B$100,RAND()*100+1) Each name is entered a different number of...
(Multi-page thread 1 2)
August 25th, 2008 04:21 AM
by T. Valko Go to last post
10 173
Question on create chart by Blue Fish[_2_]
Hello: I would like to have summary of the existing OS in % ratio with Pie Chart present. May I know how can I create in base on the existing data? Attached...
August 25th, 2008 03:24 AM
by Blue Fish[_2_] Go to last post
0 99
Post New Thread


Display Options
Showing threads 21201 to 21220 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 06:04 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.