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
Get rid of #DIV/0! without repeating denominator? by Go Bucks!!![_2_]
I have some very long denominator formulas and these formulas are repeated many times. Is there an alternate method to avoid the #DIV/O! error WITHOUT...
(Multi-page thread 1 2)
May 13th, 2010 09:24 AM
by Chris Oosthuizen Go to last post
10 340
Using Custom Views with Protected Worksheets by Beverly
I'm using custom views and I have 19 tabs that reference each other - one tab has a graph and a pie chart. As soon as I try to protect any of the worksheets...
May 13th, 2010 05:22 AM
by Beverly Go to last post
2 264
Time Format Question by Toria
Hello, I currently have time entered like this: 173517 90207 I need to look like this: 5:35 p.m. 9:02 a.m. I've done a ton of research but nothing has worked...
May 13th, 2010 05:11 AM
by T. Valko Go to last post
6 122
SD03*10 -how do I just get the numbers at the end in cell after * by Helen Maguire
,I have SD03*10 in a cell and I want in a separate cell, just to have the numbers after the *. Obviously with lots of data, the digits after the * could be 1...
May 13th, 2010 04:54 AM
by L. Howard Kittle Go to last post
5 153
Ziping excel 2007? by excelleration
My company recently upgraded to office 2007. With excel 2003 I could zip a 30-35mb file to less than 5mb. The same kinds of files/data in 2007 only zip from...
May 13th, 2010 02:14 AM
by David Biddulph Go to last post
1 102
populate month-yyyy when compare 2 cells by AskExcel
Dear Forum, I have a scenario where I need to compare 2 date cells. When cell1 empty then take cell2 and format the date month-yyyy in cell3. When cell1 not...
May 13th, 2010 02:14 AM
by AskExcel Go to last post
3 102
runtime error code 1004 by Karen
I set up a macro in Excel 2003 but when my associate tries to run the Macro in 2007 she is getting a run time error 1004. I noticed in another post it could...
May 13th, 2010 12:21 AM
by Dave Peterson[_2_] Go to last post
1 121
Zero and Null Sum Function by Frustrated by Averages[_2_]
I have the following formula in place: =IF(SUM(I14:N14)1,SUM(I14:N14),"") The problem I have is when zeros are legitimately entered in the reference fields...
May 12th, 2010 11:19 PM
by Frustrated by Averages[_2_] Go to last post
3 126
Cell Function/Font Color by HpyTrvlr69
Is there a CELL Function that you can identify the color of a font with? I would like part of a macro to make a decision based upon the color of the font in a...
May 12th, 2010 11:08 PM
by HpyTrvlr69 Go to last post
2 105
Finding next number in a series by Iriemon
I have a series of numbers in one column (sample): 1 2 4 5 7 16
May 12th, 2010 09:11 PM
by T. Valko Go to last post
2 124
=SUBSTITUTE(C4,"~?#","") will this work to remove multiple string by Raja Mahendiran S
Hi All, I need to remove multiple string (special characters) in an excel field. Would the following work =SUBSTITUTE(C4,"~?#",""). I need to execte this...
May 12th, 2010 09:10 PM
by Raja Mahendiran S[_2_] Go to last post
6 114
Conditional Formats, how to scroll and view all formats? by Bill E
Good day! Is there an easy way to scroll over cells and see the conditional formats without individually going through 'Format' and 'Conditional Formatting'...
May 12th, 2010 07:58 PM
by Bill E Go to last post
0 92
IF formula help? by daisy
Hi, can anyone help me write an IF statement? I have a list of names in Column A and want to check it against another list of names in Column D - if the...
May 12th, 2010 05:25 PM
by Ms-Exl-Learner Go to last post
5 143
Formula Help by Danny Boy
VThis formuula below needs some help. We had it working, but want to add in one piece. If "No Show to MOP" is added on Column T, we want Column U to also say...
May 12th, 2010 04:55 PM
by Danny Boy Go to last post
5 91
Worksheet Function required by Hammer
If I have the following data available based on fuel prices what formula would I require if I wished to calculate the correct fuel surcharge based on the...
May 12th, 2010 04:04 PM
by Billy Liddel Go to last post
2 91
VLOOKUP by Lbengston
Vlookup appears to resolve per the funcion arguements display but does not return value to the cell on the worksheet. =VLOOKUP(A2,MAP,3) MAP is a named range...
May 12th, 2010 03:51 PM
by Jacob Skaria Go to last post
1 107
Shading in cells is not printing....HELP! by aquams
Shading is applied and showing on screen...have marked print gridlines...still can't get shading to print in spreadsheet.
May 12th, 2010 03:21 PM
by Gord Dibben Go to last post
1 83
If date matches and formula hasn't already been calculated previou by LON205
So on one tab I have my colleagues enter certain values for that day and on another tab (a month overview and a year overview) it automatically copies the...
May 12th, 2010 03:10 PM
by LON205 Go to last post
0 62
May 12th, 2010 03:08 PM
by k15y8 Go to last post
0 81
How to calculate diffrence in dates in days and Hours by MsLearner
Hi, I am working on data sheet and having to columns like Must be Solve Date and Actual Solve date i want to find diffrence between these 2 in days:hrs:mints...
May 12th, 2010 02:55 PM
by Jacob Skaria Go to last post
6 121
Post New Thread


Display Options
Showing threads 601 to 620 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 07:27 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.