Functions

eliminate duplicates on a sheet
I have a list of 3500 names & addresses in an Excel workbook on one sheet and some are duplicates. How do I eliminate duplicates? ... 4 Apr 2010 23:41

Printing Forms
I have a spead sheet with data for individuals. I need to print forms with the data for each individual. What is the easiest way to start? ... 2 Apr 2010 08:12

shortcut has change or move so this shortcut can not open
I haveMicroscoft office exc 2003, i save my work to a dvd disk .. but now i cant open my file on exel, and now i cant even open it on the dvd disk i saved it too, when i try to open it it says ( problem with shortcut, the item that this shortcut refers to has been changed or moved, so this shortcut will no lon... 2 Apr 2010 09:18

Simple Consolidation of Worksheets
I scanned a huge database into Excel. It has around 300 seperate sheets. All I need to do is combine all the sheets into one sheet. Copy & paste would take DAYS! Any help? ... 4 Apr 2010 23:41

Measure on the date different
Hi, I had a huge file of aroiund 10 000 line. This 10 000 line only consist of 500 items. I wish to have an analyise a information. Example in the file it have items, order date, recept date and qty. Item A order 3 time on 1 Jan but recept 1 time on 1 Feb and 2 time on 15 Feb. Item A order 2 time on 1 Feb but ... 4 Apr 2010 09:20

Rules for locking controls
I can't quite figure out what is happening and why. I'm makng a sheet with a bunch of Form Controls Checkboxes. In the cells next to the boxes I'm added text be associated with the checkbox. I'm not using the text field available in the control because I want to be able to cut and paste and use other normal Exc... 2 Apr 2010 06:02

vlookup returns na
Hi all! Sheet1 contains the following: Col_H Col_O 302 33937 158 32840 3582 73345 39760 73455 4412 AGL92 2941 AHW92 136 30044 Sheet2 contains this: Col_H 34132 34332 33532 31032 34433 34633 33937 This is the function I use along Col_I: =IF(ISNA(VLOOKUP(H1;Sheet1!$H$1:$O $7;1;FALSE))=T... 2 Apr 2010 07:07

vlookup doesn't return value
Hi all! I have two sheets. Sheet1: Col_H 302 33937 158 32840 3582 73345 39760 73455 4412 AGL92 2941 AHW92 136 30044 ... 2 Apr 2010 04:58

can i short data with excel formula
if column A1 has any value and column A3 has any value and column A7 has any value , so can i short these value with excel formula..... ... 2 Apr 2010 03:53

Conditional formatting with formula (multiple criteria)
I have dates in one column to show the due date of an action item. In the "status" column to the right, I have whether or not that action item is "closed", "open", or "in progress." I would like to conditionally format the column with dates with red font if the date is in the past and the status is not "closed... 1 Apr 2010 21:22