Worksheet Functions - Page 398

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.

Thread / Thread Starter	Last Post	Replies	Views
Updated Formula question by TLC Here is an update to my question posted last week: I have a spreadsheet with close to 700 lines of information on it. The current format of the spreadsheet... ( 1 2)	August 25th, 2009 05:41 PM by Pete_UK	10	194
Row Height-expand if text wraps in a cell by Selah West Anyone with any ideas on this??? "Selah West" wrote in message ... Yikes,...	August 25th, 2009 04:43 PM by Gord Dibben	1	170
Allocated amount rounded to nearest .25 without exceeding total by sheri I'd like to be able to allocate an amount to the nearest .25 without exceeding the total being allocated. How do I do this? I'm working with hours and...	August 25th, 2009 04:40 PM by Pete_UK	6	159
Return a Value between dates based on another Value by casey Sample data: ColA ColB ColC Row1 22 1/16/2009 55 Row2 23 1/18/2009 17 Row3 22 1/20/2009...	August 25th, 2009 04:38 PM by T. Valko	3	113
#NAME? Error by mp I have a spreadsheet that I sent to a collegeau who is having difficulty with one of the formulas. The formula is returning the #NAME? error in the cell. ...	August 25th, 2009 04:05 PM by T. Valko	3	160
sum across range of sheets for a cost code by monkeydoom I'm trying to create a summary sheet at the end of a workbook that will automatically total the amount spent from a specific cost code. My first sheet is...	August 25th, 2009 03:29 PM by Don Guillett	1	119
Help with formulas automatically updating by Bobbo I have the following in a cell. {=SUM(('Evaluation Form'!F7:F7="Technical")*('Evaluation Form'!K7:K7="Reject"))}. The problem is when I enter information on...	August 25th, 2009 03:25 PM by Gary''s Student	1	102
what function to use by [email protected] Hi I'm creating a spreadsheet with percentages in one column and in the next column i need to a specific word according the value of the percentage. For...	August 25th, 2009 03:14 PM by Sean Timmons	4	121
How do I get cell="complete" to move user to date cell? by Anne Marie[_4_] Hi I have a spreadsheet and I need to create a rule that pushes the user into a cell when the previous cell they completed has the value "complete". Any...	August 25th, 2009 02:59 PM by Gary''s Student	1	102
Use vlookup to bring back data from second occurrence of the value by TinkieO I have a list of people in an excel spreadsheet (column 1). In column 2 is the name of the person who introduced the person in column 1 to the list (the...	August 25th, 2009 01:48 PM by Jacob Skaria	1	99
Database Lookup by Modawg Hi, I am trying to pull information from an array that contain these information. I need to be able to pull the information if the status is 'OPEN' along...	August 25th, 2009 01:24 PM by Modawg	2	117
excel IF formula by shib I AM WORKING IN AN EXCEL SPREAD SHEET WHICH CONSISTS OF TWO COLUMNS. ONE IS DEDUCTEE NAME AND ANOTHER IS PAN NO. OF THE PARTICULAR DEDUCTEE. I WANT TO PUT A...	August 25th, 2009 11:44 AM by Mike H	3	95
conditional formatting by Mary Lou i have a vlookup formula as follows: =IF(ISNA(VLOOKUP($A56,'2006 Top 40'!$A$8:$B$470,2,FALSE)),IF(ISERROR(VLOOKUP($A56,'2006 All...	August 25th, 2009 09:29 AM by Pete_UK	6	110
How do I combine ISNA and IF functions by ottodesque I am trying to write a formula which will return a value of blank if the contents of cell All Audit Compilation 1'!K3584 are NA or P and a value of 1 if not...	August 25th, 2009 09:01 AM by karenk	8	100
Using IF statements in conjunction with other function by meggie Hi, I am having trouble figuring out the best way to enter into a cell a maximum and minimum weight. I want the statement to contain the follow...	August 25th, 2009 08:37 AM by Jacob Skaria	1	115
Countif and sumif combination problem by tipoo Hi, I have two sheets in same workbook and they appear as follows: Sheet1 Sheet2 Column A Column B Column A Column B Column C (PO#) ...	August 25th, 2009 07:13 AM by tipoo	2	138
Paste values all cells in a region which refers to out of region by Vijay Hi, Suppose I have a region N100 to Y200, now I would like to paste values all the cells in the region which refers to the cell out of this region. The...	August 25th, 2009 06:03 AM by Vijay	0	108
Paste Special Menu by chanse44 When I click on the paste special menu like always it now brings up the hyperlink menu (paste bitmap, etc.) rather than the paste special menu of (all,...	August 25th, 2009 04:47 AM by Sheeloo	1	104
Auto go to beginning of next row after "n"th cell is populated?? by Dan[_36_] I am scanning 4 barcodes to 4 cells then I need to drop to the beginning of the next row to scan 4 more, ect. ect., is there a formula for doing this or is it...	August 25th, 2009 03:53 AM by JLatham	1	118
Time and the Max Function by Jules I have a large data set, column A has many dates (there can be many of the same dates), B has pt out time, C has room number (1-6). A Date pt out ... ( 1 2)	August 25th, 2009 02:24 AM by T. Valko	15	286

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed