Description:
Microsoft Office Excel newsgroup.
|
|
|
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
|
|
|
Calculating with Variable Search
|
| |
Hello everyone and I hope someone can help me on this. I am working on a spreadsheet and I am trying to automate some of the calculations in the document I am running into a sticking point and I wanted to see if anyone has an idea on how to get this to work. Issue: I am receiving data from an exported report that works within Excel.... more »
|
|
|
Is there an excel template for coupon organization?
|
| |
I would like to create a workbook in excel to record and store info on all types of coupons that can be sorted by date of expiry, ingredient, store offering etc. I figure that this has probably already been done and that a template should be available but so far I can't find one. Does anyone know... more »
|
|
|
|
