| Thread | Last Post | Replies |
|
| Anybody....? | 15 Apr 2004 17:26 GMT | 1 |
Supplier SuppA Name Arne Andersson AB Adress: Storgatan 1A SuppB Name Sven Svensson AB
|
| lotus 123 | 15 Apr 2004 17:13 GMT | 2 |
how to convert lotus 123 file (bill.123) to excel 2002? Paul
|
| Floating button???? | 15 Apr 2004 15:48 GMT | 5 |
I have a circular autoshape with a macro assigned to it, when clicked it sorts the excel sheet, but when i scroll down the page the button scrolls with the text and cannot be seen anymore. is there a way to float the button above the worksheet and lock it there?
|
| Virus - Ms-Word, Excel gone to 0KB | 15 Apr 2004 15:21 GMT | 1 |
Hello Helpers Can anyone help me? I have very important data on my one of the hard disk in word files an excel files, that got infecetd by virus on 10-4-2004. And the virus se
|
| VBA concatenate | 15 Apr 2004 14:05 GMT | 1 |
Hi, I'm familiar with concatenating (using "&") in excel. When trying to use it in VBA this works: Dim text As String
|
| customize colors | 15 Apr 2004 13:22 GMT | 2 |
it's a silly little question i've got: where can i cutomize colors (for background etc.)? it's probabl obvious but i just can't find a way to do it thanks
|
| Excel file no response!! | 15 Apr 2004 12:14 GMT | 1 |
There are three or four excel files opened on my computer. When I switch from one excel file to another, it is usually no response. In addition, one excel file is very big, about 14 Mega bytes. The OS platform is windows 2000 professional. Office version is office 2000.
|
| Counting items based on multiple conditions | 15 Apr 2004 12:01 GMT | 2 |
Attached spreadsheet explains the problem What I need to do would be possible if COUNTIF could be based on mor than 1 conditio Attachment filename: query 1.xls
|
| Excel Countif but with multiple conditions | 15 Apr 2004 11:54 GMT | 2 |
I need to count items in a column only if the value is greater than certain figure and also where a condition in the same row of different column is satisfied The attached spreadsheet describes it better
|
| Newbie Excel Help PLEASE!!!!!! | 15 Apr 2004 11:09 GMT | 3 |
upon creating my first spreadsheet, for inventory purposes..........is there a way to carry totals from one spreadsheet forward to a new spreadsheet using the same excel Spreadsheet template? For example:
|
| => AutoFilter - Amount of shown lines (LineCount) | 15 Apr 2004 09:37 GMT | 2 |
AutoFilter - Amount of shown lines (LineCount) ================================= I want to get the Amount of Lines of an AutoFilter result. (the amount of lines shown after I made my AutoFilter choice)
|
| Deleting empty cells/rows | 15 Apr 2004 08:55 GMT | 7 |
How do you delete 100s empty rows, with one simple click or several... as long as it's not right click+delete... I tried conditional formatting, macro, visual basic, and have nothing to go on...
|
| Function for Multiple results from a look up in a table | 15 Apr 2004 08:54 GMT | 1 |
I am working on a table with mutliple datas (about 40 columns and 2000 rows), with text and numbers. I am trying to set up a sort of cross reference. I want to compare 2 parameters of a same row for a specific part with
|
| Formatting 1000's | 15 Apr 2004 08:33 GMT | 10 |
I want to format as follows. I have the number 1,522.32. I want to format and see 1,5 How can I do this without modelling and dividing by 1,000. I want to format.
|
| Time calculation: billing for minutes | 15 Apr 2004 04:16 GMT | 1 |
I am trying to enter a start time in one cell, an end time in another, and calculate the total to charge, based on $35 per hour. ie: 9:35 a.m. start, 9:40 a.m. end is 5 minutes. How do I calculate 5 minutes (1/12 of an hour) into percentage, or whatever to end up with the correct ...
|