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
Array Function - cell to remain blank by mare
I am a novice on Excel, however, I don't get easy projects. I have a spreadsheet where D6:D15 have values. In cell D17 is the Total, which is an average of...
November 11th, 2003 09:56 PM
by Jon Barchenger[MS] Go to last post
1 189
Dynamic Range by Brian
I am trying to create a macro and am stuck trying to figure out how to determine my last column. In cell E3 I am using the formula =COUNTIF(E4:??,0). Can I...
November 11th, 2003 09:53 PM
by Aladin Akyurek Go to last post
5 417
Problem with INDEX function to return top 3 objects and sizes from a list by Roger
SHEET1: Hundreds of entries in no particular order. Note: there are other columns between these fields. This is only an...
November 11th, 2003 09:43 PM
by Aladin Akyurek Go to last post
1 513
Linking workbooks by Fawn
I have 4 workbooks with approximately 12 sheets with the information rolling up into one YTD sheet. What I want to do is to have all 4 of the YTD sheets on a...
November 11th, 2003 09:00 PM
by Harlan Grove Go to last post
1 349
manual calculation doc by Sheri
A monthly excel report sent from our corporate office to our remote location is saved by the sender in Manual calculation. With no other excel documents open,...
November 11th, 2003 07:05 PM
by Gord Dibben Go to last post
1 364
excel automatic add-ing by luis
the automatic add-ing stop working. i uninstalled the program and reinstalled again, but did not fix the problem. I used tthe fix and repair option but did...
November 11th, 2003 07:00 PM
by Gord Dibben Go to last post
1 288
Pivot Table and Countif Function by Amiram
ID B Month A1 Pass Feb A1 Pass Feb A1 Pass Feb A3 Fail Feb A4 Fail Feb A4 Pass Feb A4 Fail Feb A4 Pass Feb A1 Pass Jan
November 11th, 2003 03:29 PM
by Amiram Go to last post
0 311
Display ASP Results in DIFFERENT worksheets by Mahesh
Hi, I want to display ASP query results in DIFFERENT worksheets, can anybody help me on this Thanks in advance Mahesh
November 11th, 2003 02:58 PM
by Mahesh Go to last post
0 217
Macro / close a workbook without saving by carl
i am trying to add some code that will close an open workbook without saving the changes to it. thank you for you help.
November 11th, 2003 01:52 PM
by Ture Magnusson Go to last post
1 370
Coloring Subtotals by Scott V
How can i automatically color subtotals? Keep in mind that the subtotal rows will constantly be changing. Scott
November 11th, 2003 04:52 AM
by Debra Dalgleish Go to last post
1 117
negative hour/min values by emily
Is there a way in Excel I can enter hour/minute values as negative and therefore perform calculations on these figures? I am developing a timesheet which...
November 11th, 2003 04:44 AM
by emily Go to last post
4 348
"dated if" statement by todd
IF(AND(DATEDIF(Q14,V$7,"Y")-2,$C14=$C$1),($AA$2*8/24)* ($E14/40) Hi, I am working on a set of dated if statement that I have copied from an old worksheet. ...
November 11th, 2003 02:50 AM
by WShelton Go to last post
3 166
Highest and lowest value from column by DrB
I have a column of numbers including blanks where I want to put into another cell the highest and into another cell the lowest (ignoring the blank or a zero...
November 11th, 2003 02:39 AM
by DrB Go to last post
2 149
Date format in cell by Raymond Reedy
I set the format for the cell to be a date in the form 11/22 (no year) = and=20 enter 11/15. Excel changes it to 11/15/2003. I do not want the year....
November 11th, 2003 12:52 AM
by Peo Sjoblom Go to last post
1 156
Excel/Percentage by David
I have recently upgraded excel 97 to 2002 and have noticed that when i formated cells for percentage it multiplies what i put in by 100 to create the...
November 11th, 2003 12:21 AM
by Vasant Nanavati Go to last post
1 92
Unpivot by Rich C
Is there a way to take a pivot table and 'unpivot' it back to a normal spreadsheet?
November 10th, 2003 11:55 PM
by Earl Kiosterud Go to last post
1 121
Convert seconds to mm:ss by Larry
I have a worksheet that shows avg. elapsed time in seconds as a numerical value (ex. 507.84275 is 507 seconds). I need to convert this to a mm:ss format...
November 10th, 2003 11:46 PM
by Earl Kiosterud Go to last post
2 324
user defined date/time format by Irene
Is there a way I can define a time format within Excel to include milliseconds?
November 10th, 2003 11:13 PM
by J.E. McGimpsey Go to last post
1 234
Credit Card Number Suppression by Dana
I have an existing workbook that contains a confirmation that gets faxed to customers to sign off approving credit card charges. The credit card # is typed on...
November 10th, 2003 11:01 PM
by J.E. McGimpsey Go to last post
7 585
How to convert text to numbers? by T Bennett
I am importing a pile of numbers from Access to Excel. The problem is, Access puts numbers in with the quote mark. If I copy a column then paste special -...
November 10th, 2003 10:55 PM
by J.E. McGimpsey Go to last post
1 277
Post New Thread


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