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
How do I average every 3rd cell in a column of a spreadsheet? by Sean
I have a spreadsheet with headers of the days of the week. Below that is the date, then location 1's sales then below that is location 2's sales. It is a...
May 11th, 2010 03:35 PM
by Steve Dunn Go to last post
3 188
How to Auto Reference Worksheet Tab ID's in Formulas? by Scott - Key West[_2_]
In my workbook (2003) used to track disaster costs, I have some 60 different worksheets. On the Summary page, the cells pull data from the individual...
May 11th, 2010 03:34 PM
by Gord Dibben Go to last post
9 119
Average Length of Stay by Georgeb123
Column A is Funding Source: "A" or "T" Column B is Days of Stay calculated from check-out date minus check-in date. How to calculate Column C as Average Length...
May 11th, 2010 02:24 PM
by Ashish Mathur[_2_] Go to last post
2 164
sheet protection with links by sthart
Dear all, I have a sheet that has links to another file. I would like to protect the cells with the links so that the links cannot be deleted (i.e. the...
May 11th, 2010 02:10 PM
by Eduardo Go to last post
1 124
horizontal scroll bar by Brian Wehrs
I have a document open in xcel and I cannot figure out how to get the horizontal scroll bar to be bigger. I mean I have zoomed out to see if I have anything...
May 11th, 2010 01:09 PM
by Dave Peterson[_2_] Go to last post
1 162
Where does Max keep his files now ? by darkblue
I used to go to save project or something like that to check his sample files. But I have lost the address now. Does anybody know where it is ?
May 11th, 2010 11:31 AM
by darkblue Go to last post
4 154
Match 2 Columns, Return 3rd, Differing Match Types by Matt.Russett
Hello, I have 3 columns of data in my main table. For example: Blue / 2 / $5 Blue / 4 / $10 Blue / 6 / $15 Green / 3 / $4 Green / 10 / $8 Red / 1 / $1
May 11th, 2010 10:45 AM
by Steve Dunn Go to last post
3 149
Adding to a SUMPRODUCT formula by Mark D
Afternoon all I have the below...
May 11th, 2010 09:10 AM
by Steve Dunn Go to last post
6 155
Need suggestions on layout to report/pivot by Nadine
Does anyone have any thoughts on how to arrange this in Excel 2003: I have a group of invoice numbers. I have columns of inforamtion relating to the invoice:...
May 11th, 2010 08:37 AM
by Roger Govier[_8_] Go to last post
3 131
Pivot Table from 2 worksheets by Nadine
I thought I read somewhere that you can create one pivot table from two worksheets. Does anyone know how to do this in Excel 2003? I need to create one and...
May 11th, 2010 08:13 AM
by Roger Govier[_8_] Go to last post
1 199
May 11th, 2010 08:07 AM
by Roger Govier[_8_] Go to last post
1 105
Excel auto accumulation formulas by Arix
Hi hello, I need a formula for auto accumulation formula like example: John need to give me USD50 everyday for one month, so if he never paid the money i...
May 11th, 2010 07:41 AM
by Jacob Skaria Go to last post
1 102
Automatic sequential numbering where a value changes by suek
Hello! I have items coming to me from various areas, which get recorded in a spreadsheet and given the next number in a list. A manager reviews the item,...
May 11th, 2010 07:39 AM
by BSc Chem Eng Rick Go to last post
4 190
Microsoft Responds to the Evolution of Online Communities by [email protected]
Date 5/4/2010 Starting in early summer 2010, Microsoft will begin progressively closing down the Microsoft public newsgroups to enrich conversations in the...
(Multi-page thread 1 2 3)
May 11th, 2010 03:40 AM
by GS Go to last post
22 1,043
lookup to see if multiple values exist by Yegod
Hi, I am faced with this problem. I have data as follows: Col1 Col2 Col3 S1 H1 Value 1 S1 H2 Value 2 S2 H1 Value 3 S2 H2 ...
May 11th, 2010 01:58 AM
by Yegod Go to last post
2 169
Ranking from one sheet to another by casdaq
I'm trying to rank a particular result from one sheet to a range of results from another sheet but it is giving me an error when I do so. Here is the formula...
May 11th, 2010 12:25 AM
by casdaq Go to last post
0 79
Data Validation - Conditional List by Scott
I have two drop down windows and I want the list of values available in drop down two to be dependent on the selection from the first drop down. Example:...
May 10th, 2010 10:03 PM
by Chip Pearson Go to last post
3 162
How to make "X" have the value of 1? by lettbonn
In an excel spreadsheet, how can I make "x" have the value of 1 so the column is totaled automatically?
May 10th, 2010 08:40 PM
by Brad Go to last post
1 99
where text wraps in a cell, how can the row height be auto set? by Stephen Sandor
I have merged a number of cells and included text that wraps in the cell. Is it possible to set the cell so that the height is automatically adjusted to the...
(Multi-page thread 1 2 3)
May 10th, 2010 07:57 PM
by Angie Go to last post
26 639
Math help by Nadine
I have a worksheet with columns A-P. A=Hrs B=Rate C=Amount Billed (A*B) D=Hrs Approved E=Amt Approved (D*B) F=Hrs Approved G=Amt Approved (F*B) H=Sum Approved...
May 10th, 2010 07:45 PM
by Nadine Go to last post
3 105
Post New Thread


Display Options
Showing threads 641 to 660 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 04:03 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.