Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
microsoft . public . excel . newusers
This is a Usenet group - learn more
Find or start a Google Group about newusers.
Group info
Language: English
Group categories: Not categorized
More group info »
Related Groups
Microsoft Office Excel newsgroup.
Low 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 16031  Older »
Description: Microsoft Office Excel newsgroup.
 

Collating entries from multiple sheets 
  Dear Experts, I have 28 separate worksheets (classes of drugs) and from column O on each of those worksheets I want excel to look down the column and detect when there is text entered (drug name) and record it in a separate sheet. At the end of the day I want one sheet which collects those occurences of text in... more »
By jc132568  - Nov 23 - 3 new of 3 messages    

Subtracting Two Tables 
  Is it possible to easily subtract two tables and place the results into another table? I have two 4x4 tables. The left corners are at A1 and F1. I would like the result to appear in the corner at A7.
By wolf_tra...@invalid.com  - Nov 23 - 5 new of 5 messages    

arrange data 
  Hi, I've got certain data in an excel sheet horizontally and vertically. Eg Product A Product B Product C Sales xxxxxxx xxxxxx xxxxxx Gross margin xxx xxx xxxxx Marketing expenses xxxx xxx xxxxx... more »
By Suri  - Nov 23 - 3 new of 3 messages    

Find Items Throughout Workbook 
  I own Excel 2000, but for some reason when I had to install it after my old computer crashed I couldn't use the "search workbook" function. (Edit-Find-look in workbook). Can someone let me know how I can get this function back?
By bintight  - Nov 23 - 1 new of 1 message    

Excel 2007 counting numbers 
  In Excel 2007 I have a question... I have a cell in a column B1: MJTB1001 I need to paste to approximately 235 new rows in the column B1 as follows MJTB2002 MJTB3003 MJTB4004... etc. What formula should I use to accomplish this task? Also I have the cell MJTB2044 and I need to make 235 new cells in column to... more »
By urlocaljeweler  - Nov 23 - 4 new of 4 messages    

Naming ranges on multiple worksheets 
  I have a workbook with multiple worksheets, the worksheets are structured identical to each other. I need to name certain ranges in each of the worksheets. On the first worksheet, I was able to name the ranges without difficulity, however when I attempt to name the ranges on the worksheet number 2, it throws me back to sheet 1. The range name that I entered on... more »
By Jim  - Nov 23 - 4 new of 4 messages    

data from many work books 
  How do I collect data from many workbooks from select columns into a single workbook automatically. I don't want to open each one manually and copy and paste from it to the main workbook. The system should ask me for which file to be opened. Please can you help. Thanks and regards, Sandeep S.
By Sandeep S.  - Nov 23 - 3 new of 3 messages    

Percentages 
  Hi I would like to use a scoring method in percentages which would recognise 1 to 5 as 0% - 100%. e.g 1= 0-24%, 2= 25-49%, 3= 50-74%, 4= 75-99% and 5= 100%, thanking you in advance, Geno...
By GENO  - Nov 23 - 3 new of 3 messages    

Calculating the 95% confidence inteval of a slope 
  As a low key user, I can calcualte the slope of a line from the x and y values, but I don't know how to determine how good the estimate is. Can someone help?
By seeker  - Nov 22 - 2 new of 2 messages    

Freeze at the top & split the side in Excel97? 
  Is it not possible to freeze the titles at the top of the screen (always show row 1 at the top of the screen) AND then split the screen so that I can view one column on the left side independantly of the section I'm working on on the right side? It seems that splitting the screen cancels the freeze command, and it... more »
By SlickRCBD  - Nov 22 - 3 new of 3 messages    

1 - 10 of 16031   « Newer | Older »

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