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
Limit returned value to last digit by Patrick C. Simonds
In cell A4 is a 4 digit number in cell A1 I want only the last number
September 27th, 2008 05:02 AM
by ShaneDevenshire Go to last post
3 130
List Functions by Brooklyn
Is there anyway that the list function can be used withing Excel other than in a spreadsheet ?
September 27th, 2008 04:57 AM
by ShaneDevenshire Go to last post
2 133
Equation Values by RED
I am trying to calculate the days between two dates. I have used both equations =a1-b1 and =days360(a1,b2) and both have worked in the first cell. I need...
September 27th, 2008 04:40 AM
by RED Go to last post
4 140
Automating transposition exercise by Bob Matthews[_2_]
Hi there I have a workbook with many worksheets - all set out in an identical manner. I wish to combine the data in all the identical worksheets into one new...
September 27th, 2008 04:19 AM
by Bob Matthews[_2_] Go to last post
2 147
checking for blank cells when using vlookup by Koomba
I am jusing the following formula in my sales order form and want to avoid the error message: #N/A caused by blank cells in the remainder of the sales order....
September 27th, 2008 03:30 AM
by Dave Peterson Go to last post
1 124
Calculating MAX, MIN & AVG for each year by dc059
I have a long list of data, from which I need to calculate the Maximum, Minimum and Average values for each seperate year. The data spans many years. An...
September 27th, 2008 02:23 AM
by dc059 Go to last post
2 138
Using If to combine answers including text and numbers by Tablespider
Hi I am writing a brief questionnaire about the ages at which children are allowed to do certain things, buy cigarettes etc, and have a simple problem. If...
September 27th, 2008 12:16 AM
by Pete_UK Go to last post
3 149
Can't We Set Print Area with condition? by Need Help on axis problem in a chart[_2_]
Hi, I would like to set auto print area to an worksheet. I have fixed width (number of columns), but length (number of rows with values) changes, anywhere...
(Multi-page thread 1 2)
September 26th, 2008 11:51 PM
by Dave Peterson Go to last post
10 243
Create Registration Form by Di_W[_2_]
I work for a non-profit company in the education field. I need to create a registration form for about 100 of our field staff who are located across the US....
September 26th, 2008 10:52 PM
by Sean Timmons Go to last post
5 117
Sum last 13 cells in column by vdubluv74
I am looking for a formula that calculates the last 13 numbers in a column that are greater than 0. thanks
(Multi-page thread 1 2)
September 26th, 2008 10:34 PM
by vdubluv74 Go to last post
13 329
Adding Columns if Criteria Met by JD_Ottawa
I am using a spreadsheet with multiple colums for each period of a year and having problems adding a Year To Date summary. See Below: Period 1 Columns: ...
September 26th, 2008 10:00 PM
by IanC Go to last post
1 134
Help with INDEX by Joe Gieder
Thank you for your help with this. I have this array formula:...
September 26th, 2008 09:39 PM
by T. Valko Go to last post
1 105
EXCEL LOOKUP by Wallace
my excel matrix is set up as such: A1=BOB; A2=TIM; A3=BOB; A4=SUE; A5=JOHN; A6=BOB; B1=100; B2=101; B3=102; B4=103; B5=104; B6=105; D1=BOB; Which function...
September 26th, 2008 09:06 PM
by T. Valko Go to last post
4 111
Excel Multiple sheet updates by Liz
What is the correct function to use in my macro if I have many sheets in my workbook and I need to update them monthly. after I update them, I have the...
September 26th, 2008 08:50 PM
by Sean Timmons Go to last post
1 108
Excel VBA. Compare 2 worksheets. by u473
I need to filter to a new workbook for exceptions of potential mischarges, by comparing a Table of Actual Charges Vs a Table of Allowed Charges by Employee and...
September 26th, 2008 08:36 PM
by Bernie Deitrick Go to last post
3 135
If, if, if with & by Steve
I need the results as either a 1, 2 or 3. if the number is 200, I want a 1 If it's between 200 - 299, I want a 2, and if it's 300, I want a 3. This formula...
September 26th, 2008 07:23 PM
by Peo Sjoblom[_2_] Go to last post
6 109
Vlookup Data Split by Atif
Hi Data is split in two sheets, can I vlookup both sheet in single formula. i.e. Sheet 1 (half data) Sheet 2 (half data) Sheet 3 (vlookup) Thanks
September 26th, 2008 06:37 PM
by Sean Timmons Go to last post
3 116
New Twist on Old Question-Averages by LPS
Refresher: My Excel 2000 workbook has two sheets, the first (Evaluation Detail) contains details about course evalutions per instructor. Column A is Course...
September 26th, 2008 06:33 PM
by Pete_UK Go to last post
4 86
protection by Darrell_Sarrasin via OfficeKB.com
I have a page set up with groups any way to use them and protection at the same time I am using 2003 excel. -- Message posted via...
September 26th, 2008 06:31 PM
by Dave Peterson Go to last post
9 114
read only cell by pdaws
Is there a macro that I can wright that would make a cell read only on a form after date entry has been performed in the cell? The intent is to have the...
September 26th, 2008 06:23 PM
by pdaws Go to last post
2 114
Post New Thread


Display Options
Showing threads 19821 to 19840 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 03:53 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.