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
Easy to do but cannot remember how! by Chivalrous1
A B 1 SUM(A1) 2 SUM(A1:A2) 3 SUM(A1:A3) 4 5 6 7 Question is, how do I fill down so that A1 stays as a constant? When I
July 10th, 2008 06:35 PM
by Gord Dibben Go to last post
3 70
How to Compare between cells and choose smallest value by Smallest value cell change color
If I have four cells, and I want the one with the smallest value change color automatically.
July 10th, 2008 06:21 PM
by T. Valko Go to last post
5 99
How do I force entry in multiple cell ranges in one worksheet by CindyB
I need to be able to force a user to choose from a drop down box from several columns in one worksheet. As an example, I have drop down boxes in column d,...
July 10th, 2008 06:08 PM
by CindyB Go to last post
0 74
ACCRINTM() function by Zumble
Hi, I know about the ACCRINTM() function in Excel which returns the Interest-Accrued between the Issue date and the Settlement date at a given Rate ...
July 10th, 2008 05:59 PM
by Niek Otten Go to last post
1 77
the font colour icon in excell 2007 kicks me out of the programme by delysia
i want to change the font colour in excell 2007 but when i click on the icon in the toolbar the programme stops and kicke me out
July 10th, 2008 04:35 PM
by Ron de Bruin Go to last post
1 92
Fill down with references to worksheets by [email protected]
There are a number of posts on this subject, but I couldn't find exactly what I was looking for! I have a workbook with a number of invoices, all the same...
July 10th, 2008 04:20 PM
by Zumble Go to last post
3 85
Connecting Graphs to a linked worksheet by MayJuneJuly
Hello, I have a workbook with a main worksheet that has many formulas, conditions, and data. I would like to create graphs from this data to show monthly or...
July 10th, 2008 04:04 PM
by MayJuneJuly Go to last post
0 95
Worksheet Linked to graphs by MayJuneJuly
Hello, I am using Mircosoft Office Excel 2003. I have a worksheet with many columns, formulas, and conditions. This worksheet is linked to sever other...
July 10th, 2008 04:01 PM
by MayJuneJuly Go to last post
0 79
List or colour Cells of results by Jamie
Excel 2007 =If(VLOOKUP(B3,$A$2:$A$10,1,FALSE),COUNTIF($A$2:$A$13,B2),"") The above formula is looking at a figure in a selected cell then looks in the...
July 10th, 2008 03:28 PM
by Jamie Go to last post
1 65
Counting on 2 criteria by Richie
Hi, I am trying to count the number of entries in a spreadsheet where i have 2 criteria. One column contains the dept name eg "Sales" and another is a score...
July 10th, 2008 03:26 PM
by PCLIVE Go to last post
2 55
Excel Autoformating cells by Piglet
Is it possible to stop excel from Auto formatting a cell into date fprmat when you paste date in from the internet?
July 10th, 2008 03:22 PM
by Gord Dibben Go to last post
3 96
a little help? by BBB
hi, what i am trying to do is have a validation or list provide options from another valiadation. this is so that i can select a category "A" in the first...
July 10th, 2008 02:57 PM
by Pete_UK Go to last post
3 63
how do i get zeros to show after decimal point? by gwreed
I have an excel file that I am using for a mail merge. I need the numbers in the excel file to come into the Word doc with zeos after the decimal to show as...
July 10th, 2008 02:56 PM
by David Biddulph Go to last post
2 81
Help with multi sheet workbook by Sportinus
I have 12 worksheets that have a players number and name in the first lines followed by a batting order and position for each player. Each sheet represents...
July 10th, 2008 01:41 PM
by ryguy7272 Go to last post
2 114
Sumif function by SRobson
I need to sum data in cell(s) in the same column whose reference is derived from: Row: Heading of the column the formula is in Column: Data that is in column...
July 10th, 2008 01:32 PM
by SRobson Go to last post
0 69
2 data sets in pivot tables by SYRINX
Can someone advise - when creating a pivot table showing 2 sets of data in the summary section in Excel 2003, if you drill down to display only one set of...
July 10th, 2008 01:04 PM
by SYRINX Go to last post
0 71
SUMIF function by Igor[_2_]
Hi Is it possible to use AND in SUMIF function. I have a simple table with three columns. The first column contains dates in chronological order. I want to...
July 10th, 2008 01:00 PM
by David Biddulph Go to last post
3 74
Date Entered +7, unless another field is greater than 0 by chickalina
I have a column H which is the date a work orderis entered into the spreadsheet. This date is automatically entered with TODAY() as soon as something is...
July 10th, 2008 12:48 PM
by chickalina Go to last post
2 92
Date and time stamping with a (macro) button by ArcticWolf
Hi, I have a piece of machinery that breaks down (as they do). I want my production manager to start recording the occurances of these break downs. He is...
July 10th, 2008 12:26 PM
by Mike H Go to last post
4 82
Find a color value by Scott
G’Day, I have a worksheet which users can change the color of a particular cell – assume C3. What I want to do is change the color of another worksheet...
July 10th, 2008 11:59 AM
by Scott Go to last post
5 102
Post New Thread


Display Options
Showing threads 23081 to 23100 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 08:17 AM.


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