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
calculate overtime & doubletime by shizuka
Hi... I am having a hard time calculating over and double time. I am making a list and i have this columns: Start time Finish Time Reg time Overtime Double...
March 5th, 2009 09:40 PM
by Gord Dibben Go to last post
1 722
Number of days falling in various years by Revenue
I am starting two dates in my example. The first is 6/20/02 and the second is 1/15/2006. I need to calculate in separate columns for years 2001 through 2006...
March 29th, 2010 09:34 PM
by Revenue Go to last post
4 721
Spell Check in Text Box while protected by Ron Green
I have created a spreadsheet for our employees to use that includes several text boxes for their narrative. The spreadsheet has many macro functions and...
May 25th, 2004 08:23 PM
by Paul B Go to last post
4 720
How to compare and move false information to another cell by honjoann
I am trying to compare A2 and A4 to B3 if b3 equal A2 then move A4 to N3 if not then move A2 to N3. I am new to using formulas in excel
April 4th, 2010 04:10 AM
by ozgrid.com Go to last post
2 719
#VALUE! Error by DJL
in cell E8 I have this formula: =IF(ISBLANK(D8),"",D8*$B$2) I get the #VALUE! error. Can someone tell me why and how I can correct it. I am just trying to say...
December 24th, 2005 09:38 PM
by Ragdyer Go to last post
7 718
Finding Unmatched Records by PA
Using Excel 2007, I have two worksheets, one has a list of national membership, including an ID # in column A, the other will contain the similar information...
April 21st, 2010 03:47 PM
by Eduardo Go to last post
2 714
How do I set up a payroll spreadsheet will update weekly? by torit
I am not familiar with Excel and need to know how to set up a payroll spreadsheet that uses a formula to update payroll weekly
(Multi-page thread 1 2)
March 22nd, 2009 08:35 PM
by T. Valko Go to last post
11 714
Organizing worksheets in a workbook by jpnga
I have a master worksheet with system downtime data. Example System Date owner time down XXX 12/5 Jim 12:45 YYY 12/5 Jim ...
December 27th, 2005 10:46 PM
by Bill Ridgeway Go to last post
1 712
Conditional Formatting for a Range by KKD
I want to apply my formatting to an entire range. I see there are several similar questions posted already but I'm not having success with the answers...
April 1st, 2010 04:12 AM
by Ms-Exl-Learner Go to last post
2 712
tabulating survey results by McNiwram
I have created a survey from in excel containing 10 questions with each number having 5 choices (1-bad...5- Very Good). I will send the survey form out to...
May 18th, 2004 12:10 AM
by CLR Go to last post
7 706
dates suddenly changed from x/xx/2004 format to number by scheinz
I set up my excel 2003 for dates to be written 4/25/2004 and instead all I get is serial numbers. I tried to format the cell for the date as above but it only...
May 1st, 2004 02:54 AM
by Debra Dalgleish Go to last post
1 705
how do i delete a file from recent documents file in excel by exile
can anyone help how do i delete a heading from recent documents file i have deleted figures from actual page but cannot get heading to go iknow how to do with...
March 7th, 2009 01:59 AM
by Gord Dibben Go to last post
1 703
column header labels are numbered but need to be lettered by solgash
I need column heads to be lettered but both column and rows are numbered .. help !
April 2nd, 2010 10:42 AM
by ozgrid.com Go to last post
2 701
Macro Problem by DiscipleTom
I'm created a simple macro to enter the current date and time =NOW(). That works with the macro...however, I can't get it to stop moving over to the next...
March 28th, 2010 01:30 PM
by Don Guillett[_2_] Go to last post
4 700
excel - numbers as text by Thuferhawat
how do I keep 16 digit numbers as text in excel? I format the cells as text ahead of time but when I cut and paste the numbers in the last digit is converted...
(Multi-page thread 1 2)
January 24th, 2005 09:29 PM
by IanRoy Go to last post
12 700
Formula works in some cells, doesn't in other by Wowbagger
I have a multi-sheet 2003 workbook. Sheet 1 is a summary that displays data from the other 4 sheets, the name of one of which is "Northeast" (though...
(Multi-page thread 1 2)
June 30th, 2005 03:21 PM
by Max Go to last post
13 696
#Div/0 by H
Hi - is there a way to avoid getting this result #DIV/0? Can I divide and get a line or something instead when there is nothing to divide by? =B5/A5? Thank...
(Multi-page thread 1 2)
July 31st, 2009 06:13 PM
by H Go to last post
10 695
The pivot tables 101 article says to use the "Create List" comman. by cgnoland03
I cannot locate the "Create List" command anywhere, yet in the beginning article on pivot tables for excel 2002-2003, it says to start with a "list: A series...
January 14th, 2005 11:39 PM
by IanRoy Go to last post
2 691
Extended IF Formula by Barny[_4_]
I use this formula to return the value in cell if the criteria is met but I would like to extend this to say that the value is also returned if cell J89 =...
April 1st, 2010 05:12 PM
by Barny[_5_] Go to last post
4 688
IF FORMULAS by JOHN
Looking for help...... In column A1:A16, I have names. In B1:B16 I will assign random numbers to those names from 1-16. In another part of the sheet I have...
September 28th, 2009 09:32 PM
by Bob Umlas[_3_] Go to last post
1 687
Post New Thread


Display Options
Showing threads 321 to 340 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 02:53 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.