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
Ecxel Subtotal by esutton@wilberforce edu
I have used a spreadsheet from the payroll office and compiled subtotal for each. example: pp1 50 pp2 50 pp3 40 total 140 My problem is that the total...
September 28th, 2008 07:46 AM
by ShaneDevenshire Go to last post
1 129
Problem with SUMPRODUCT by stevesoul
I have used the SUMPRODUCT to add up how many times each month an project is updated. The formula works from months Feb through Dec, although for Jan, it...
September 28th, 2008 03:20 AM
by Peo Sjoblom Go to last post
2 111
Sorting data does not expand to other sheets by ahkasiv
Hi. I am looking for a way to maintain data on multiple sheets if I sort. For example: Sheet 1 A B 1 k ...
September 28th, 2008 03:18 AM
by Ashish Mathur[_2_] Go to last post
3 129
formula by Roger
I need to create in my grade book a formula that assigns different value to the number in the cell. example homework column average for a student is 90 but...
September 28th, 2008 01:31 AM
by Roger Go to last post
4 133
Rounding up to a multiple of 12 by pettyc
I want to add several columns, subtract several columns and if the result is gt zero I want to add 1 to it, divide by 2 and then round up to a multiple of...
September 28th, 2008 01:21 AM
by ShaneDevenshire Go to last post
2 115
How to start a makro by johnny
When I delete a name in a cell I have made a makro that is doing some "cleening up". How can I make this makro start when the name is deleted? Or do I really...
September 27th, 2008 11:25 PM
by johnny Go to last post
5 123
Function within a cell that has a number by Té
I have a number in a1 which is 500. Is there a way I can leave the 500 in place, along with add a formula to that cell as well. I want to add a1+b1, but I...
(Multi-page thread 1 2)
September 27th, 2008 06:47 PM
by Gord Dibben Go to last post
12 201
How do I set Auto Print Area? by Need Help on axis problem in a chart[_2_]
Hi, I would like to set auto print area to an worksheet, that changes(# of rows) for different project. I have fixed width (number of columns), but length...
September 27th, 2008 05:46 PM
by Gord Dibben Go to last post
7 145
Controlling which parameteres change in fill functions by koahzvika
If I have a function I want to fill down a column, and I want certain parameters to change and others to stay the same, how do I control which values go +1...
September 27th, 2008 05:35 PM
by Gord Dibben Go to last post
2 114
Capping number of attendees that increase monthly by E
Hi, I am trying to show an increase of 3% monthly in program attendees, but want to cap the number at 60 and create a waiting list. How do I write that...
September 27th, 2008 05:16 PM
by Mike H Go to last post
8 125
Summarize on 2 variables by Steve M[_4_]
Hoping someone can help. I have a spreadsheet containing students from 4 schools, thru cell 2159, sorted by Student-ID (6 digit number) and last name. I...
September 27th, 2008 05:03 PM
by Steve M[_4_] Go to last post
4 100
Using Vlookup and IF statements to check for blank cells by Koomba
I neglected to include my formula in the 1st message. Sorry. Here it is: =VLOOKUP(B4,'Price List'!$A$3:$B$13,2,FALSE) -- Thanks from Salt Spring
September 27th, 2008 03:54 PM
by franciz Go to last post
4 133
find and move values 0 by Sojo
I am writing a macro to automate several processes. I have the following table where column A has positive and negative values and column B is blank. I...
September 27th, 2008 03:02 PM
by IanC Go to last post
6 123
Limit returned value by Patrick C. Simonds
In cell A4 is a 4 digit number in cell A1 I want only the last number
September 27th, 2008 02:29 PM
by NoodNutt Go to last post
5 135
Running Totals by Pickup
Hi, I'm working through a college project using Excel. One of the examples is to generate a random event (toss of a coin) and then record the number of...
September 27th, 2008 01:11 PM
by Pickup Go to last post
5 149
Formula Question by Ben
I work in a school and I need to tally the number of tickets grade levels earn. What I am stuck on is, I want to tally the tickets earned, but when they hit...
September 27th, 2008 12:58 PM
by David Biddulph Go to last post
2 111
VLOOKUP Range by apb000
Is there a way to have excel look up data that falls BETWEEN two numbers, i.e. in a range, and return a specified character string? For example, "If (value)...
September 27th, 2008 06:39 AM
by ShaneDevenshire Go to last post
2 134
Sum only certain worksheets in Excel by JLS
Hello- I have a file with 8 worksheets, each representing a different location. I need to create a Total worksheet that will allow the user to select how...
September 27th, 2008 05:52 AM
by T. Valko Go to last post
4 221
Coutnif by Matt
I need help with a countif statement. I have information like the following: A B X 1 Y 1 X 2 X 0 I need to count how many times X in...
September 27th, 2008 05:46 AM
by ShaneDevenshire Go to last post
4 115
Finding min date value with hidden zeros with vlookup by ML
Hi, I'm trying to find the earliest date from 4 cells (B:E) that have time format mm/dd/yyyy. Some or all of the 4 cells might be empty (hidden zeros). First...
September 27th, 2008 05:14 AM
by ShaneDevenshire Go to last post
4 131
Post New Thread


Display Options
Showing threads 19801 to 19820 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 09:38 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.