I'm making a spread sheet and I have a list with different numbers with
some duplicates.
I want to get a list of each number. I'm using the LARGE Function, but
it still list the duplicated numbers, I do not want the duplicate

I have split apart date and time and need to add leading zeros so when I
concenate(SP) that it will add correctly.
I need real detailed instructions as I am a newby.
Thanks

Hello I have a problem with a validation procedure I want t
perform...Basically I have the following:
Amount Bought , Amount Sold, Buying price, Selling Price, Profit
Obviously the largest profit I could get is (Amount Sold x Sellin

Hi - I'm trying to create a spreadsheet which contains a column tha
calculates the number of days between dates and then a cell that add
up the total of the dates.
For the date calculation I have tried using =datedif(a1,b1,"d") - thi

While trying to demonstrate my super application at a different site,
all the buttons and checkboxes disappeared after being visible for only
a second.  When adding a button it disappeared too, showing only an
outline when autosize was set to true. :confused:

Hi - I'm doing a spreadsheet and am high-lighting certain rows which I need
to emphasise on the printed copy
but although they appear high-lighted (yellow) on my screen, this does not
show on the hard copy.  Am I perhaps doing something wrong or is it not

I need to insert a photo into a cell (a cell that has been merged btw)
based on the information in a cell (i.e. A1). This cell (A1) uses list
validation and allows one to choose from a list of names. What I want
to do is put a photo into a cell (say B1) from a folder (say

Hey, I need to just do a For...Next loop to cycle through a predefined
list (or range really).
Sort of..
For every cell in this list

I created an Excel spreadsheet and saved it to a network drive. When other
people edit the spreadsheet and try to save it they get a message saying the
file is set as read only. They are directed to save the file as another name.
The save dialog box comes up and saves the file as ...

I have a text file that is delimited with commas.  I get different prompts
depending on how I open the file.
Option 1 - If I right click on the file, then click open with excel, the
file simply opens and there are no prompts.

I have a worksheet with 3 columns: "month, Item type, quantity" :
month         Item Type          quantity
Jan.                1                        2
                     2                        1

Is it possible to have cell A1 be a hyperlink to a concatenation of what is
in cells B1 and C1?
Without VBA?
Thanks!

I need to do a write up for a controller/accountant business objective for
the accounting department.  What is a good format?

I am inserting a photo into a worksheet and sizing it to a specific
range when a name is chosen from a list validated cell. I am using the
following code:
*********************************

I would like to subtotal one single column, the amount, every eight lines.
How can I sum of the column for every eight lines?