General

delete duplicates
I love this feature in excel, but it would be nice to be able to know which ones are deleted. Some of my records are more complete than others and I would like to ensure that the more complete record is retained. Is there a way to do this? ... 18 Mar 2010 18:59

PERCENTILE for a range
I'm trying to get a percentile for a range, and I've tried various ways of adding "=PERCENTILE" to the following range or restating the range. =SUMIF($A$2:$A$8000,"<=180")-SUMIF($A$2:$A$8000,"<-7") any suggestions? ... 18 Mar 2010 13:01

how do you print odd numbered pages
This solution looks like what I need, but where do you put this script? I have no idea what to do with it. Thanks in advance "Ron de Bruin" wrote: Hi For a code example see http://www.rondebruin.nl/print.htm#odd -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm ... 18 Mar 2010 18:59

Excel 2003
I have 1000 rows and 20 columns, and used the three variables in sort. Is there a formula that will insert a bold line after a particular column changes staying within the confines of the chart? ... 18 Mar 2010 17:48

I need to open a file in excel located on another computer
I am looking for a way to open and retreive information from a file located on another computer on the network. I know the user name and password to the computer, but can not seem to be able to retreive the information. Example: When I open excel on server with user name bob and password zebra I want to be ab... 18 Mar 2010 11:43

Subtotal function is grayed out - Excel 2007
I have a very simple table, why is the little Subtotal icon not lit up? I have a header row in Row 2 and about 200 rows down and the month names across the top. Simple. ... 18 Mar 2010 11:43

Deleting Duplicates in Excel - Databases
I have put my Palm Pilot contacts in Excel. The fields are not all the same and there are many duplicates. Not all same names are exactly identical. I want to run a formula that will automatically delete duplicates if just the names (first and last) are the same. Some info in the rest of the lines may be di... 18 Mar 2010 15:31

loop
I need help with a loop. After looping through the procedure, when the active cell is empty I want to exit the loop. Would you please give me the codes to do that. Thanks Cristina ... 22 Mar 2010 20:41

pick multiple items in data validation
Hi, I'd like to pick two items from the picklist. I'm using data validation with the list option pointing to a range of cells and so far it seems I can only pick one from the list. Anyway I get to pick two items or is there something else I can use? Any help would be greatly appreciated. Tx Grd ... 18 Mar 2010 16:39

formula referencing cell not updating
Hi I have a formula referencing a cell to give interest based on the amount in the referenced cell. When I put a numeric value in the referenced cell the cell with the formula does not update. When I click into and out of the cell the formula works. Does anyone know what this is? Thanks ... 18 Mar 2010 11:43