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
formula by Tim
Hello All, I need help with a formula that multiplies two cells. The first numberis the actual cell, but the second number refers to a cell with a cell...
September 16th, 2003 02:59 PM
by J.E. McGimpsey Go to last post
1 332
Calculating Time by Duane Emerson
I'm trying to add & divide hours that exceed 24. Ex: I work on a particular project 5 hours a day Mon - Fri. I would like to total the hours, then divide by...
September 16th, 2003 02:56 PM
by Ron Rosenfeld Go to last post
2 357
macro question by Joe Silvers
Is there any way to create a macro in Excel that will go to a cell, wait for you to enter data and hit return, go to another cell and repeat this process. I...
September 16th, 2003 02:34 PM
by Earl Kiosterud Go to last post
1 461
Columns now numbers????? by Sandra Britcher
Why are my columns now numbered at top rather than letters. Calculations WERE easy, now it is a major undertaking to get even simple calculations. How...
September 16th, 2003 02:08 PM
by Allen Go to last post
2 515
Balanced Scorecards by Tom
I am certain if this is the right newsgroups for my questions, but maybe I'm lucky and someone can provide me some pointers. Currently I'm doing research on...
September 16th, 2003 12:44 PM
by bock Go to last post
2 485
How to Copy/Paste Only the Subtotal Rows in Excel? by GBO
I'm trying to copy and paste just the subtotals from an Excel worksheet list into another list. How do I do this without also copying/pasting the underlying...
September 16th, 2003 12:21 PM
by Anon Go to last post
1 551
help with SumIF by Radeesh
Hi I have some dates in Col i and ammount in Col j I want use SumIf to add all the amounts in a given month =SUMIF(MONTH(I4:I13),MONTH(B20),J4:J13) this is...
September 16th, 2003 12:17 PM
by Radeesh Go to last post
4 339
Subtotaling in Excel Using Different Types of Calculations by GBO
Is there a way to subtotal the details (records) in an Excel list where all of the subtotals appear on the same row, but row details (records) are subtotaled...
September 16th, 2003 12:15 PM
by Debra Dalgleish Go to last post
1 480
Rounding to nearest $ by Sarah
How do we change the EVEN function to get the actual number. Currently it is rounding down to the closest dollar figure. Example: 11.67 * 12=$140.04. Using...
September 16th, 2003 11:02 AM
by Harald Staff Go to last post
3 503
formula by Ram
while entering the formula in worksheet, there is a specific value in one cell and i want to keep the same cell address in every formula. So when i copy the...
September 16th, 2003 10:39 AM
by masim Go to last post
2 486
Excel 2002 does not recalculate existing formulas by Natasha Laughton
Excel 2002 running on Windows 2000, does not recalculate those cells that are dependent on other cells that contain changed values. 10 20 30 0 60 (formula...
September 16th, 2003 10:22 AM
by Gary Gallagher Go to last post
3 401
histograms with normal distributions by P.-S. ROSS
I am trying to make nice histograms in MS Excel, without using any plug-ins. I want a normal probability curve (having the same mean and standard deviation...
September 16th, 2003 10:14 AM
by GB Go to last post
4 577
Hyperlink Removal by Doug
Deactivate several hyperlinks at once: Type the number 1 in a blank cell, and right-click the cell. Click Copy on the shortcut menu. While pressing CTRL,...
September 16th, 2003 08:18 AM
by Dennis Go to last post
1 343
remove link by Tina
I try to remove link from edit menu, choices are only 'update now', 'Open source' and 'change source. detlet button doesn't work. Any ideas what can I...
September 16th, 2003 08:14 AM
by RagDyer Go to last post
1 339
vlookup does not always work by Pablo
Most of the time I am able successfully implement the vlookup function. However, there are so few times when everything looks good, I know there is a...
September 16th, 2003 06:45 AM
by Nishant Go to last post
4 374
Splitting cells / diagonally displaying cell data by Robb Lassu
I have a two groups of data that will have six categories. Each category will be assigned a date in columns. The difficult part is that one row needs to...
September 16th, 2003 06:34 AM
by Matt Go to last post
1 501
Visual Basics code by Simran
Hello, I created a macro and button to print out every worksheet on an excel workbook. However every time I add a new worksheet I have to re-create the...
September 16th, 2003 06:28 AM
by Cliff Myers Go to last post
2 327
vlookup Sorry if it's confusing.. by roger r
I need help with a vlookup problem. Here's the best example I can give to my problem: Sheet # 1 A B C D 1 25 vlookup(A1,E1:H1,4,0) I want to...
September 16th, 2003 05:50 AM
by Alan Beban Go to last post
2 294
formulas by Kay
I have entered the formula in sheet "A". I want to bring a total of several cells from sheet "b". The page is not adding the cells from page "b", instead it...
September 16th, 2003 05:01 AM
by Biff Go to last post
1 370
Negative Numbers by Mommio
Hi! I am a K through 8th computer teacher. (That doesn't mean I am an expert - it just means that I am able to stay one step ahead of the kids!)Today, I did...
September 16th, 2003 04:32 AM
by Dave Peterson Go to last post
1 394
Post New Thread


Display Options
Showing threads 87701 to 87720 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 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.