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. So each duplicate will have this...

hi, i build a line chart and i don´t want excel to show the zero values. the first thing i did was to include an if function to substitute zero with blank...

when i open excel and click once on a single cell, the cursor starts to select everything when i move the cursor as if im holding down the left click button....

I'm using xl 2000. I want to place several tables on the same worksheet. Is it possible to change column widths of a table without affecting the column width...

Hello, I need helPPPPPPP. I am trying to setup a spreadsheet with the following format and I am not sure how to in put the calculations. Here is what I have...

When I select cells to copy or paste I can't really see which cells are highlighted because I probably have something set wrong. I would like the cells I...

I'm a worship leader, I need to create an index for the songs in my notebook. I'm using Excel (I'm an absolute beginner, just got it yesterday) and need to...

Hello, Many thanks in advance! I know very little about Excel....but here is what I thought was a simple exercise: I wanted to sell some stock. Since the...

I have Word, Excel, and Outlook 97. What is the best program and easiest to use to create a contact management list/database. I will be phoning my contacts...

Hi! I do not know Excel but would like to use it to track my blood pressure. Basically I need to keep track of three readings per day: (AM, MIDDAY,...

Hi, I recently had to reinstall my Excel program on a new disk. I now get a message I haven't seen before. When clicking on a document in the Recent...

I run XP Home with Office 2002 I have just installed my programs to a new machine. Excel is behaving differently on the new machine: Observed so far: i) I...

I am trying to use the parameter query to return data from an access database to my spreadsheet. I have it working but I can not get it to return to more than...

I am looking for a time card template that tracks vacation, regular & overtime hours

Hi experts I would like to paint cell depending it's content. The content is chose from a list. For example: A cell had a list of values: Value 1 and Value...

is there a formula to put the work "active" in all cells in a column automatically unless a date is entered to indicate inactive? Thank you Katherine

New to all this, bit confusing. I'm trying to find find cells and once found move them, there is no problem finding a cell by matching the text but it falls...

how to use the "IF formula" so that eg. if the calculation is less than "12" I would like the cell to show 12 if the answer is more than 12 the result will...

Hey, Got a column I wanne multiplie by 2. It goes from I6 to I2237 so it takes some time if I gotta do it manual. Each cell gotta be multiplie by 2. Hope...

Hi All, i have a question about finding text. if you have a list of text in a row "A, B, C, D, E, F...etc" in sperate cells, with blank cells in between,...