| Thread | Last Post | Replies |
|
| Formulas | 23 Sep 2006 15:27 GMT | 10 |
Is there a formula to round numbers to the nearest quarter?
|
| Is there an easy way to swap the contents of two cells in Excel? | 23 Sep 2006 14:33 GMT | 7 |
I think the subject says it all...
|
| The 1st and 2nd rows of my worksheet have disapeared? | 23 Sep 2006 13:56 GMT | 9 |
Row 3 is the first one shown. I tried to unhide them but it didn't work. When I insert new rows they still start with row 3. Where are the missing 1st and 2nd rows?
|
| Excell should have more data sorting features | 23 Sep 2006 13:52 GMT | 1 |
how do u sort data by multiple rows? for example i have number values of 2 rows and 10 columns. eg: 25 15 01 69 56 55 23 45 03 14 ... 58 68 33 45 02 07 78 90 53 44 ...
|
| When excel is opened, Insert, Format, Data options greyed out. | 23 Sep 2006 13:30 GMT | 2 |
When excel is opened, Insert, Format, Data options greyed out. Right click menu does not work Protection option also greyed out so not issue of worksheet protection need advice on permanant solution to use excel effectively.
|
| dynamic transpose | 23 Sep 2006 12:49 GMT | 1 |
Is it possible to do a dynamic reference for a transpose? I'd like to do the transpose of a 12 cell horizontal reference into vertical, but I need the tranpose function to lookup the line of the 12 cells by finding a value in a vertical list. In other words, the value that drives ...
|
| convert number to its letters ( convert "1" to "One" ) | 23 Sep 2006 11:58 GMT | 1 |
I want a function or command that convert number to its letters it means ( convert "1" to its Letters "One" )
|
| Convert digital #'s to spelled out words | 23 Sep 2006 10:23 GMT | 5 |
Is there a way to turn you numbers into spelled out words? Example 24 = twenty-four
|
| Drop down box | 23 Sep 2006 07:00 GMT | 5 |
If I choose a word/command/field from the drop down box, how can I format the next cell over recognize this selection and display a number? Basically I created a drop down box, Van, Bus, etc...
|
| Conditional date array formula | 23 Sep 2006 06:42 GMT | 1 |
This is the formula: =IF(ISERROR(INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:2))))," ",INDEX(Log!$A$1:$A$2000,SMALL(IF((Log!$B$1:$B$2000>=$Q$1)*(Log!$B$1:$B$2000<=$Q$2),ROW(Log!B$1:B$2000)),ROWS($1:1)))) Log ...
|
| COUNTIF Formula in Multiple worksheets. | 23 Sep 2006 03:33 GMT | 13 |
I need to use the COUNTIF formula to count items in 52 different worksheets. I know that this formula will not work in counting multiple worksheets. Anyone know of a quick workaround? I dont want to get stuck typing 52 different SUM formulas.
|
| I made drawings in excel, I don't see them but they print fine. | 23 Sep 2006 03:30 GMT | 1 |
When I open the spreadsheet the numbers and letter appear but the shapes around them do not appear. If I click on them I can get them to show up, but I have to click on each picture. When it prints all the pictures show up fine. Can you help me?
|
| Automatically Filling In Corresponding Data from Another Worksheet | 23 Sep 2006 01:52 GMT | 2 |
Here's my situation: I have a list of employees on on one worksheet. In the cells next to each employee name are their hourly pay rate, their department, and their various overtime thresholds (the elapsed hour they go in to
|
| Excel Permissions | 23 Sep 2006 01:49 GMT | 1 |
I want to set permissions for an excel file. According to excel "help", I just go to "file" and then "permissions"; there is no "permissions" under the file menu. I have excel 2003 - how can I find permissions? James A
|
| In Excel, use a different row for headings (not row 1) | 23 Sep 2006 01:14 GMT | 1 |
Hi! I'm trying to do a mail merge from an Excel sheet. Unfortunately, it was set up with some other information in the first few rows. Can I mark a different row as the header row for my data? They are in row 5.
|