| Thread | Last Post | Replies |
|
| alphabetize the names colum on the excel | 01 Jun 2007 17:07 GMT | 1 |
How do I alphabetize the names on the excel
|
| Conditional Statement in Excel | 01 Jun 2007 16:11 GMT | 1 |
I'm trying to create an if statement that whenever the user selects "Debit Memo" from the dropdown menu in column A (has other items-- Credit Memo Check, Transfer), the user would be forced to enter the corresponding value in column F (Debit). If the user attempts to
|
| Application quits each time I use the spreadsheet in Excel | 01 Jun 2007 16:09 GMT | 1 |
Everytime I try to use my spreadsheet, the application quits. Sometimes I get it to open for about 30 seconds, othertimes it quits upon opening. HELP!
|
| SUM values if containing an error | 01 Jun 2007 16:05 GMT | 2 |
I have the following formula and I am not getting any results to show. =SUM(F7,F16,F25,F34,F43) Each cell in the formula displays the result of another formula (which may or may not yield a result - if not the result is an value error).
|
| empty cell in formula | 01 Jun 2007 15:07 GMT | 2 |
I have an Excel book but it's for advanced users and, I guess, this is so basic that the answer is not there. I have a really simple spreadsheet I use to replicate my time cards from work. for this example I have:
|
| deleting rows with a macro | 01 Jun 2007 13:43 GMT | 2 |
I am using Excel 2000 and would like to create a macro to delete rows that do not contain specific text in column 1. so, if the cell does not contain the words 'Centre' or 'Member' I would like to delete the row. I am a bit of a beginner to macros and have looked up the ...
|
| grouping the numbers as per indian method | 01 Jun 2007 13:37 GMT | 2 |
sir, i wnt to group number as follow for, 1234567891213456.75 as 1,23,45,67,891,2,13,456.75 (i.e. indian method of grouping pg numbers)
|
| Recalc question | 01 Jun 2007 13:35 GMT | 2 |
Is is possible to have an automatic worksheet recalc, say at a timed interval, or when the worksheet is accessed? This is required to update the now() function without having to press F9.
|
| simple subtraction | 01 Jun 2007 10:10 GMT | 2 |
I need help subtracting values in rows from each other. My data looks like this Values Difference 242
|
| how to flush away undo commands? | 01 Jun 2007 08:10 GMT | 1 |
how can I flush away undo commands? I use excel 2003 or 2007. Thanks.
|
| Need help with very complicated loan spreadsheet. | 01 Jun 2007 02:35 GMT | 1 |
Hi everyone, I was wondering if anyone can help me out with this. I have a loan and wanted to do a spreadsheet to keep an eye on everything. I've looked everywhere for one that will suit me without any luck.
|
| Creating a rota | 01 Jun 2007 01:16 GMT | 2 |
I am trying to create a rota for work. I have used the randbetween function to create a number between 1-6, and then used the choose function to use th erandom number to pick a name from the list of staff in the choose function.
|