Worksheet Functions - Page 4331

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
2 questions about checkboxes by Tom S. I've added a checkbox to a spreadsheet, using the Form toolbar. Two questions: 1) I'd like to make it bigger (the box and the font of the accompanying text). ...	October 11th, 2003 06:56 PM by Dave Peterson	1	84
cell formats by John Gorczynski I continue to receive the error message "To many different cell formats". This will not allow me to change the aligment, decimal points, borders, colors...	October 11th, 2003 06:53 PM by David McRitchie	2	448
Help with making a Timesheet by Arvi Laanemets Hi Maybe you deliver some additional info for us: How much employees? Payment shedule (weekly, monthly, ...)? Is payrate fixed for payment period, or can be...	October 11th, 2003 06:47 PM by David McRitchie	2	297
Excel - Drop-down list for entering the same data in multiple cells by Lee Davis I am after some assistance and hope someone can help. I know how to produce a drop-down list for entering data in a single cell, but I don't know how to apply...	October 11th, 2003 06:21 PM by kevin muniz	4	277
Converting working times to hours by Alex I am trying to write a spread sheet that will convert say 9-5 or 2-10, convert these to hours and add them up at the end of the row. Repeat the same for other...	October 11th, 2003 06:14 PM by Kevin Muniz	2	232
Changing rows and columns size across all workbooks by Stephanie R Hello! Is there a way to adjust the rows and columns on a workbook and have these changes apply to all workbooks? Thanks in advance! Stephanie	October 11th, 2003 05:57 PM by GB	1	395
shortcut for copying a formula with relative references by Shawn Does anyone know a shortcut for copying a formula with relative references as a formula with absolute references without having to put in all those little...	October 11th, 2003 05:41 PM by RagDyer	4	381
Logging inputbox input by Dennis Is there a way to log all input that is entered through a inputbox? I have a inputbox in a macro that a user enter data into. What I would like to through...	October 11th, 2003 03:25 PM by Bob Phillips	5	242
COUNTIF and numerous columns by the_gnome I have the following columns A=month B=year C=Priority D=Inspected Column A data is Nov, Dec etc Column B data is 2003, 2004 etc	October 11th, 2003 10:03 AM by the_gnome	4	316
unique names by saad Hi, I have a list of thousands of customers in column A. I just need to find out the count of unique customer names that appear in this list. If also...	October 11th, 2003 02:36 AM by Max	4	244
I am trying to unite one column with another column by czar Hi, I have a spreadsheet of contacts with the names, company, fax area code, fax local number in separate columns. And I am trying to unite the two...	October 10th, 2003 09:09 PM by Dave R.	1	127
copying cells to increment cell reference by Peo Sjoblom Use a defined name like =vlookup(I2,MyTable,2,0) or =vlookup(I2,$K$1:$L$280,2,0)	October 10th, 2003 08:45 PM by Earl Kiosterud	1	283
Column and Row formula by Bryan Hughes Hello, I have a column that I am taking on row in a column and * by 20% form the # found in the same row in a different column. I can do this for each row...	October 10th, 2003 08:45 PM by Don Guillett	2	300
Rounding by Jerome Alper I have a spreadsheet that has several tabs with some columns of whole numbers, I would like to round these numbers to millions with either formatting or a...	October 10th, 2003 08:17 PM by Bernie Deitrick	1	96
Need to get cell contents twice a month. by Barney How can I get cell contents on the 1st and 15th of each month and automatically enter those contents in another cell. Thanks, Barney	October 10th, 2003 07:54 PM by Barney	2	123
ISBLANK by keyt What is the syntax required to include ISBLANK within the criteria of an advanced filter? ie: Criteria Name Date TOM =ISBLANK(???) ...	October 10th, 2003 07:33 PM by Peo Sjoblom	1	153
Graphics on worksheet by mildly_desperate Greetings! Is there a way to place a graphic behind cells so that I can see the graphic but still click in the cells over it and add numbers or formulas to...	October 10th, 2003 07:27 PM by still_a_bit_nervous	2	114
IF function- Return Data from Separate Column by Bernie Deitrick I think what you're after is this, entered with Ctrl-Shift-Enter in cell C2 =MIN(IF($A$2:$A$10=A2,$B$2:$B$10)) Change the 10 in both spots to reflect your...	October 10th, 2003 06:33 PM by Bernie Deitrick	1	396
STDEVP Function - help by Kirti Sharma Can anyone tell me when using the STDEVP function in excel to obtain standard deviations, is the resulting answer 1 sigma standard deviation or 2 sigma...	October 10th, 2003 06:22 PM by Harlan Grove	1	157
Merge columns by Jonesy I have a spreadsheet that looks like the following: A B 1 Last Name First Name 2 Jones Jim 3 Smith Bob 4 Williams Joe If the...	October 10th, 2003 06:21 PM by Paul B	1	510

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