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
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
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
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
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
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
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
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
crore formatting by kaushik
I want to format a range of cell/ a entire column in crore format i.e 1,00,00,000.00 and also want to sum that entire column. I tried it with "fotmat cell"...
September 16th, 2003 03:07 PM
by J.E. McGimpsey Go to last post
1 286
Pivot table - formatting by akk
Hi Anon, That option was ticked. Despite that, the formatting changes. -----Original Message----- "akk" wrote in...
September 16th, 2003 03:35 PM
by akk Go to last post
0 459
Lookup question by FBC
I'm trying to compile a database based on info from another databse. I would like to take only the rows that contain a certain value in a cell to make the...
September 16th, 2003 03:52 PM
by Andy Brown Go to last post
1 266
Pop up function ??? by MsSwiss
I am creating an excel document that several people will use. I am using a pivot table in one of the sheets and I would like to have a pop up or a callout that...
September 16th, 2003 04:18 PM
by Andy B Go to last post
2 304
IF cell contents = ????? by HeatherM
I want to count the instances of each value in a column with various references in it(a mixture of text entries and number entries). I would normally put an IF...
September 16th, 2003 04:18 PM
by Ed Lisay Go to last post
1 622
Index & Match by Greg Malenky
excel 2000 I am having trouble finding the proper function to arrive at the following answer for this table: employee store john store1 dave ...
September 16th, 2003 04:55 PM
by Greg Malenky Go to last post
2 617
Newbee show cell address by Microsoft Newsgroups
I am having difficulty tranfering from C to VB. How can I assign, pss, or MsgBox the string address of a particular cell. If I use Dim cellref as...
September 16th, 2003 04:57 PM
by Harald Staff Go to last post
2 385
If value is greater than, then.... by Robert
Hi, I am trying to create a formula. Column A has a number Column B is a sum of A*1,2 only if A is over 100 otherwise B=A Logic: If A1100 then B1=(A1*1,2);...
September 16th, 2003 05:00 PM
by Harald Staff Go to last post
5 283
Entering numbers by Jorr
I'm entering long numbers on an Excel 2000 spreadsheet in a cell set for number format. When I enter a long number, such as a credit card number (16 digits)...
September 16th, 2003 05:25 PM
by FBC Go to last post
1 423
Choice and effect by Gerry Kuta
From within A1 which contains the text Area 1;Area 2;Area 3; Area 4 I'd like C1 to display Area 1 if in B1 I enter 1. (Area 2 on entry of 2 in B1 etc.) From...
September 16th, 2003 06:36 PM
by J.E. McGimpsey Go to last post
1 334
Pivot table update by aablank
I have a number of pivot tables based on the same data worksheet. Right now when I add more data, I have to go to each table and update the range manually. ...
September 16th, 2003 06:46 PM
by aablank Go to last post
3 463
calculating with displayed values by Tobit
I have two cells, each displaying numbers to with 2 decimal points Cell A1 contains the number 15.333333333 (the figure the result of a calculation) Cell A2...
September 16th, 2003 06:57 PM
by King Go to last post
9 441
Excel text converted to Number or other by jonkaleb
when converting from text to number or general how do you mass update the column instead of double clicking then enter
September 16th, 2003 07:09 PM
by Ken Wright Go to last post
2 298
Post New Thread


Display Options
Showing threads 81 to 100 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:46 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.