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 : New Users Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Views Reverse Sort Order
formula to convert 15 minute to hourly data by Emily
I need a formula to convert 15 minute timestep data to hourly average (an average of the four 15 minute data points for the hour). My spreadsheet looks like...
May 20th, 2010 12:18 AM
by penny Go to last post
4 1,154
League table automatic sort/update by RedHook
Hi All I'm just getting up to speed with Excel and as an exercise I'm trying to implement a simple league table. What I'd like to know is how to create...
(Multi-page thread 1 2 3)
May 18th, 2006 02:44 PM
by Bob Phillips Go to last post
23 1,153
How do I copy a formula from one worksheet to another? by cahduq
I have a formula in one worksheet and want to copy that result to a cell in another worksheet. When I try to do that, I get "#REF#" in the destination cell....
(Multi-page thread 1 2)
April 1st, 2010 03:58 AM
by Rod Go to last post
12 1,151
Can't close Excel worksheet by Loring Hutchinson
I am running Excel 2003, using Win XP (Home Ed). I opened a worksheet I was working on and when I went to save the file, I went to The FILE pulldown menu and...
April 27th, 2010 08:10 PM
by Deborah Laughrey Go to last post
5 1,150
How do I calculate monthly gains/losses in excel by ragingriver30
For a family budget how would I calculate monthly gains/losses in Excel?
May 23rd, 2010 01:51 PM
by John Go to last post
2 1,148
numbering rows by jane
Is there a way to number each row in Excel so that when it prints out the rows all have numbers? I couldn't find it in Msft online Help but I guess that's no...
April 24th, 2004 01:43 AM
by JE McGimpsey Go to last post
2 1,146
A zero result by Tonya Marshall
I am very new to Excel and having to learn everything from a blank slate. My friend gave me the following formula to calculate days of stay and it works well...
(Multi-page thread 1 2 3)
August 22nd, 2004 04:00 PM
by Tonya Marshall Go to last post
21 1,146
List Box Size by Orf Bartrop
I have created a validation list box but is too small to display all entries without scrolling. Is there any way to increase the size of the box? Also, is it...
(Multi-page thread 1 2)
May 29th, 2004 02:10 AM
by Debra Dalgleish Go to last post
12 1,142
Formatting dates in Excel by bernrunner15
Hi I have thousands of numbers to format into dates. The problem is, for some reason when I choose the column which the dates are in, i'll get a completely...
May 11th, 2004 10:32 PM
by Anders S Go to last post
4 1,124
Golf scores by Pop Sturman
I am trying to change the cell colour depending on the input against the actual Par . ie Column A = the actual par for each hole, Column B is the actual...
May 31st, 2010 01:35 PM
by Sheeloo Go to last post
2 1,113
Template for Housing Society Maintenace Billing in India by shaikh37
For Printing Housing Society Maintenace Billing in bulk.
August 24th, 2006 05:33 PM
by Gord Dibben Go to last post
1 1,112
How to calculate frequency of lottery numbers? by Xray_Man
I'm new to Excel, so please explain things to this newbie in non-technical terms as much as possible! I have downloaded the array of previous week's winning...
(Multi-page thread 1 2 3)
June 4th, 2009 03:03 AM
by Xray_Man Go to last post
23 1,108
Template in Excel by prettytwin1
I want to create a group sales agreement template in Excel like I can with Word. I know it involves databases and workbooks. I just can't remember how to do...
March 9th, 2005 10:22 PM
by gls858 Go to last post
1 1,095
Meter Readings by Maria Tracey
Hello I've been tasked with creating a spreadsheet that records the monthly electricity meter readings where I work. It's a big site with aboout 20 different...
(Multi-page thread 1 2 3)
April 21st, 2006 09:09 PM
by Sandy Mann Go to last post
21 1,087
How to round the numeric value? by Salman Saeed
Kindly tell me that how can we round the numeric value? Example: 1.2 = 1.5, 1.7 = 2.0
April 27th, 2010 02:32 PM
by JLatham Go to last post
9 1,084
How do I find older versions of a spreadsheet by Peppermint
I did a sort on a spreadsheet and the one column looks like it was not included, i have to find an earlier version of the spreadsheet and cannot remember how...
May 31st, 2010 07:05 PM
by Gord Dibben Go to last post
2 1,080
Conditional Formatting by John Calder
Hi I run Excel 2K Conditional Formatting in Excel 2K only allows three conditions to be applied. I need 8 conditions. What I have is 8 check boxes that...
May 25th, 2010 02:07 AM
by John Calder Go to last post
8 1,072
#N/A error by Bill R[_5_]
I have SpreadsheetA which (in a column) takes data from SpreadsheetB (in a row). (A simple = ...). So far so good and both spreadsheets are saved and...
May 15th, 2010 09:18 PM
by JLatham Go to last post
5 1,052
Set a minimum row height a the same time with autofit row height by Julie B
I want to set a minimum row height, but allow autofit for anything that is greater than that height. Is this possible? i.e. If i have a cell with one line...
April 29th, 2010 11:11 PM
by Dave Peterson Go to last post
1 1,050
How to convert a month to a quarter ...... by Epinn
Hi, ....... using date function(s)? I have no problem converting a *date* to a quarter using the following...
(Multi-page thread 1 2 3)
November 28th, 2006 12:36 PM
by Epinn Go to last post
25 1,049
Post New Thread


Display Options
Showing threads 61 to 80 of 13737
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 10:38 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.