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 Reverse Sort Order Last Post Replies Views
nested formula help needed by
My experience is Yes, you are limited to seven nested functions. But my question is, do the functions really need to be nested? I ask this because I received...
October 14th, 2003 04:17 PM
by Go to last post
0 355
Excel formula - select cells based upon fill color and then sum by
-----Original Message----- I want to sum data baed upon the fill color. An existing spreadsheet has been manually shaded to show the "selected cells". ...
May 13th, 2004 07:45 PM
by Go to last post
0 1,576
Referring to form controls in formula by
How do I reference a form control in a formula? Example: I have a list or drop-down box on an Excel form with values A, B, C, etc. How would I reference the...
June 15th, 2004 08:00 PM
by Bob Phillips Go to last post
1 88
copying Text by
how can i set a cell on sheet 2, to copy text from sheet 1 and if the cell on sheet 1 is blank then so is the cell on sheet 2.
July 13th, 2004 03:13 PM
by Go to last post
5 99
changing color if value exceed speficied amount by
What would the formula be so that if a vaule is exceeded it would change the color of the value. lets say if the vaule is 75% or greater you would want...
July 13th, 2004 04:27 PM
by Andy B Go to last post
2 129
Would use Array formulas but.... by
I am studying examples of array formulas just to get the feel of them so I can use them when needed. But the message I get when entering the formula...
July 21st, 2004 05:56 PM
by havelasco Go to last post
3 308
Macros disabled message by
Sometimes I get this "Macros Disabled", but sometimes I don't. I'm getting it right now, and it's driving me crazy, how do I get rid of it?
August 10th, 2004 08:51 PM
by Gord Dibben Go to last post
2 308
finding the difference in years between dates by
Hi I need a formula which will work out the difference in years between two dates to calculate age. For example if I type 8/8/1984 into A1 and 8/9/2004 into A2...
August 19th, 2004 10:58 PM
by Frank Kabel Go to last post
5 264
Link Cell to header and footer by
Is there a way to link part of the footer information to a cell in a spreadsheet? Someone I work with wants to have control over updating the revision date...
August 31st, 2004 07:42 PM
by Frank Kabel Go to last post
1 169
Spell check and protected worksheet by
Does anyone know how to enable spell check when a worksheet is protected? I've tried a number of different options, but whenever I protect the worksheet I...
April 8th, 2004 09:23 PM
by Go to last post
2 372
How to determine duplicate records by
Hello there! Anybody could help me? I want to know if there is a way I could determine a duplicate entry about 10000 records becuase i do it manually: for...
March 23rd, 2004 04:51 PM
by Go to last post
0 132
Transpose Worksheet by
I have a worksheet that is two hundred rows long and uses every column in the worksheet. I have several more columns to enter so I need to switch the columns...
October 16th, 2003 04:29 PM
by Peo Sjoblom Go to last post
1 132
error bars excel97 by
G'day, I am wanting to add error bars to a graph. I looked up help and it said to select the data series, go to the format menu and click data series. but when...
October 19th, 2003 02:46 AM
by Scottmk Go to last post
1 150
Average based on two rows and two criterea? by
Caution: I have a tendency to go to San Fran by way of Miami. With that disclaimer... In FIRST column to right of Grand Total, enter: =IF (e10,1,0) NEXT...
December 12th, 2003 04:16 PM
by akyurek Go to last post
2 228
vlookup table_array reference listed in another cell by
If anyone can help with this vlookup question I would appreciate your input. I am trying to place in the vlookup...
December 12th, 2003 06:25 PM
by Paul Go to last post
2 258
How to lock one cell in formula? by
There are two types of cell references -- relative and absolute. When a relative cell address in a formula is copied, the actual address is modified to...
December 26th, 2003 02:22 PM
by orlando Go to last post
2 518
Alignment by
Thanks Frank - your solution works a dream Steven. -----Original Message----- Hi Steven try the following custom format 0.???? use as many '?' as you...
February 10th, 2004 10:15 AM
by Frank Kabel Go to last post
1 120
lookop or index? by
I'm looking for a way to look up/return a value based on 2 nubers like below: I need the balance for Account 57500, & Cost Center 125 from a trial balance...
March 12th, 2004 06:19 PM
by Dave R. Go to last post
4 86
Mouse is scrolling slowly by
Hi Guys, I have had excel 2002 before and just picked up 2003 and in my excel sheets scrolling is very slow whenever i scrolling in an empty or full...
March 28th, 2004 09:18 AM
by Go to last post
0 493
#DIV/0! by
I've got a YTD spreadsheet that will be fed each month from monthly spreadsheets... In some of the cells within the monthly spreadsheets it is #DIV/0!... As...
September 8th, 2004 07:02 PM
by Frank Kabel Go to last post
1 146
Post New Thread


Display Options
Showing threads 301 to 320 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 05:48 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.