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
Some text won't print from my worksheet by Carolyn
I am trying to print a worksheet but some of the text is not printing.
January 8th, 2008 07:39 PM
by Richard O. Neville Go to last post
1 107
Where are the add-ins by Sandy
Hello I have numerous add-ins installed on my computer. After being forced to "upgrade" to MSO '07, I cannot get som of the add-ins to load. They are all...
January 8th, 2008 07:23 PM
by Tyro[_2_] Go to last post
2 116
How do I change a file displayed in thousands to millions? by DW
I have a large data set that is currently displayed in thousands (ex. 2115.005), how do I change to display in millions (ex. 2,115,005)?
January 8th, 2008 07:06 PM
by CLR Go to last post
3 110
ODBC AfterRefresh Event and Shared Workbook by Paul
Hi Everyone, I hope someone is able to provide some input. We have a ODBC Query and is working and refreshing well via Get External Data. Now we are...
January 8th, 2008 06:34 PM
by Paul Go to last post
0 128
Using INDEX and it Returns a #N/A by Crazyhorse
I am using the Function INDEX and MATCH. It works. It does not work well when you want to add up the results but the result returns a #N/A. I would like to...
January 8th, 2008 06:25 PM
by Pete_UK Go to last post
2 98
Lock cell formats (conditional format) by Saintsman
Is it possible to lock a cells format so that you can only ever paste values into that cell?
January 8th, 2008 06:12 PM
by ryguy7272 Go to last post
1 95
Pivot Table Source by ryguy7272
Without right-clicking on a Pivot Table, then clicking Pivot Table Wizard Back, and seeing the reference to the data in the Pivot Table, is there another...
January 8th, 2008 05:12 PM
by Ron Coderre Go to last post
3 113
Percentage function by Rachel Bixby
I am trying to create a document that if you enter a number into a certain cell the same cell will auto-populate with what 4% is of the # you...
January 8th, 2008 04:41 PM
by Tyro[_2_] Go to last post
6 124
Excel 2007 Vlookup Using New Table Syntax by [email protected]
Excel 2007, SP1 on Vista I turned a rectangular region (with column headings) into a Table (for ease of adding new rows, etc) in a workbook - it's Table15 in...
January 8th, 2008 04:39 PM
by [email protected] Go to last post
2 195
First working day of the month by Hedgie
I need a formula to calculate the first working day of the month. At present I am...
January 8th, 2008 04:35 PM
by Ron Coderre Go to last post
2 86
Macro to change time format.... by neilcarden[_9_]
Hi, please see attached.... I need a macro to put the times into 'hh:mm' format. At the minute some are 'h:mm' and they are all in text format. Is there a...
January 8th, 2008 03:53 PM
by Bernie Deitrick Go to last post
1 111
Can function be applied to range in sumif prior to criteria check? by Cheese_whiz
Hi all, I have a range of dates I'm using for the first argument in a sumif function. I need to convert those dates to a single month number (one for each...
January 8th, 2008 03:49 PM
by Cheese_whiz Go to last post
4 109
Copying Worksheets by Neil169
Hi. I have a user who has a Excel Spreadsheet with numerous Worksheets within. It will not allow him to copy worksheets from this spreadsheet to a new...
January 8th, 2008 03:34 PM
by ryguy7272 Go to last post
1 122
Auto Capital Letter in a cell by Montu
I have designed my worksheet by using format "Merge Cell" like A B C D E F G H I J K 1 PAN NO....
January 8th, 2008 03:12 PM
by Bernie Deitrick Go to last post
3 107
Obtain row number of active cell by Jive
Hi i am having a problem with the following section of code within the larger peice below it. DBaseRow = ActiveRow Cells(DBaseRow, 5) = TDMCAD The...
January 8th, 2008 02:06 PM
by papou[_4_] Go to last post
4 145
SUMIF by Cooz
Hi everyone, Someone wrote this function in a workbook that I am asked to describe: SUMIF($K94:$R94;"";$K$9:$R$9) And it actually yields 2! I can understand...
January 8th, 2008 01:58 PM
by Cooz Go to last post
4 97
Tables in Excel Spreadsheets by Jamesn Waters
Using Excel 2003 is it possible for a table to be updated by the automatic entering of a new column, each time data on another excel spreadsheet is...
January 8th, 2008 12:04 PM
by Jamesn Waters Go to last post
2 104
Calculating quarterly investment returns---XIRR or another function?? by Carl LaFong
I am trying to compare the rates of return on an investment account to other benchmarks, such as the SP 500 or certain Vanguard and Fidelity mutual funds. I...
(Multi-page thread 1 2)
January 8th, 2008 11:59 AM
by joeu2004 Go to last post
13 204
Making Cells Mandatory and Running Checks by Bob Effendi
To the Masters of Excel. I really need your help. I'm trying to make a field (a cell) a mandatory field in an Excel spreadsheet. Leaving the field empty...
January 8th, 2008 10:14 AM
by Bob Effendi[_2_] Go to last post
3 109
View Values Formula is using? by Richhall[_2_]
Hi I have a formula: =SUM(IF('Jan 08'!$B:$B="Day",IF('Jan 08'!$E:$E=A3,'Jan 08'!F:F,0),0)) and this is returning me a value of 0 when it should be 2. Is...
January 8th, 2008 08:53 AM
by Richhall[_2_] Go to last post
9 90
Post New Thread


Display Options
Showing threads 30001 to 30020 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 02:07 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.