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 Reverse Sort Order / Thread Starter Last Post Replies Views
5 minutes intervals by april
I have a column that is sorted by time & date in one min. intervals. I need it to show me the time in 5 min. intervals. Obviously excel can do this I just...
October 24th, 2006 12:32 AM
by Pete_UK Go to last post
2 75
5 year service awards by PAR
I need to use conditional formating to highlight 5 year incremental service awards in a spreadsheet. Column A has hire date, column b figures the years of...
March 22nd, 2006 04:11 PM
by PAR Go to last post
0 110
50% formula by wally
I have winxp 2003. I have a sheet named data which has a list of names that looks like this; in cell a1 #1 Jackson - #2 Johnson in cell a2 #3 Smith -...
August 11th, 2006 01:43 PM
by wally Go to last post
2 128
5th Char in a cell by enna49
Hi I know this is simple, and I know I should know it, but I cannot get it to work and I have searched Help and the answers seem more complicated than what...
February 9th, 2010 06:01 AM
by enna49 Go to last post
3 138
6 cell sum by dc04wrightl
Hi, I need a formula or a mathematic help. Basicaly i have 6 cells. I need to tell it to be 0.1 when 1 cell if filled in 0.2 when 2 cells are filled in 0.3...
January 14th, 2008 07:08 PM
by RB[_3_] Go to last post
2 116
6 Day working week (friday holiday) by Dan Johns
Hieveryone, I am an excell novice trying to put together a project calculation sheet. I need to calculate total days between 2 dates excluding each and every...
January 9th, 2010 07:01 PM
by Roger Govier[_3_] Go to last post
2 170
6 day/week function ie:networkday by Robert
i am trying to calculate how many days between 2 dates that excludes holidays, but includes saturdays. Networkdays is only for 5 day work weeks...i need it...
August 6th, 2007 12:06 AM
by daddylonglegs Go to last post
6 107
6 months of working days by Jennifer
Hi, I'm trying to figure out how to calculate what 6 months of working days would be. I've tried the various Networkdays formating, perhaps I'm using the...
October 20th, 2005 04:36 PM
by KeLee Go to last post
2 102
6 or more conditional formatting by Conditional Formatting
Please give me sample of macro with 6 or more conditional formatting using the drop down boxes for example apple cell turns to red banana cell turns to ...
July 3rd, 2005 04:32 PM
by David McRitchie Go to last post
2 82
6.00 to this 0600 please by Steved
Hello from Steved I have 2 columns one with =INDEX(Inward!H5:IV5,MATCH(TRUE,Inward!H5:IV5"",0)) and the second with =(D2+12)*100 Please can i combine the...
June 13th, 2005 04:22 AM
by Steved Go to last post
2 84
60% formula by wally
I have a bowling league with 16 teams; each team has its own statistical sheet named 1 thru 16. Each week I manually compare the team averages of the teams...
August 9th, 2006 11:53 AM
by wally Go to last post
2 66
61 Hosting Web www.ivys.es by tesddalws
Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web www.Ivys.es Hosting Web...
November 4th, 2009 12:58 PM
by tesddalws Go to last post
0 169
64k row limit by Jim
I copied the macro and it works on text files, but will this work if you have a .csv file or does it have to be text? What I have is an extra large .csv file...
May 3rd, 2006 09:17 PM
by Jim Go to last post
3 82
66,000 excel record limit by [email protected]
how do you split a file into two (in Excel) when you have exceeded the limit of 66000 lines. please advise. thanks, pago
March 15th, 2007 08:01 PM
by Gord Dibben Go to last post
4 84
7 Day Pacing Formula Help by bbal20
Okay. I'm posting this for a second time in hopes that I can get some help. I am trying to right a formula that gives me a pacing number for the end of the...
June 1st, 2009 03:53 AM
by Dennis Tucker Go to last post
4 165
7 day workweek timesheet - excluding lunch by S in AZ
I thought I alreayd posted this but don't see it anywhere, so forgive me if this is duplicated somewhere. I am looking for a formula to calculate total hours...
September 8th, 2006 11:26 PM
by fryguy Go to last post
3 107
7 Function rule by helpme
Is there a way around the excel rule that you may only have 7 functions in one formula, im trying to do an if statemet with like 15 IFs.....can this be done
December 29th, 2006 02:41 AM
by Ron Rosenfeld Go to last post
4 83
7 function rule cont. by helpme
ok everyone asked for more details, so here they are...good luck and thanks for helping. Specifically i have a two page workbook, on the first page is a...
December 29th, 2006 02:45 PM
by Don Guillett Go to last post
1 82
7 previous days average by Carlee
Hi All, Question: What function can i use to create an average value of the previous 7 days? Column AJ contains data, which is added to everyday Column B...
October 28th, 2007 10:02 PM
by MartinW Go to last post
9 97
7+ Nested if Statement using indirect function by klysell
Hi, I have a nested if statement that doesn't seem to be working. I have two questions. First, how do I equate the first instance of $E12 to be either "",...
August 23rd, 2007 08:47 PM
by Harlan Grove[_2_] Go to last post
6 72
Post New Thread


Display Options
Showing threads 1001 to 1020 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:38 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.