Worksheet Functions - Page 618

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
Excel 07/Acrobat 8.1.4 by Misty After Acrobat 8.1.4update, unable to convert Excel 07 worksheet to pdf using Acrobat 8.0 Pro. Worked well before, now just gets stuck trying. Tried...	April 9th, 2009 01:25 PM by JLatham	4	82
Rounding up a cell to the next Â¼ hour. by Pasquale I have a column that is tracking time spent on projects and an auto summation at the bottom. However I would like to know how to formulate a cell that take...	April 9th, 2009 01:01 PM by David Biddulph	3	134
Count with multiple criteria / combination by EÃ¡n[_2_] What formula or macro can I use to get the following information? From two columns of information I need to find out how many times a certain combination...	April 9th, 2009 12:39 PM by Domenic[_2_]	1	109
How do I reference contents of a cell at the bottom of a column? by MarkB I have a growing set of data which I continually add rows to the bottom of. How do I reference the lowest cell in a particular column, when I don't know if...	April 9th, 2009 12:19 PM by MarkB	2	88
Functions by Aspiring CPA Hello... my questions is concerning functions... SD - Strongly Disagree D - Disagree N - No Opinion A - Agree SA - Strongly Agree i would like to add values to...	April 9th, 2009 12:10 PM by Eduardo	1	72
Copying data from several sheets to a front sheet by Marie Green I have a workbook with 30 sheets, one for each person. I individullay add data to each sheet each week. I would like a front sheet that accumulates parts of...	April 9th, 2009 11:51 AM by Pecoflyer[_282_]	1	102
Selecting a row in a worksheet by Rochelle in Melbourne Hello, I'm trying to select more than one row, not adjacent to one another, in Excel, I have been holding the ctrl button down as I select which just selects...	April 9th, 2009 11:34 AM by Gary''s Student	1	62
If Formula - checking the same cell for different entries by Ann Hi I have the following formula: =IF('April 2009'!K90.25,"A",IF('April 2009'!L9=ML,"ML",IF('April 2009'!L9=SL,"SL",IF('April 2009'!L9=CL,"CL",IF('April...	April 9th, 2009 11:09 AM by RonaldoOneNil	1	65
how to make a function to extract from to by Fableman Sesam street 4B Motherstreet 56 Jungle terror street 5 Monky do funky street 6D How can I make a function that extract the street number ex. 4B, 56, 5 and 6D...	April 9th, 2009 11:06 AM by Jarek Kujawa[_2_]	1	67
Multiple criteria IF statements? by EÃ¡n[_2_] Can you have an if statement with mulitple criteria? For example IF columns A1:A22 contain "High" and columns B1:B22 contain "Low" then returns a value of 5?	April 9th, 2009 09:59 AM by Bob Phillips[_2_]	2	75
array of data and nested bits by Alqemyst Howdy, I have two variables (width & Height) which determine a final costing. Initially I tried nested IF statements but I have too many possibilities...	April 9th, 2009 09:58 AM by Bob Phillips[_2_]	1	56
how to give hyperlink to hidden excel sheet by Chetu Hi Team, please guide me for the how to give hperlink to hidden excel sheet. Thanks & Regards, Kiran P. ---------------- This post is a...	April 9th, 2009 08:56 AM by Chetu	0	84
Combine IF Statments by Elaine Hello, I need to combine 2 IF statements. The IF statements are all values. The first IF statment places a value in the cell and the second IF statment...	April 9th, 2009 04:27 AM by Elaine	2	67
compare and return a value from another worksheet by Mike I have a workbook with two worksheets ... Customer (A) & New Sales Price (B). Worksheet A has a column listing item numbers and in a corresponding column...	April 9th, 2009 04:10 AM by Ashish Mathur[_2_]	3	105
excel does not mark cell with inserted comments. by Jim K[_4_] Excel has stopped marking cells where comments have been inserted. The comments are in the cells.	April 9th, 2009 02:34 AM by Jim K	2	65
Strip Out Four Characters, then Average by ryguy7272 I posted this onto the end of a post that I put up earlier today. This is tough and I can't tell if people stopped reading the old post or if no one has...	April 9th, 2009 01:37 AM by Ashish Mathur[_2_]	7	86
function needed by JJ I have 2 columns, if i change cell_1 in column_1, my cell_2 is going to change the text from "T" to "A". how can i do this?	April 9th, 2009 01:14 AM by Gord Dibben	2	61
Calculate Average with 'x' in Range of Cells by ryguy7272 I am trying to figure out a way to find an average of a range of cells, most of which contain an "x" (between quotes) character. For instance, I have... ( 1 2)	April 9th, 2009 12:52 AM by Jarek Kujawa[_2_]	11	87
cell content - data entry order by enduser by Tammy I locked and validated cells in a .xls worksheet for endusers to complete As i tab through the form to add data....the cells selected don't go in a...	April 9th, 2009 12:44 AM by Gord Dibben	2	69
Horizontal Scroll Bar Not Working by DCJoe Good evening, I am hoping that someone can help me here. I do IT work for a living and I may have run across this issue years ago but I just remember the...	April 9th, 2009 12:38 AM by DCJoe	0	56

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