{=SMALL(IF(FREQUENCY(SMALL($E$6:$F$11,ROW(INDIRECT("1:6"))),SMALL($E$6:$F$11,ROW(INDIRECT("1:6"))))>0,SMALL($E$6:$F$11,ROW(INDIRECT("1:6"))),""),COLUMN()-COLUMN($AC$60)+1)}
The above formula displays 6 cell's values and eliminates any duplicates.  
3    7     8
4    7     8

how do I change the lay out of an excel spread sheet, I have name address
city state and zip in column A all the way down, in lines of 3 about 900
addressess. I want to change them to the top of the page across, with
name-street-city-state-zip. I cant seem to get it to do what I ...

I have 12 budgets (vertically) within a sheet.  Each budget has two
commandbuttons that sort two different ways.  One sort is by date due, the
other separates income and payments, putting income first.
GIVEN:  Total rows = 50 per budget.  The 51st row shows totals.

Normally when I chick on a spreadsheet it automacally opens. Now I get a blan
gray screen.  I  must have done something to a setting.....now I must go to
the open file icon, find the file and then chick on it to have it open.  How
can I fix this???

I am an instructor at a community college.  My students send me (hopefully)
completed Word 2007 and Excel 2007 files as part of their homework
assignments.  The files originate as partially completed exercise files where
students fully complete the exercise based on directions of ...

How do I add the numerical values in say the second column of a named range
(comprising say 3 columns and 20 rows) from row X to row Y, where X and Y
are the results of calculations in, say, cells A1 and B1?
Many thanks for your help

Dates Range need Help
Example
[A1 has date 3/1/08] [B1 has date 3/1/05} date between A1 and B1 will never
be more than 3 years. How do I get Excel list

I have column 1 consisting of about 3000 stock numbers. Columns 2. 3, and 4
have related information pertaining to those stock numbers in column 1. Using
the "find" feature, I "zero in" on a certain stock number and then have
access to the related info. I want, when the ...

I notice when a link is created between 2 workbooks, Excel assumes an
absolute reference.  Is there a way to set a default to assume a relative
reference when linking workbooks?
Thanks!

Excel offers to let your font align on the diag.  How can you make the grid
lines on that row match?

I have a command button that works fine in windows but it will not work on a
mack. Why? Thanks in advance!!

I am attempting to use the macro as written, from
http://www.rondebruin.nl/copy2.htm. I have tried using the "Copy a range of
each sheet" macro and also the "Copy from row 2 till the last row with data"
macro.  Each time I try to run them I get " Compile error:sub or function not ...

I have a spreadsheet with several sheets and would like to convert them into
a phone book directory, is this possible? and how would I approach this
project.
Thanks

I have created a brochure in Excel and save it to a thumb drive at work.
However, when I opened up the brochure at home to work on it using my home
computer, which is Excel 2003 the images are not displaying. Please advise

I have a macro that protects all sheets (and it does a few other things at
the same time):
I would like to include some code that make all the sheets scroll to the
top. I tried adding  "ws.Range("O1").Select" but that doesn't work.