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 Reverse Sort Order Last Post Replies Views
use the current row in a list to populate a report by David Murto
I'm trying to create a workbook that uses a list to record each report. A separate worksheet (called report) would serve as the report template. Each variable...
April 13th, 2006 06:30 PM
by Ardus Petus Go to last post
1 79
Subtotaling non-contiguous cells by David N. Ballew Jr.[_2_]
I am trying to figure out the syntax for a subtotal formula that subtotals non-contiguous cells. I am using Excel 2003. If I use the Sum function as in the...
May 2nd, 2007 10:04 PM
by David N. Ballew Jr.[_2_] Go to last post
2 90
Figuring military time for total hours by David Nelms
Helping someone out with a worksheet that figures time (in military time) for use at weekend race tracks. Generally they have two days so it was easy with 2...
July 5th, 2005 05:00 PM
by Peo Sjoblom Go to last post
3 270
Unsharing a workbook in Excel 2007 by David Newton
I just shared a excel document on my server to test it out and found all the insert commands greyed out. I need to find a way to insert pictures. I then...
May 31st, 2008 12:11 AM
by David Newton Go to last post
0 106
cell color by David NL
Hello best excellers. I have a sheet for my empolyees with the days on which they should work. I want to change the color of the cell automatically to blue...
September 28th, 2005 10:15 PM
by Ray A Go to last post
2 89
daily output list of employees by David NL
Hello excellers, I seek a solution for my problem and you are the only ones who can help. I have a year-list of employees for each day ( 100 persons ). Daily...
October 7th, 2005 02:07 PM
by PY & Associates Go to last post
1 103
mround function: is there a download for Excel 2002? by David of the Orchard
A colleage has Excel2003 which contains a function "=mround". How do I get that into Excel2002?
March 6th, 2006 07:32 PM
by Chip Pearson Go to last post
2 134
How to reference a value in a cells for a row number by David Olson
Have a worksheet with specific data (calls, $, employee) in the columns and the weekly data (Week 1 Week 2 Week 3) for the specific data in the rows. Each week...
January 21st, 2006 11:37 PM
by vezerid Go to last post
2 80
Automatically print all page contents in pivot table. by David P
Hi All, Can anyone help me with writing a macro whe From a Defined Range (e.g. Sheet1! B9-B20), for each cell value, I would like a pivot table page on...
February 21st, 2005 06:57 PM
by David P Go to last post
0 97
MS Query - Alias syntax by David P
Hi All, Does anyone know what is the correct syntax to rename a field name in MS Query? I go thru the wizard and try to modify the sql. The alias or 'as'...
February 16th, 2005 10:29 AM
by Jamie Collins Go to last post
3 120
Ghost Blank Cell References by David P
Can anyone explain why there are "ghost" blank cells when a pivot table is present on a worksheet. If you have a pivot table that starts in B1 and if you...
February 4th, 2005 04:27 AM
by Dave Peterson Go to last post
1 138
April 7th, 2004 06:34 PM
by Ron de Bruin Go to last post
1 249
How can I match a calculated date to closest date from a list? by David P
I'm trying to match a calculated date to the next meeting date from a list of meeting dates. Any help greatly received Thanks David
January 22nd, 2007 01:05 PM
by RichardSchollar Go to last post
2 54
WEEKNUM function by david p
ISO standard says Jan. 3, 2005 is week 1 day 1. Excel says it is week 2 day 1.
March 13th, 2004 04:24 PM
by david p Go to last post
8 525
Using an Excel VB-made form in cell-specific conditions. by David P. A. Hunter, esq. III
Anyone know how to use a UserForm (made in the Visual Basic editor that is is accessible via Excel's ToolsMacros menu) to display an error message when a...
July 20th, 2006 03:25 AM
by Die_Another_Day Go to last post
2 80
In Excel, lists should be sorted. by David Paul
In Excel, often, I create a list (Data, List), and the data is linked to another source. I suggest that when creating the list, one has the option of sorting...
April 13th, 2005 03:01 PM
by Peo Sjoblom Go to last post
1 97
COPYING TIME FORMATED CELL TO ANOTHER by DAVID PEARSON
I HAVE FORMATED TWO COLUMNS USING THE DATE FORMAT FUNCTION. I WANT THE DATE ENTERED ("COPY FROM"),TO DISPLAY IN A DIFFERENT CELL ON THE SAME ROW IN A DIFFERENT...
October 15th, 2003 06:22 PM
by Earl Kiosterud Go to last post
1 473
nested if statements - multiple variables by David Pelizzari
I am attempting to write an if statement to check values in two columns, and return a value based on the two. column A is difference between two dates (today...
August 17th, 2009 01:38 PM
by NBVC[_164_] Go to last post
2 164
lookup mutliple values to return one value by David Pelizzari, IS Manager
I am trying to find a way to lookup more than one value in a row (vlookup) to return a value in a corresponding row. We have a list of values in column...
February 7th, 2006 02:26 AM
by Max Go to last post
1 254
March 23rd, 2006 09:30 PM
by daddylonglegs Go to last post
15 207
Post New Thread


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