Description:
Microsoft Office Excel newsgroup.
|
|
|
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 »
|
|
|
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 »
|
|
|
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.
|
|
|
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...
|
|
|
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 »
|
|
|
CountIF on two criteria
|
| |
I'm trying to tabulate a survey using Office 97. ONE of the things I need to tabulate is dependent on two critera. If the first column is "O" (a text field, as the other entires are ranges), then I do not want to count the value for the second field. Otherwise, I want a total of all the fields in a second column with a given value where... more »
|
|
|
What does =B11*$C$4 mean?
|
| |
=B11*$C$4 I get the cell value equals cell B11 times——then what's the $ mean, $C$4? I think it means use the value in cell C4, but what do the $ mean?
|
|
|
Mark Rows for scrolling
|
| |
This seems weird! I mark row 4 and row 1 and click on Freeze Panes. Rows 1-3 become frozen. There's also a black line below Row 6 that acts like another Freeze (Rows 4-6!) Does anybody have an answer to this? Thanks, Doug
|
|
|
|
