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 : General Discussion Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Replies Views Reverse Sort Order
Pagewise total by Devaraj
Dear Sir, How do calculate page wise subtotal, or total in every page ---------------- This post is a suggestion for Microsoft, and Microsoft...
December 5th, 2009 09:45 AM
by nikesh Go to last post
4 147
Display Missing invoice numbers from a sequence. by lrxc
Can anyone tell me how to create a formula that will take a column of invoices (just a numerical value like 108007) and display back the missing numbers...
November 2nd, 2009 11:12 PM
by Max Go to last post
2 147
Split cell based on UPPERCASE text by Bentam3
I'm trying to split some address data based on the suburb being in UPPERCASE. Here's some sample data: Level 21, 80 Collins Street, MELBOURNE Level 2, East...
November 5th, 2009 01:44 AM
by JBeaucaire[_133_] Go to last post
1 147
Pivot table cutting information of a part of the information by ASR
I have an exile file were one of the columns is a write up that needs to be filled up by the users..This can sometimes go lebgthy upto say 9 to 10 lines...I...
November 5th, 2009 03:09 PM
by Dave Peterson Go to last post
1 147
Microsoft Ofice Web 24 Hr Time Loss by Murry
Problem: Passing Time from Web Componet to Excel looses 24 hours The C:\Program Files\Common Files\Microsoft Shared\Web Components\11\OWC11.DLL which is a...
November 6th, 2009 01:04 AM
by Murry Go to last post
0 147
Paste Link from Embeded Exel by MJS
Hi, I have created an excel spreadsheet on slide 2 of a powepoint presentation using 'Insert-Object-Microsoft Excel Worksheet'. What i hope to do is copy...
November 6th, 2009 04:05 PM
by MJS Go to last post
0 147
Macro error opening text file by Jim C
I built the following macro on Excel 2003 SP2, It ran on 2 other network computers running Excel 2000 until just recently, one computer was replaced and the...
November 6th, 2009 05:05 PM
by Jim C Go to last post
0 147
Combo Box Showing Date Selections by TiredAlison
Hi I have a spreadsheet with a combo box setup. I want it to display in the pull down dates in the format dd/mm/yy from todays date - 5 days to todays date +...
November 23rd, 2009 07:47 AM
by TiredAlison Go to last post
4 147
Incorrect result for simple SUM formula by VivienW
Hello, Does anyone know why Excel sometimes give an incorrect result when adding the contents of cells? It may only be 1p out but even if I increase the...
November 20th, 2009 04:46 PM
by Joe User[_2_] Go to last post
9 147
Index and Match results vary in Excel 2003 and 2007 by Krish
I have 2 Pivot Tables in a worksheet. They both have Date, Total amount. One Pivot table is producing deposit info from the ERP data while the other one is...
October 28th, 2009 01:32 AM
by Krish Go to last post
0 147
Excel 2007 change colour when "find" function is used by sanmos
Hi, We recently updated to excel 2007. When I use the find function, I cannot see the cell that the system is telling me that it has found what I am looking...
October 22nd, 2009 05:04 AM
by JLatham Go to last post
1 147
Macro to Return Row, then move over and select up to by Karin
Hi, (Excel 2003) I'm writing a macro to format a report. I want to Find "Grand Total" and then move over to column K, highlight up to K3 (absolute) and...
October 9th, 2009 09:34 PM
by Karin Go to last post
8 147
Text by nc
a & a 24/03/09 a & a 24-26/09/09 a & a 3/06/09 a & a I have a column of the above similar text. I would like help to write formula to show text without the...
October 11th, 2009 09:55 AM
by nc Go to last post
4 147
Help with a formula by Trev
I need a formula in sheet 2 that counts if column C sheet 1 = S, and column S sheet 1 can equal either N* or U*and column A sheet 1 does not equal CBH, APH,...
October 10th, 2009 10:28 PM
by Trev Go to last post
2 147
Autosort in Excel by Riley Snyder
Hi all, I have a workbook with several sheets that link to one master sheet. The master sheet (sheet 8) is the one I enter data into and it is set up to...
October 12th, 2009 02:05 PM
by Michael R Go to last post
2 147
i "saved" instead of "saved as". I need old file back by KD
Help!! I made changes to an Excel file, and saved. I meant to save as a new file, so i could keep old file. Is there any way to retrieve the original...
October 13th, 2009 08:32 AM
by David Biddulph Go to last post
5 147
Help.... on mail label by yeeguan
Can someone show me how to make label where my data in excel look like NO NAME ID PHONE1 PHONE2 EMAIL ADDRESS1 ADDRESS2 ADDRESS3 1. xxxx ...
October 15th, 2009 05:38 PM
by Ron@Buy Go to last post
1 147
How can I increase a cell reference in VLOOKUP by 11 when copying? by John R.
Here is the formula: =VLOOKUP('Roll Up View'!A4,'Roll Up View'!$A:$S,2,FALSE). I want to copy the formula down the column but increase the cell reference in...
October 19th, 2009 09:48 PM
by John R.[_2_] Go to last post
2 147
Hlookup and sum formula by SixBowls
I have a table with the months in row 6. Revenue is in row 9 and costs are in rows 10 through 38. Cell c6 is 1 for January and cell c9 is January revenue. ...
October 23rd, 2009 03:19 PM
by Max Go to last post
3 147
how to calculate interest on payments by Bob L
I need a formula/spreadsheet that will calculate 18% interest on delinquent quarterly payments. Example: Tenant owes $100 every quarter but has not made a...
December 5th, 2009 03:53 AM
by Joe User[_2_] Go to last post
2 147
Post New Thread


Display Options
Showing threads 20001 to 20020 of 139764
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 06:06 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.