| Thread | Last Post | Replies |
|
| how could I import a text file with comma separated values into ex | 15 Sep 2005 11:27 GMT | 1 |
how could I import a text file with comma separated values into excel? Thanks in advance
|
| What is wrong on the fomular: Offset(MIN(A1:A10),,-1)? | 15 Sep 2005 11:19 GMT | 4 |
I have a huge spread sheet, in which I need to extract the value from the cell, which sits right to the lowest value in the whole row. E.g.: Example row: 2|4|7|3|0.3|10 Expected extract value: 3
|
| Adding Cells | 15 Sep 2005 10:37 GMT | 4 |
I have cells that are different colors ( to represent differnt items). If i want to make a fomula that added on the cells that were a certian color, how would i be able to do that? Thanks
|
| Formula error in merged cells | 15 Sep 2005 10:36 GMT | 1 |
Help! I recently discovered an error in my shipping worksheet. I sometimes need to merge certain cells when I am combining items from different purchase orders into the same shipment. However, when I totaled the column (SUM) containing the merged cells, it delivers a
|
| combining 2 pieces of text from 2 columns | 15 Sep 2005 10:36 GMT | 3 |
Column A has first names, and B second names. I want C to list the 2 names together, how do I do this? thanks, Alex.
|
| How do you add a-z (alphabetically) to your toolbar in micr works | 15 Sep 2005 10:04 GMT | 3 |
I can't find excel. I need the a-z added to my tool bar. I am trying to log in about 4,000 videos in alphabetical order. I am trying to start a home business of video rentals and sales. I need the a-z for my inventory. Please help me, I am desperate.
|
| Arrays | 15 Sep 2005 07:37 GMT | 3 |
I have an interesting situation, would like some input. I have a set of values on a sheet which have one similarity which is the acct# now i want excel to copy that data to an appropriate tab which is numbered with that specific acct#, i want it to copy all the activity that is in ...
|
| Linkage data between two spreadsheet | 15 Sep 2005 06:50 GMT | 2 |
Can anyone help to solve the follow problem: Spreadsheet A has the follow column: -PartNo -VendorCode
|
| Formula Assistance Required | 15 Sep 2005 05:10 GMT | 4 |
I'm trying to create a formula that if (f3)*1.14 minus (h3) minus (k3) is greater than or equal to zero, response would be "0" but if the response is less than zero, response would be "Error" or some other message as a visual marking that (f3)*1.14 minus (h3) minus (k3) is less ...
|
| Filtering Columns to Align Matching Data | 15 Sep 2005 04:48 GMT | 4 |
If I have a list of data in column A, ie: phone numbers, and I also have a list of similar data in column B. Some, but not all numbers in column B match numbers in column A. Is there a way to filter the two columns so that matching data from columns
|
| Make boxes apear on paper? | 15 Sep 2005 02:09 GMT | 1 |
How do I make the cells apear on the printed page? HELP!
|
| Can't get list in Document Contents for workwheet | 14 Sep 2005 23:54 GMT | 1 |
In any given worksheet, in File -> Properties, there is a Contents tab. On this tab is a list of the worksheets within the workbook. Is there any way to get a list of these without having to do a manual copy/paste from each tab, or scroll through the tabs to get what the names ...
|
| How do I define "contains' as the default custom filter? | 14 Sep 2005 23:35 GMT | 2 |
How do I define "Contains" as the default custom filter criteria or make it fist in the pulldown choice?
|
| Need to compare 2 tables to generate 3rd table | 14 Sep 2005 22:50 GMT | 1 |
I have a table with a list of items and another table that explains what each item is. How do I have excel compare the 2 tables and generate a 3rd table with the items and description matched up?
|
| change case in excel | 14 Sep 2005 22:31 GMT | 9 |
can someone tell me where to find the "add in" that converts the case text from lower to upper in excel. i've already downloaded this before but can't remember where from and it is much easier than creating a formula or a macro
|