Worksheet Functions - Page 607

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
Adding values in first "X" number of rows dynamically by MattyP Hi - I have a data worksheet which has item sub-totals in column F (each row is a different item). In a different worksheet, I have a a few other...	April 15th, 2009 06:13 PM by T. Valko	3	71
Data Validation using a table by JBranter I am trying to set up data validation using multiple columns, but not sure how. Example - trying to limit choices of items sold as tiles, tools, plants. ...	April 15th, 2009 06:09 PM by JBranter	3	119
Headings of columns now have numbers, need to change them to lette by JeffL Today all the headings of my columns of my spread sheets have changed to numbers. Can someone tell me how to change them back to letters? I'm using office...	April 15th, 2009 06:01 PM by David Biddulph	3	123
IF(AND(OR function returns #VALUE! error by Linda Hi, The following formula in a cell retuns the #VALUE! error message. I have tried using the formula auditing-evaluate formula. It shows the #VALUE!...	April 15th, 2009 06:00 PM by Linda	3	73
Concatenate unique values among duplicates by Toby Hi. I'm trying to create a formula that, based on the results of a vlookup, will combine any number of unique cell values into one. In spreadsheet 1, I have...	April 15th, 2009 05:55 PM by Herbert Seidenberg	6	93
How do I only send 1 worksheet of a file in an e-mail? by JeffL In a spread sheet with multiple data tabsm, I would like to only send 1 worksheet in an e-mail, is that possible.and hiow do i do that? Thanks	April 15th, 2009 05:27 PM by Luke M	1	67
I cannot use DIAS.LAB in my Excel (Spanish) by User VB Excel[_2_] In my office computer I cannot use DIAS.LAB (Excel said to me that #Â¿NOMBRE?) I think I haven't this function in my implementation. How I do for using...	April 15th, 2009 05:01 PM by User VB Excel[_2_]	0	105
Weekending Function by Tracey Hello I have a worksheet with 15000 lines and we have a date field. I now need to work out the weekending date (Fridays) so if the date is 07 Apr 09 the...	April 15th, 2009 04:54 PM by Tracey	5	80
count formula question by mcook I am working in a spreadsheet with two worksheets in it. On worksheet 1 I want to enter a formula that tells me how many cells in column h5:h622 on the...	April 15th, 2009 04:36 PM by mcook	2	108
excel function help by [email protected] I have two ranges named PReq and QOutput. I have this procedu Sub test_dependency() Call dependency(Worksheets("PP"), , , "testtitle") End Sub And I have:	April 15th, 2009 04:29 PM by Charles Williams	4	181
Advanced Filter by dicko1 Is there a way to filter for more than two values? Example: If column A's values are 1, 2, 3, 1, 4, 5, 6 I would like to filter for 2, 3, and 6? When a...	April 15th, 2009 04:16 PM by Herbert Seidenberg	2	119
Date Range by msguirt I'm new to Excel (2003), so . . . I'm trying to make a column to show every Sunday of the year for 2009. How do I do that without having to type in each...	April 15th, 2009 04:09 PM by David Biddulph	2	48
How do I bracket text in cells by formatting a whole column? by tywlam I want to bracket text or number in a cell, eg. abc becomes (abc). Or add predetermined prefix to a number or text. How can I use the Text function or...	April 15th, 2009 03:38 PM by Sheeloo[_5_]	3	225
function =IFERROR LOOKUP works in excel 2007 not in excel 2003 by David Ryan[_3_] Hi Folks the function below works in excel 2007 but not in 2003. =IFERROR(LOOKUP('HDU Roster'!$C$9,{7,8,11,1330,1430,2245},{8,8,8,8,8,8}),0) The file is saved...	April 15th, 2009 03:25 PM by Steve	4	103
Lookup Problem with Index and Match by Mike B Hi, I am trying to get the following working using the lookup function. it works fine as it is shown however I have tried entering the lookup function...	April 15th, 2009 02:50 PM by Mike B	3	56
Time Calculations by jacsdad In Excel 2007, I am attempting to calculate the difference between two times. I have read the instructions in Help and found what I need to do, but cannot...	April 15th, 2009 02:35 PM by Bob Phillips[_2_]	2	106
style sheets vs cell formatting by Exceluser1 I am trying to choose between having a stylesheet that can be applied over a score of worksheets vs doing cell formating when required. What is the better...	April 15th, 2009 02:14 PM by Exceluser1	0	68
How do I ADD characters to the data for a group of cells? by PatPatt On a mailing list, in the first column (Name), I'm trying to add the phrase "(or Current Resident)" to each name, all at once. This should be easy, right? I...	April 15th, 2009 02:09 PM by PatPatt	2	96
Vlookup Error by Farooqi Hi, I am getting a #N/A error when i try to use the formula, =VLOOKUP(G20,'Protection Details'!$A$2:$D$112,2,FALSE) In turn Cell "G20"in the above has this...	April 15th, 2009 01:23 PM by Ashish Mathur[_2_]	2	114
mean of range of dates by leot I have a column with a range of dates. 4/2/2006 4/4/2006 4/4/2007 4/7/2008 4/9/2006 5/1/2007 5/2/2006 5/2/2007 5/3/2008	April 15th, 2009 01:08 PM by Jarek Kujawa[_2_]	3	51

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