Web Images Videos Maps News Shopping Gmail more »
Recently Visited Groups | Help | Sign in
Google Groups Home
microsoft . public . excel . worksheet . functions
This is a Usenet group - learn more
Find or start a Google Group about functions.
Group info
Language: English
Group categories: Not categorized
More group info »
Active older topics
8 new of 8 - Nov 12
9 new of 9 - Nov 12
4 new of 4 - Nov 12
13 new of 13 - Nov 12
Hi
3 new of 3 - Nov 12
6 new of 6 - Nov 12
2 new of 2 - Nov 12
4 new of 4 - Nov 12
7 new of 7 - Nov 12
2 new of 2 - Nov 12
Related Groups
Microsoft Office Excel newsgroup.
High activity, Usenet
Microsoft Office Excel newsgroup.
High activity, Usenet
Microsoft Office Excel newsgroup.
High activity, Usenet
Discussions
View:  Topic list, Topic summary Topics 1 - 10 of 141780  Older »
Description: Microsoft Office Excel newsgroup.
 

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    

1 - 10 of 141780   « Newer | Older »

XML      
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google