Worksheet Functions - Page 4382

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
Which function do I use? by Zong Workbook with 2 spreadsheets. I need to look up a part number in one column and have it give me the value in another column on the same row. PS# ...	February 22nd, 2009 11:20 PM by T. Valko	7	77
Special today Date challenge question by ZONNET What I want is have a today function eg in cell A1. based upon entering any text in for eg b2, puts me the julian dat in cell A2, So far, so good, I got that...	November 19th, 2003 06:18 PM by Don Guillett	1	397
how do I keep column titles on subsequent pages of a pivot table by Zoo7 When you have a pivot table that is two or more pages long, how do you go about ensuring that the column titles are on each page? looking forward to your...	December 10th, 2005 11:59 AM by Roger Govier	1	92
Excel drag down formula not working good.. by zoola hi, i have a formula =IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0))) when i drag...	May 8th, 2008 11:04 PM by akphidelt	1	74
vba excel macro question...ranges by zoola Hello, I have been asked by a friend to help with vb/excel, however i have not touched vb in my life. I have a background in c/c++, so if someone could point...	July 6th, 2005 08:56 PM by Don Guillett	3	144
Excel drag down formula not working good.. by zoola ander hi, i have a formula =IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0))) when i drag...	May 8th, 2008 10:38 PM by zoola ander	0	72
Excel drag down formula not working good.. by zoola ander hi, i have a formula =IF(E6="Casual",VLOOKUP('Product Detail'!L6,Types!D4:E14,2,0),IF(E6="Dress",VLOOKUP('Product Detail'!L6,Types!A4:B12,2,0))) when i drag...	May 9th, 2008 08:51 AM by David Biddulph	1	68
Need Extra Help by Zoom I need help out there. I have the following string 698 2071264621559589 I want the result to be as follows: "698","2071","2646",21559589 Thank you very much	September 16th, 2004 03:47 PM by JBoulton	2	118
worksheets by Zoom on Sheets How do I change the "zoom" on all the excel sheets at one time?	July 13th, 2006 06:36 PM by Gord Dibben	2	76
Please Help...How can I do this? Select a cell by zoombr How can I do this? Select a cell A(1+any value) ... for example: If any value = 2, the select cell will be A3.	March 23rd, 2005 08:34 PM by Ron de Bruin	1	90
Formula to count number of days in range which are less than today by zooming Could anyone proivide me with a formula that will allow the following: I have a range of dates and I would like to count the number of dates that are less...	June 21st, 2005 04:01 PM by zooming	2	277
Setting Up A formula For A Time Sheet by zooming I have setup a column with a list box that includes several project headings. I have also setup a list box that allows you to select the amount of time...	June 27th, 2006 08:13 AM by zooming	4	111
Budget Set Up by zoomzoom632 Please view my Excel files to better understand what I am talking about... http://www.geocities.com/bushiebrow2000/Fall_2008_Budget_Test_Sample.xls On the...	September 14th, 2008 12:11 AM by Bob Bridges[_3_]	9	102
Number Order by zoomzoom632 I want to take a list of numbers and sort them using functions in another column Sheet one, Column A: a bunch of numbers in a random order. Column B:...	October 14th, 2007 12:42 AM by Pete_UK	5	59
Informational Search by zoomzoom632 Here's the Senario, Sheet One Contain the Results of a Race: Column A: Racers Name (in ABC order) Column B: Their Hometown Column C: Their Time Column D:... ( 1 2)	October 16th, 2007 03:12 AM by T. Valko	17	205
MinMax Buttons by zoot Hello All, I hope this is a stupid question!! Can you not set minMax properties on an excel form....I can not find it in the properties window...did I turn...	September 7th, 2006 01:11 PM by Bernard Liengme	2	63
Moving to Previous Worksheet by Zootie Is there a quick way to open the last worksheet you had open prior to the one you are currently viewing, and toggle between the two sheets? I am looking for...	October 4th, 2006 03:28 PM by PCLIVE	1	61
Duplicate entries in more than one column by ZoR hellor, Well, i hope someone here will be able to help me! My data is as follows: LAST NAME FIRST NAME 1. ABC OPP 2. XYZ ...	January 31st, 2008 06:27 PM by Gord Dibben	5	91
SUMIF function problem by Zorba I have used this formula in the past (last month) without problems - now I have copied the columns and tried to alter the formula - it keeps telling me...	January 15th, 2009 05:40 PM by David Biddulph	6	149
Pivot Table - Old remaining values for rows by ZorionK Dear experts, We are developing some reports with MS - Excel, using pivot tables. We created a pivot table, pointing to some information in the same XL...	April 16th, 2009 06:36 AM by ZorionK	3	86

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