| Thread | Last Post | Replies |
|
| Problems with Copy and Paste in Excel | 19 Aug 2005 12:27 GMT | 1 |
When I try to copy a range of cells the resulting paste gives a bitmap of the whole spreadsheet. I do not want this. How do I resolve this problem so that I paste the cells that I have copied only ?
|
| Using Vlookup to compare and validate data | 19 Aug 2005 12:15 GMT | 1 |
I have the following 2 worksheets - named "results" & "Motors" Results sheet has 2 comboboxes, one sits on cell C5 in column "motorsize" the other sits on D5 in column "motorname"
|
| woorkbook | 19 Aug 2005 12:14 GMT | 1 |
Imam 14 radnih knjiga sa istim listovima . željelia bih u 15 knjigu da mi se zbroje svih 14 knjiga svaki list u svoj.
|
| sumif on 2 criteria with worksheetprotection enabled | 19 Aug 2005 12:01 GMT | 2 |
read other posts, don't seem connect it with my little problem: flat table filled by low-users, passwordprotection enabled, so VBA, macro or pivot is out of the Q. column1: project (XXX, YYY, ZZZ) (A)
|
| HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT | 19 Aug 2005 11:50 GMT | 2 |
I WOULD LIKE KNOW THE SYNTAX OF IN EXCEL FOR THE FOLLOWING: 'HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT' Presently this is availble for Bhat text and not for English. PLEASE SUGGEST.
|
| Triple occurence formula | 19 Aug 2005 10:43 GMT | 1 |
Anyone knows how to make a triple occurence formula ? Example: Cell A1 = 2356789 Cell A2 = 01345
|
| Formatting Subtotals | 19 Aug 2005 07:17 GMT | 2 |
I have a worksheet that has 102 departments. Is there anyway that when I subtotal by department I can have it automatically add color to that line. For example, could I have it bold and highlight in yellow all subtotalled lines? I'd also like to add formats around the ...
|
| how do i copy rows using critera in a formula? | 19 Aug 2005 07:06 GMT | 1 |
i need to know how to copy whole rows on to a diffrent sheet using critera in a column for a formula so i dont have to look through 55 pages of data and copy what i want.
|
| Validation for a cell | 19 Aug 2005 06:12 GMT | 2 |
Dear expert, I want to set a cell (for example : A1) with validation so that the value in it will not appear twice in a row, say A1:M1. My formula is: =COUNTIF($A$1:$M$1,A1)<=1.
|
| Visible rows and functions that work | 19 Aug 2005 05:26 GMT | 2 |
I understand from some other posts that there is a way I can get some functions to work when using the auto filter feature on a spreadsheet filled with data. I have such a spreadsheet, a number of them actually, that I'd like to be able to see the filtered rows and have statistics
|
| Counting weeks | 19 Aug 2005 03:18 GMT | 6 |
Hi, need a bit of help on this one. I need to be able to count weeks. (Mon-Fri). I also have to be able to count part weeks (Thur-Fri) Now i am guessing that i am gonna need to use 2 formlae to do this. but
|
| links to same files in different folders | 19 Aug 2005 02:48 GMT | 2 |
Hi, I have a group of files that are being updated separately, but all reside in the same folder. There is 1 consolidated file in that same folder. I need to create an update every week for the same set of files, which I do by copying the entire folder to a new folder and ...
|
| Column Headers Not Fixed | 19 Aug 2005 02:41 GMT | 2 |
I have a 650-line sheet with columns A-P. When I use the sort feature for different columns (such as sorting by last name, or zip code), the headers keep sorting into the sheet. Anyone out there know a way to fix the column headers? I use Excel regularly and have never had this ...
|
| Please help!! Vacation Accrual Formula | 19 Aug 2005 02:33 GMT | 1 |
OK, I actually created this formula several years ago at my old job bu since I am no longer there, I have no access to it. My boss helped m with it and I just can't remember the formula. Basically, I need to create a spreadsheet showing number of accumulate
|
| mailing labels | 19 Aug 2005 02:13 GMT | 1 |
I have a list of names, adressses, etc in excel. I want to print mailing labels. Need the easiest and fastest way to accomplish this printing.
|