On sheet 2 column A you are allowed to enter values from a drop down, what I
want to be able to do on sheet 1 is count the number of times each of these
options appear.
Example

I have a spreadsheet with hundreds of hyperlinks - all in the same column.  
All of the hyperlinks have friendly names (i.e. the cell shows "Microsoft"
with a hyperlink of www.microsoft.com)
Problem is the spreadsheet now needs to be saved as a text file for import

I hope not being OT here.  I have a long list of names of files in a
column (obtained with JDirPrinter utility).  I would like to sort the
column in ascending 8.3 DOS format name.
That is, I need to create or use a function that takes as input a long

I have a spread sheet with 9 columns and an infinite possibility of rows
(however it currently has 107 rows).  What I would like to do is have each
cell in column b check the row above and below and if it finds the value in
either of the corresponding rows are equal then both ...

I have DDE linked data in excell. After the all calculations I have result
which is one cell. I need to see this "live" cell somwhere on the screen all
the time (Excell can be open in background) and I want to see this number
only or as less frame as possible - what is my ...

im using office 2000 sp3. when i try to open an excel file by double click
the file or right click the file then Open suddenly the excel open but no
workbook open.but when i open the file through the file menu of excel or
draging the file in excel, the file open.

Is there no way to get more columns by consolidating or
something like it?

I batch informaion, normally using the same information from Sheet 1 on Sheet
2 & 3.  I was wondering without cutting and pasting, is it anyway it could
automatically be done?

Hi Hope you can help!
Following on from a recent post I want to identify if a space has been
used in cell.  I tried using Trim() but found it leaves the space I
want to remove.

Im new to Excel and need o do a work place shift roster. I need to put in the
shifts people work eg: E (early) L (lates) N for nights ... but i also need
these to have values eg an E is 7.5 hours a N is 12 hours ... i need this so
at the end of each week i can sum the total hours ...

I tried searching for this solution in the entire forum but could not find
relevant answer.
I have excel sheets and I need to save certain ranges of this data into
access tables..The idea is to automate it as much as possible using VB Macro

Good evening:
Is it possible to count how many times a string of numbers appears in a
column? I am working on a project that has approximately 1000 telephone
numbers.  I need a count on how many times a particular number appears in a

I have a worksheet with three values, a category, a mean and a
standard deviation for that mean.  I want to plot a column graph with
the standard deviation set as the error bar for that particular mean
value.   How can I accomplish this?  Thanks

Imagine yo have a worksheet with 2000 rows.  Moving the right scroll
bar down takes you to the 2000th row.
But if you remove or delete the last 1000 rows, when you use the
scroll bar to move to the end of the worksheet, yo still go to the

Are these the same functions?