I have a list in Column A of a mix of 100 numbers between 1 and 9.
How do I create a report/table/list/??? showing me how many entries there
are of each number?
e.g.

on my excel file I have 2 sheets
First Sheet (Sheet 1): User Enter Data , on thsi sheet I
have a cell where the Validation is a liste, so on this
Cell I have a comboBox where the user can choose data

i am drawing a graph in excel,
to my disappoint,
the axis can not show the exact length of the x-coordinates.
why, and how  to solve the issue.

Hi Gents,
Hoping this makes sense...
I have a list of team names, where the results of the list were create
by a formula: =IF(F2>=D2, E2, C2).  The score of the game determine

I have on a workbook a lot of links but each time I click on one of them the
workbook close and I need to reopen it for the next link and again it close
itself after opening the WebPages. How can I keep that workbook open ? I
don't want it to close each time I click on a link.

I had customised toolbars in Excel that disappered when Iopened two Excel
windows at the same time.
View > Toolbars > Customize > the Commands Tab
Iwould like to know how to avoid this from happening again and how to save

I just wanted to ask for help or any suggestion regarding this matter.
I'm running Win2000 Server & Professional and I notice from one of the
PC that when I open a network excel file and save it, it will prompt
and it will create a " xxx0000" file. I tried to look for the updated

Using Get External Data --> Database --> Excel File
it's not showing the cells having data in %age format. Even afte
changing their format to General its not showing the data.
Also their are 3 coloumns having numeric data, out of which its showin

I am plodding along on a self imposed training exercise
for Excel, with a job interview within my company later
this week.  The spreadsheet data I can suffer through, but
how do I change my y values and x descriptions?

Hello, thanks in advance for your help!
The Problem: I would like to know how to have data from one work sheet
placed into another worksheet after pressing a "button" of some sort.
The Specifics: Worksheet A has multiple cells calculating the various

hi, I have a pivot table which has a query in access as record source. the
problem with this table is that I can't get the data to be accurate to 2
decimal places.
when I tried exporting the data from access to excel (using office links,

Is there a way to have the row height adjust automatically to display all
the lines of text that may be in a particular cell ?
I have "WRAP TEXT" selected from the Alignment menu when you format the
contents of a cell but this does not automatically adjust the row height to

I have a list of 100 items in Column 1 with many duplicates.
In column 2 I wish to show how many times each item appears in the column.
So each duplicate will have this same number beside it in column 2.
What function/facility do I research to find how to do this?

I can't figure out how to set up VLOOKUP formula with 2 variabl
elements.
After the intial formula runs in the specified cell, I want 2 element
changed: the location of the result and the lookup value.

I have configured a spread sheet to have drop down lists. But I want the
ability to put in other data other than the choices from the drop down lists
to give the user a little more flexibility in filling out the form. Is this
possible and if so, how do you do it?