I have receive a spreadsheet with a created worksheet function in it. How do I find out what that function is trying to do?

I have a list of names in a column and I'd like to sort them alphabetically.

I'm new to this, so perhaps I'm missing something obvious. I'm reading the "Excel 2002 Inside Out" book. In the section "Using Relative References in Named...

I have a set of xls files that contain data I would like to import into another xls sheet, however the file that I need to import from will depend on a date...

I do not know any VB but I have experience with C and Java. I have data sets on a worksheet that are from different days, which are then orgranized into one...

I do not know any VB but I have experience with C and Java. I have data sets on a worksheet that are from different days, which are then orgranized into one...

Hello. I'm using Excel 2003. I have data in the following format: Product Quantity Price Extended Price product a n ...

I would like to make numbers in each cell after I have calculated their value with a formula. Currently I have to calculate the value and then re-type all...

i am using excel 2000. I want to know if you can use an IF Statement to run a macro. E.G If a cell equals 1 then run a certain macro

Hello, I'm getting a #REF! error with your formula (my original message and your response is below. I have assumed that Patterns is a name which refers to...

Hello, I have a calculation that can take about 20 seconds to complete. I then need to use the answer as an input to another program outside of Excel. The...

Hello, I have 8 columns of data that extends to over 1000 rows. One column contains different patterns. I would like to copy the data in the cells of two...

Hi All, My problem is as follows: In my spreadsheet I have records as follows Customer number| title | First | Last 1234 Mr John ...

Hi all! I work with Excel functions and I want write descpription for the function and for its parameter (like the Excel's Sum() function). For the function I...

Hi, I have found a way to link to Excel 2003 in Sql 2k5. But I cannot link to a Excel 2007 one. In the link to Excel 2k3, I used the "Produtc String" equal...

this formula works "=VLOOKUP($I$4,'Data Entry'!$A:$AJ,36,FALSE)" but when the 36 is changed to any higher number it does not work. example...

I'm trying to create a Formula that will search within multiple columns and lineup by rows any data in the the columns that are a match. As an example data...

Using RAND or RANDBETWEEN to randomly select a number from a specific range allows a new random number to be calculated when any other cell is filled and...

Tried every combination I could think of, here's what I need for for a solution for ONE cell: If D1=2 and D3 is 14 then D5=0 , If D1=2 and D3 is 14 then...