Discussions - microsoft.public.excel.worksheet.functions

	Range with 2 validations
	Dear experts, I've a range named "staff" which I have set a validation: List --> source = INDIRECT($B$1). For the dropdown list, the users can select the staff name within the range. However, in the meantime, I want to set another validation to the range so that there is no duplicate entry: Custom --> source =... more » By Freshman - 9:59pm - 2 new of 2 messages

	How do I increment the row and column of a cell in a formula?
	I would like to drag a formula down a column, where the cell referred to is one column right and one row down from the previous cell; =A1 =B2 =C3 ... Thanks, Dan By Dan - 8:46pm - 3 new of 3 messages

	Office 97 wouldn't work with Windows 7, so I had to make a choice....read please
	After waiting I finally tried Open Office and after 2 weeks I knew nearly ALL the needed commands for it. Plus it's free! Don't get me wrong, I paid for and used that Office 97' too death, through Vista but the cheapest Office 2003 or 2007, even used was WAY TOO MUCH for me...I was thinking $40-$60 and that was not even close... more » By Pedro Sanchez IV - 8:47pm - 1 new of 1 message

	Referencing External files with slightly different names
	I have a spreadsheet that colates data from other spreadsheets. Each quarter, a new spreadsheet is created, and I want to reference that new datasheet from within the top level. The file names change slightly, such as "BookingsQ109" vs. "BookingsQ209". I've tried using the INDIRECT function to create a text... more » By PeteJ - 8:16pm - 5 new of 5 messages

	Leave final cell blank
	Above is not quite right. In the equation set out in S4 all other cells thru C4 thru R4 are empty but b4 has a value in it. By Scoober - 8:14pm - 3 new of 3 messages

	How do you make the INFO("directory") function work?
	The INFO("directory") function displays the default directory instead of the directory that the work book is saved in. I have succeeded in getting the function to report the correct directory if a "Save As" command is used, but closing the workbook and excel and then reopening excel and the workbook... more » By TimR - 7:38pm - 2 new of 2 messages

	Looking for the correct excel formula
	I have a spreadsheet with the following values. Column A is the item number and column B is the qty. TAB1 A B 1 Item Number Qty 2 500cc 0 3 1500cc 100 4 1500sp 0 5 3000cc 100... more » By rockyboxboa @ phillyboxes. com - 7:07pm - 3 new of 3 messages

	data sort with excel 2002
	just as excel 2007 can sort unique records, do have this function plug-in for excel 2002? By ShankuN - 5:05pm - 2 new of 2 messages

	Resize image using macro
	When I recorded a macro to enable me to resize an image non of my actions were recorded. I want to be able to select any image contained in a workbook sheet and click a command button to resize the image. By Gotroots - 5:00pm - 2 new of 2 messages

Return the current Yearly Quarter based on date

Side Bar** This discussion board is a great resource thanks for the information. I am trying to figure out a formula that will return a 1st Quarter, 2nd Quarter, etc. in to a field based on todays date. Assuming each Quarter began on the first of Jan, Apr, Jun, and Oct. So if today was January 3, it would place 1st quarter in the field. If it... more »

By hozman - 4:57pm - 3 new of 3 messages