| Thread | Last Post | Replies |
|
| Excel | 23 May 2008 14:06 GMT | 4 |
I have excel 2002 on my computer, I have excel 2003 at work. Are these two software compatible. I want to know if I have a worksheet in excel2003 I can open it in excel 2002? If not is there a cheap upgrade?
|
| Returning Multiple Matches | 23 May 2008 13:53 GMT | 2 |
I have an worksheet that has data that is sorted like the following Bar NumberProperty Node Orientation OD ID Wall 1 1622 3 5 16 13.25 1.375 2 1622 4 5 16 13.25 1.375
|
| Hyperlink destinations have changed | 23 May 2008 12:28 GMT | 1 |
I have a spreadsheet with several hundred hyperlinks to various documents (all within one pathway. It has all worked fine for months, but today when I opened it the hyperlinks have all changed their destination path.
|
| Use SUMPRODUCT for a matrix | 23 May 2008 10:26 GMT | 3 |
The case is I want to key in two criteria and the function give me back the total. For example, I want Sun in the rows and Two in the column, then will give me the total of 2 + 8 = 10. The Sun and the Two is input some where and will be change from time to time.
|
| Order form - how to automatically round what a person inputs to a | 23 May 2008 10:06 GMT | 3 |
Hi all, I'm trying to make a product order form and I want to set it up so that the "Qty" field automatically changes whatever a person enters into a multiple of 6 units (all the products come in packs of 6 so customers have to order 6 or 12 or 18 or 24 units - you'd be amazed ...
|
| please help in excel functions. | 23 May 2008 08:02 GMT | 2 |
Suppose, i have 3 incentive slabs No.of sale incentive slab 1-10 no.of sale*8 11-20 no.of sale*10
|
| Summarize in Vlookup | 23 May 2008 01:21 GMT | 3 |
qucik question. i have a data table and using vlookup. however getting stuck when i need to summarize all values that matches my vlookup ref. Any help, suggestion would be great.
|
| Can a sort be set up to run within another sort? | 23 May 2008 01:18 GMT | 1 |
I am trying to set up about 4 sort levels, i.e. first sort: no to yes 2nd sort: alpha name 3rd sort: alpha broker
|
| Look-up (match) and merge data | 22 May 2008 23:56 GMT | 1 |
I need to match a column on two sheets. Then use that match to pull over multiple other cells related to that matched cell. For example: Each Sheet contains employee IDs, but sheet 2 also contains there First & Last name, Date of Employment, etc. Each Data point on the same ...
|
| Multiple Criteria for SUMIF | 22 May 2008 23:41 GMT | 5 |
I'm having issues trying to sum data using more than a single criteria. My layout is as such; Col.A = Date Col.B = Type
|
| Grading Multiple Choice Exam | 22 May 2008 23:31 GMT | 2 |
I am setting up a spreadsheet for my students' answers to a multiple choice test. One of the things I want to do is see how many students got each question correct, and that is easy enough to do using COUNTIF. However, I am having a hard time creating a function that will tell me ...
|
| Using font elements as condition criteria | 22 May 2008 23:28 GMT | 2 |
Does anyone know how to use font elements like bold, italic, underline, etc. as criteria for a formula to return the value from a cell? I am trying to use bold $ values as the criterion for pulling the $ value into another cell. I can do the entire column but all I want are the ...
|
| if(and(isblank( formula help | 22 May 2008 23:25 GMT | 2 |
I have columns data ie: ad ae ag ah 12 23 34.00 0
|
| convert | 22 May 2008 23:16 GMT | 2 |
howcan i make that when i enter a number in colum A, ut should convert to text in colum B?
 Signature mf
|
| functions | 22 May 2008 23:15 GMT | 1 |
when i enter a number in a cell i want it should convert in the next cell to words
 Signature mf
|