Algebraic Function How would you solve a function with input 1 output 8. Then input 2 output 14. next input 3 output is blank then input is blank Output is 24. the input is blank and the out put is 28. Finally, the input is 6 and the output is blank. ... 27 May 2010 18:11 Parallel Box Plots Hi, I was wondering if it was possible to create parallel box plots on Excel 2007.. ... 28 May 2010 14:53 Fix an image to a cell in Excel I can add images to a s'sheet but wondered whether it was possible to fix the images to a cell, so that when the data is sorted the images will move with the sort. I'm using Excel 2003 SP2 Thanks ... 27 May 2010 18:11 Sumproduct using multiple sheets Hi, I am using the sumproduct formula for multiple sheets. Below are my data which is contains from sheet1 to sheet3 when i use the sumproduct formula for in one sheet =SUMPRODUCT((A1:A9="Mark")*(B1:B9="Automatic")) it gives me the result =3 and if i use the formula in 3 different sheets it will give me the res... 27 May 2010 18:11 pick up particular number from a table Hi, I have below table: A B C D E 1 04/10 04/10 04/10 04/10 2 AB YZ AB YZ 3 MARY 45 56 16 62 4 PETER 50 48 84 45 5 JOHN 60 78 65 50 How can i get number 45 at B3 when I have reference 04/10, AB, and Mary in another sheet? thanks a lot! -- Lowan ... 27 May 2010 18:11 Sumif/SumProduct/lookup question I want to insert subtotals only for items containing at least two specified costs. A B C 1 Item Name Cost Title Cost Value 2 Item 1 Cost 1 5 3 Item 1 Cost 2 3 4 Item 1 Cost 3 4 5 Item 1 Cost 4 ... 30 May 2010 18:42 Extract numbers from a string of text Need to extract just the numbers at then end of the string. 1300 · Inventory:1305.05 · Inventory Business to Business:1305.10 · B2B Inventory Contra 1300 · Inventory:1305.05 · Inventory Business to Business:1305.15 · B2B Inventory 1300 · Inventory:1310 · Inventory - Raw Materials:1310.05 · Inventory - Flav... 27 May 2010 18:11 ISNA and ISERROR functions Hi. I need some samples of ISNA and ISERROR functiones. Is there a web where I can download samples of them? Thanks in advance Regards, Emece.- ... 27 May 2010 18:11 Date Formatting I receive data everyday with the dates in the following format - 1/12/2025 (dd/mm/year), however I'm trying to format it to the following format- 01-Dec-25. The option is available under formatting, but the majority of the dates in the column I select don't format properly. I can't figure why this happens... ... 27 May 2010 22:33 Date separator Dear Expert, I was wandering how to make exel separate dates. For example: In column A I have a date 2010 04 01; in column B I have number 23 ; in C number 25. In rows from 1 to 10 I have the same 2010 04 01 date with the different numbers in columns B and C. In rows from 11 to 20 I have different date 20... 27 May 2010 20:23