Simple EXCEL worksheet function I am creating an EXCEL worksheet of people's names, company and location. I need to do a simple sort on name. When the list goes beyond 250, the sort function stops working. Is this a limitation of EXCEL? If so, can I continue the list on "Sheet 2", "Sheet 3" etc and still be able to sort through all the l... 12 Mar 2010 13:56 How to accomplish this 1 name amount 2 Paul 200 3 John 100 4 Mary 250 5 Paul 100 6 John 300 After entering above data w/sheet should save this data like below 1 name amount 2 Paul 300 3 John 400 4 Mary 250 How to ach... 13 Mar 2010 14:14 how do I use color in drop down list in Excel I am creating a drop down list with three items in it. I would like for each item to have it's own color. Is this possible? -- TroyB ... 12 Mar 2010 15:05 Too Many Worksheets AGREE!!! AGREE!! "rnvhill" wrote: I am stuck with the number of worksheets, but can the worksheet tabs be 'stacked' so that there is more than one row of tabs along the bottom? As an example when I go to Win XP Home Display Properties, I have two rows of tabs to select from in the window, one ro... 12 Mar 2010 12:49 count how many times same names appear in a column I have a column of names with patients who has blood transfusions . For example Paul Smith with appear 3 times ie he had 3 units of blood transfusion. What I need is total number of patients who has blood transfusion. The list is about 1400 cells long. Can anyone help please? ... 12 Mar 2010 12:49 Excel Conditional Formatting for Percentagrs I'm stumped! I have a pivot table with monthly performance compliance percentages. I'm trying to use Conditional Formatting with Icon Sets (3 signs) and using the following Rules: 90% and greater = Green 80% to 89% = Yellow Below 80% = Red The applied color of the signs just don't seem to comply with value of... 12 Mar 2010 12:49 Last day of last month =DATE(YEAR(TODAY()),MONTH(TODAY()),0) works on Excel 2003 if you don't want to reference another cell w/ a date. "Jim" wrote: Hello, In cell A1 I will have the due date of a bill. For this example let's call it 9/20/2009. Can you help me with a formula that will give me the last day of the pr... 12 Mar 2010 13:56 Adding an apostrophe to a column of numbers Hello, I need to add an apostrophe to each cell in a long column of numbers. I do not want to format them as text or format them as custom - our system requires the apostrophe at the beginning of the cell. My question is - is there a way to format one cell with the apostrophe and then copy that apostrophe down ... 12 Mar 2010 17:20 2 excel workbooks open up from 1 file; named :1 and :2 - why? We have a workbook with multiple worksheets. Many users view and add data. Now when we open the workbook, there are two excel files attached. First file called filename:1 and second file called filename:2. How do we "undo" this? Just want one workbook. Thanks. ... 12 Mar 2010 11:41 xls data validation question 2 i am able to create a list "drop down" through data validation. my problem is my choices are sentences, and i can only use so many characters in the list. i run out of characters before i input my sentence choices. is there a way to allow more/unlimited text??? ... 12 Mar 2010 11:41