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 Replies Views Reverse Sort Order
sum by rows in Pivot by Dinesh
Hi, see table below. Col A Col B Col C a 1 7 s 4 9 x 8 4 d 9 3
June 5th, 2010 06:12 PM
by Roger Govier[_8_] Go to last post
1 1,124
Vlookup from different sheets by Radhakant Panigrahi
hi, I have the below data...like this i have huge data in different sheets(which are named date wise) and i can not consolidate them in a single sheet as the...
May 31st, 2010 01:38 PM
by Radhakant Panigrahi Go to last post
2 1,121
Remove error notification X7/M7=0 when one or both cell values are by chipmac1
How to remove error notification when X7/M7=0 when one or both cell values are 0
June 5th, 2010 10:47 PM
by David Biddulph Go to last post
3 1,117
Excel Time Sheet - Rounding To Quarter Hours by C A
I've got a daily time-tracking spreadsheet. The formula in A4 is: =(A2A1)+A2-A1+(A3B2)+A3-B2 (A1 = Start Time, A2 = Lunch Begin, B2 = Lunch End, A3 = End...
October 18th, 2005 07:21 PM
by C A Go to last post
2 1,115
Top 10 in pivot - show rest as other or similar by Kenneth Andersen
Hi I need to create a pivot table .... it could be revenue per. country. Let us assume that there are 30 countries. I only want to display top 10. I can find...
May 5th, 2010 07:03 PM
by Herbert Seidenberg Go to last post
3 1,112
Pivot range update on mulitple tables by aablank
I am using the same range for a number of pivot tables. If I add to the data, is there a way to update all of the tables at once? Right now I need to update...
September 15th, 2003 04:12 PM
by aablank Go to last post
0 1,110
MEDIANIF by rwtrader
Was this function removed from 2007 or do I just need to download an add-in?
June 4th, 2010 02:36 PM
by Bernard Liengme Go to last post
1 1,110
convert kilos to STONES and pounds by kls
Hi, i posted earlier asking for conversion to pounds. i meant to ask for a conversion form kilos to stones and pounds (i.e 15 kilos = 15 stone 2 pounds NOT...
May 26th, 2004 04:03 PM
by Go to last post
3 1,107
Cannot open large excel file by Niall Caslin
I have a large excel (Excel 97) file on an NT4 server. When I try to open the file (across the network) on my computer - XP pro with office2000 premium edition...
October 29th, 2003 06:24 PM
by Ken Wright Go to last post
3 1,107
print a blank customized schedule by Sandi W.
when I try to print a blank worksheet I have customized in order to input by hand (pencil), it will only print the headings I have typed in and not the...
September 7th, 2007 05:12 PM
by Caroline Go to last post
1 1,100
Can I transpose data from rows to cols with a formula not pivot ta by BrainDead
Hi All I have data listed in rows that I want to display in columns which will then be used in another program and I can't use a pivot table. ...
June 3rd, 2010 10:09 PM
by Herbert Seidenberg Go to last post
1 1,097
sumif function by Dee
I am trying to use sumif function to add up a range in excel using color as "CRITERIA". Is this possible? or is there another way to go about it? Thanks.
September 15th, 2003 01:24 PM
by JMay Go to last post
5 1,096
Pulling data from 1 sheet to another by Dave1155
I am working with several large excel sheets(stats, employees etc.). I am trying to tie all 4 of these sheets into 1 sheet that will pull data from the main...
January 12th, 2005 06:55 PM
by jcaggianiello Go to last post
1 1,095
Multiple Subtotals in Excel Macro by Ronnie
I have applied the registry patch described in http://support.microsoft.com/kb/831824/ but it does not seem to notice this if the subtotaling is done inside a...
June 2nd, 2010 11:13 PM
by Ronnie Go to last post
0 1,095
Function help please. by Helios150
I am a teacher and have an excel spreadsheet (2003) with student's marks in various columns. Each column represents a quiz/exam/OP or assignment and they are...
June 3rd, 2010 05:09 PM
by Pete_UK Go to last post
1 1,092
"Average If Not Blank" Formula by CindyA
I have 10 columns and 5 rows of cells. All cells do not contain a number and the cells which DO contain numbers are sometimes 1, 2, or 3 digits. I need to...
(Multi-page thread 1 2)
May 4th, 2004 06:44 PM
by CindyA Go to last post
11 1,089
Excel 2003 swedish renames macro name by Anton
When I open a worksheet, created in a english version of=20 Excel, which have a button attached to the=20 macro "auto_open" The swedish version of Excel...
December 16th, 2003 10:06 PM
by Anton Go to last post
0 1,083
CUMIPMT with balloon payment by Paul
Hi, I want to use CUMPRINC and CUMIPMT in an amortization for a loan that includes a balloon payment. CUMPRINC handles this perfectly when I subtract the...
March 10th, 2004 01:07 PM
by Norman Harker Go to last post
5 1,080
Do you have what it takes... by Frank Kabel
Hi see your response in Excel.misc (for on possible solution). Please don't multipost as this create additional efforts for all who responds two your...
February 22nd, 2004 09:30 PM
by Norman Harker Go to last post
1 1,080
Sum of named ranges conditional to date? by SleazyBreezy
Hi all, Say I have a spreadsheet listed as follows: A1 = 03/31/05 A2 = $5.00 B1 = 03/31/05 B2 = $10.00
(Multi-page thread 1 2 3)
June 24th, 2009 10:46 AM
by Nigel P[_2_] Go to last post
25 1,079
Post New Thread


Display Options
Showing threads 141 to 160 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 08:36 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.