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
Why would an Excel worksheet scroll at 45 degree angle? by MsJaRee
Has anyone ever had a worksheet scroll at a 45 degree angle? Why would this happen?
August 6th, 2008 02:48 AM
by Otto Moehrbach[_2_] Go to last post
1 119
Multi funtion worksheet by Maria
I need to create a worksheet that would allow for me to send out a few sheets for updating and then consolidating using new data
August 6th, 2008 02:36 AM
by ComicFly Go to last post
1 129
Compound Average Annual Growth Rate by PatJennings
Can someone help define the formula to calculate the compound average growth rate (CAGR) starting with an initial amount which grows or shrinks depending...
August 6th, 2008 02:24 AM
by Fred Smith[_4_] Go to last post
3 134
format color without conditoinal formating by WT
Is there any way to change a background color or font color in a formula, without using conditional formating. I am currently using a 2003 version and...
August 6th, 2008 12:19 AM
by Gary''s Student Go to last post
3 196
formula to drive plus or minus as operator by Newsgal
We have a standard formula to show the variance of 2 totals (A1-B1 = Variance). However, it only works when B1 is a positive number. Is there a formula that...
August 5th, 2008 11:55 PM
by Newsgal Go to last post
4 118
Formula to figure an average on a range of cells with an "if" form by lucyo912
I have a spreadsheet that has a formula in column g that is an "if" formula for the data in column f. I need to get an average of the data in column "g". ...
August 5th, 2008 11:48 PM
by Peo Sjoblom[_2_] Go to last post
6 129
SUMIF criteria by lkawecki
I want to add the numbers in a column that are in cells that are not filled. I tried the formula: =SUMIF(A2:A5,"no fill") and got the result, 0. A2:A5 is the...
August 5th, 2008 11:47 PM
by Max Go to last post
4 184
show value of row one based on min of row two by Alexanderi
I have a row of dates in a1 to i1 the next row has values in a2 to i2 then j2 shows the min of these. How can I get the date above the min in row a2 to i2...
August 5th, 2008 11:22 PM
by T. Valko Go to last post
4 120
Create a drop-down list from a range of cell by Olivia
I was wondering if someone can explain to me the steps to take for creating a drop-down list from a range of cells using a different worksheet in a different...
August 5th, 2008 11:09 PM
by Olivia Go to last post
4 213
Fill Color If Statement by Elgee
Hi - In a workbook I track project financials. IE: Forecast, Actuals, Variance etc. Cell A2= Forecast Cell A3= Actuals Cell A4 = Variance I would love for...
August 5th, 2008 10:13 PM
by Elgee Go to last post
3 155
Picking a cell that is next to a cell by Chris
I have a worksheet: Column A lists the letters of the alphabet, column b is a series of text data and column c is numerical data. i.e. A B C A ...
August 5th, 2008 09:08 PM
by T. Valko Go to last post
4 151
How to make up an excel book that I can import other programs in by jumlor
I am doing PPAP's and I need to import many different forms into a excel book and send it to my customer who would be able to print all the fdifferent formats
August 5th, 2008 08:44 PM
by Spiky Go to last post
1 94
August 5th, 2008 08:29 PM
by Peo Sjoblom[_2_] Go to last post
2 90
Multiple Fonts in Excel Equation by HM
I've been trying to find a way to have more than one font in an equation but have not been successful through Excel's help option. If anyone's been able to...
August 5th, 2008 08:28 PM
by Gord Dibben Go to last post
1 96
using solver question by jvc007
How do you perform and inclusive or test using solver. I need Y1 to equal 1 if x11 or x21 is greater than o and Y1 to equal zero if both x11 and x21 equal...
August 5th, 2008 08:26 PM
by Spiky Go to last post
3 90
Linking worksheets, but exceptions by Emily
I have a worksheet with columns A - W. Column P contains names of a contractor. I want 7 more worksheets named the contractor names ( I can do that), but I...
August 5th, 2008 08:06 PM
by Otto Moehrbach[_2_] Go to last post
4 112
Calculate flying times using 24hour clock and 0000 general format by Cobra2140
I am trying to calculate flight hours using 4 digit 24 hour clock. For example; an aircraft takes off at 1400 and lands at 1530. It flew for 1 hour and 30...
August 5th, 2008 07:57 PM
by Ron Rosenfeld Go to last post
3 96
formula to add six months to date by lonedove288
I haven't used Excel in a while but I need to figure a formula to change dates by six month increments in several different columns. I can't, for the life of...
August 5th, 2008 07:44 PM
by Ron Rosenfeld Go to last post
3 85
Please help me with this function? I am struggling.. by Gina[_3_]
The first row of the spreadsheet contains headers. In Cells D2:D2500 my spreadsheet gives a list of dates specific events occur. In Cells G2:G2500 my...
(Multi-page thread 1 2)
August 5th, 2008 07:41 PM
by Bernie Deitrick Go to last post
10 151
VLookup by Kimberly
I want to know how to do a VLookUp (I think that is the formula, I would you use) with multiple criteria. For example: If the supplier is George O'Days and...
August 5th, 2008 07:33 PM
by J Sedoff comRemove> Go to last post
2 66
Post New Thread


Display Options
Showing threads 22021 to 22040 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:16 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.