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
IF Formula take 3 by Matt
Sorry for not explaining the problem better. With the formula =INT((TODAY()-D10)/365.25); I get a value of "0" for the first year past todays date, and I can...
November 8th, 2007 08:56 PM
by Niek Otten Go to last post
2 47
cell formatting by Tom
is there a way to take an area of about 10 rows and change the cell height to 0.1 so that there are now 100 rows in the original area?
November 8th, 2007 08:49 PM
by Rick Rothstein \(MVP - VB\) Go to last post
5 43
Unlocked Cells in Protected Sheet by KMA
When i have set a protection in a sheet, i can change the fill color, font, etc in the unlocked cells?
November 8th, 2007 08:08 PM
by Gord Dibben Go to last post
3 65
Formatting? may be by ab3d4u
I do a lot of subtotaling. I have different depts with diffeent charge codes but all share the same GL code. Ex Printing/Copy GL code 4400, for admin it will...
November 8th, 2007 07:40 PM
by RyGuy Go to last post
1 84
Page numbers on various worksheets by Matt @ L Bar Nevada
I am using Excel 2007 and have various worksheets that I will print out one after another. Basically I want to put custom page numbers(different from the...
November 8th, 2007 07:34 PM
by Matt @ L Bar Nevada Go to last post
0 79
Hyperlink to range of cells by DaveFinn
I have this worksheet that has lots of graphs etc. I would like to make the reading experience better for users so that they wouldn't have to scroll down all...
November 8th, 2007 07:29 PM
by Beege Go to last post
8 76
Alt + enter is not inserting a line break within a cell in Excel? by Mattwpaul
I have tried double clicking the cell and going within the date entry box, does not work.
November 8th, 2007 07:22 PM
by Gord Dibben Go to last post
1 56
Separating information in cell by Cynthia
I am using Excel 2003 SP2. I receive reports with first and last names together in one cell: Jones,Edward Smith, David Longview,Samantha Is there a way to...
November 8th, 2007 06:30 PM
by T. Valko Go to last post
5 57
Average the POSITIVE values only by John
How do I average all the numbers in a column but only the positive numbers in that column?
November 8th, 2007 05:52 PM
by joeu2004 Go to last post
5 67
IF formula with 3 possible outcomes by Aaron Hodson \(Coversure\)
Hello everyone, I am trying to get the following formula to work, without success. I would like C3 to have 3 possible outcomes, 1,2 or 3. This data will be...
November 8th, 2007 05:52 PM
by JE McGimpsey Go to last post
8 118
Indirect - Multiple Sheets/Cells by Keep It Simple Stupid
I have several sheets that I need to pull the information from cells K20, K65, and K79 for each sheet. On a "Summary" sheet, I have listed the sheet names in...
November 8th, 2007 05:39 PM
by Gord Dibben Go to last post
5 67
How can I get date of file creation to XLS cell in date format? by Radek Simek
I'm using Excel Standard Edition 2003 (11.5612.8132) and have following problem. I need to get date of file creation (e.g. from Properties - file created)...
November 8th, 2007 05:24 PM
by Gord Dibben Go to last post
3 119
IF Formula by Matt
Take 2.. I am trying to get a formula that will assign a numeric value for a each year past "TODAY". The TODAY date needs to change every day. Today to...
November 8th, 2007 05:24 PM
by JE McGimpsey Go to last post
2 58
remove colored rows by climate
Hi I have 2 columns that many of it's rows has colored ( colored cells in first and second column is equal) , i want to remove colored rows. Would you please...
November 8th, 2007 05:17 PM
by Gord Dibben Go to last post
6 66
Formaulating in Execel by Matt
Can some one help me with the following formula? I need to create a IF formula that will start with the current date "=TODAY" and count backwards appling a...
November 8th, 2007 05:01 PM
by David Biddulph Go to last post
4 70
IF Formula by Matt
Can anyone help me with the following formula?
November 8th, 2007 04:57 PM
by Matt Go to last post
0 53
Excel Macros 2003 into 2007 by Lyndsey Wood
I have created a button (using the VB toolbox) in a 2003 version of excel. I then saved the workbook and opened it up in excel 2007. When I click on the...
November 8th, 2007 03:49 PM
by Jim Rech Go to last post
1 69
Price Function by snowsnow
Hey Guys: Can anyone tell me how Excel pricing ACT/365 using Price formula? Because If I do it manually, I don't get the same answer. I have looked at the...
November 8th, 2007 03:12 PM
by Bernard Liengme Go to last post
4 60
Return the minimum number in a range excluding zero by Jive
Hi I am currently using the following to find the maximum value in a range($G$120:$G$219), when the corresponding value in range ($H$120:$H$219) is equal to...
November 8th, 2007 02:41 PM
by Ron Coderre Go to last post
3 70
INDEX FORMULAS & MULTIPLE TABLES by Aaron Hodson \(Coversure\)
Hello everyone, I am using the below formula to capture data from a table in my spreadsheet: =INDEX(F3:H22,MATCH(B9,E3:E22,0),MATCH(B3,F2:H2,0)) Within the...
November 8th, 2007 12:11 PM
by Aaron Hodson \(Coversure\) Go to last post
9 89
Post New Thread


Display Options
Showing threads 32001 to 32020 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:10 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.