software

I am wondering about the integration between Excel and an Oracle database.

I have an array formula that is supposed to return a list of the unique
items from another range (I6D in this case). The Array Formula is as

I would like to use a function to create a sumamry sheet from a number of
worksheets in a work book.

Hey, I was wondering if you could all help me out. I'm trying to use the
vlookup command to give me a sum of values that meets my requirements. Right

I want to separate names, example, Doe, John D., that are entered in one cell.
How to separate them into 2 or 3 cells?

I would like to convert cells with degrees at 'Minutes' format. such as 43°
22', to decimal format such as 43.367.

Have worksheet with 120 fields that each have a comment in top row of 4
header rows. Comments contain definitions and/or lists of values for each

I have a bunch of percentages that are on a 100% scale, but i need to create
a formula in excel that would scale it down to a 60% scale.

I want to be able to save the excel workbook file name with each worksheet
within the workbook per tab name respectively, can this be done?