I have a workbook with 4 sheets.  
Sheet 1 Column A allows users to enter a location name
Sheet 2 Column B automatically creates a dynamic drop-down of the Sheet 1
Column A data

There is data in Column 'A' (514 Records) that will also be in Column 'B'
(1600 Records), I want excel to compare ColA to ColB and remove from B the
duplicate information in A.  The end result should Column B without the
duplicate records from A. How do I do this?

I have been asked to show frequency using the responses to the question "what
is your age?"  The ages range as follows: Age
Question 1
27

If a set up a worksheet and highlight various cells in specific colours, is
there a sum function that will sum only the yellow cells?

i need to use excel in some calculatoin and i found difficult to write an
equation in polar as polar contain angle, so there is no way to write a polar
if there is no angle.

I deal with a large spreadsheet every day that auto saves itself and takes
ages meaning i cant use it while it is auto saving. is there a way to turn it
off. It is backed up every day so it is not essential,
Thanks

I was given a  very large database (6500 rows)  in excel format. I
need to change the way it is layed out.   Column A lists customers,
column B is their phone number(s).   Some customers have  2 phone
numbers so they are listed twice. (in 2 rows..1 row for Main phone

Aactually after i have update an excel sheet  i forgot to save it .. So when
i open it again it's still not updated what should i do to bring back my
updated one ?

not sure if anyone can help on this.
I have a worksheet that contains a header row.
When saving the data in this worksheet as a tab delimited file, excel would
normally add the delimiters to equal the longest record (row of data).

Bob Phillips very kindly solved my problem in the link below,
However when the code finishes a "file now available" message box appears
whenever the code attempted to open the file and it was read only.
Can anyone now tell me how to clear the event and prevent the message box

How can I express a formula that checks to see if a value is within +
or - 20% from another value?
Thanks

I created a spreadsheet with multiple worksheets under an earlier version of
Excel. Now I have loaded it into the latest version, and all but the first
worksheet seem to have vanished.
Also: I had created a macro under the old version of Excel which deleted

I copy a list of hyperlinks with friendly names into a spreadsheet.
However, I want to extract the underlying hyperlinks into their own cells.
Is there a function or a property I can use in a macro to address the
hyperlink behind the friendly name?

I want the worksheet to be protected, primarily to prevent users from
disabling validation. But, I also want users to be able to copy/paste data
which negates the validation process (ie., they don't get the edit/error
message) and the data validation is replaced unless they paste ...

Using a macro within a workbook, I am wishing to paste information from other
worksheets into an existing work sheet which already contains rows of data.
The macro should be able to determine the first empty row and then paste. I
cannot determine which function to use and how?