Functions

How do I validate / verify the output from a spline curve
Is there a way to validate the Spline function to be Part 11 compliant? ... 23 Mar 2010 11:20

Link an entire Row with a Key Word
I have an excel document that has thousands of rows, but only 3 columns. I need to know how to link over the whole row of data if a single word is used in any of the colums. Is this possible? Here is an example if this was my spreadsheet: Date Color Flower 3/21 Pink Rose... 23 Mar 2010 12:30

How can I lookup 2 values in order to return 1?
Does anyone know if you can combine and IF, AND, and VLOOKUP. I need to lookup 2 different dates in a table and if both of those dates appear on the one sheet, I need the associated value to be returned. If this is possible, how would I do this? ... 23 Mar 2010 11:20

Publish interactive data to the Web using Excel (Problem)
Greetings, im having some problems with publishing interactive data to the Web using Excel. I followed the instructions at: http://office.microsoft.com/en-us/excel/HA010552771033.aspx I downloaded and installed the Office Web Components (owc11.exe) - I tried using both the Danish and the English version I... 23 Mar 2010 09:00

How to sort duplicates?
Hi, I have a Year to Date summary sheet with a long list of 18 digit barcodes in column F that increases weekly as data is sourced from our staffs individual weekly files. I want to be able to set up column H so that when the staff member accesses the Year to Date file and pastes in their latest weeks barcodes... 23 Mar 2010 09:00

How to generate a cell reference from multiple cells
For example, to acquire the cell reference 'c5' the C is generated by a formula in one cell, and the 5 is generated in a different cell ... 22 Mar 2010 23:02

Last number in a column shows in the total/summay line cell
I am looking for a formula that would have the last number listed in a column listed in the total or summary row of the spreadsheet. Column A lists the month of the year Column B lists # of files pending Jan 10 Feb ... 25 Mar 2010 16:16

combo box
Hi: I have a combobox which shows two values: name and age, after I choose "the value", the combo box just shows the "name". I need to be able to print both values. How can I tell the combo box to leave the 2 fields onscreen? ... 23 Mar 2010 04:33

Trying to convert mm/yy in text to Dec-07, it adds day & current y
I have a cell that has mm/yy = 07/09 , I want it converted to display Jul-2009 or Jul-09. But when I use DATEVALUE or format cell, it displays 09/07/2010 and does not let me display just MM:YY. Thanks ... 23 Mar 2010 07:52

Need help with macro for conditional formatting using number forma
I need help with a macro for conditional formatting cells using the number format. I can get it to work for bold font or cell color but not number format when I am recording it. For this I recieve the following when recording: ExecuteExcel4Macro "(2,1,""#,##0.00_);[Red](#,##0.00)"")" I tired re-writ... 23 Mar 2010 07:52