General

create a separate list for unique records
I have a column of data with records may duplicate, how can i create a separate list in other area of the worksheet for unique records only, is it possible to do this without macro. Thanks a lot -- eva cheng ... 28 Apr 2010 06:09

Vlookup with corresponding two data (blank and non blnk)
Hi Experts, How can I get the results of vlookup where there are two corrsponding data in other sheet. One is blank and the other is non blank. I want to get the results of non blank cell and ignore the blank one. Thanks ... 28 Apr 2010 06:09

Macro Help - Jacob Skaria has previously been helping
Hi, I had alot of help yesterday from Jacob with the following macro, but am getting a 'run time error 13' when trying to run the macro, and i cannot see why. Any help much appreciated Sub OLApp() Dim objOL As Object, objApp As Object, lngRow As Long Set objOL = CreateObject("Outlook.Application") ... 28 Apr 2010 10:36

How do I filter the cells based in Fill color?
In excel when we highlighted some of the cells with color. Finally those unique colored cells want to filter in single step. ... 28 Apr 2010 08:22

Excel Jululian
Good morning please help can i create an index sheet for all my excels files (XLS) regrads ... 28 Apr 2010 02:52

mail receipient option in excel in disabel ... How to enabl it?
... 28 Apr 2010 02:52

Footer help please
Thanks Gord. Can you please lead me with baby steps to create the macro then save it? I also like to make the footer a default for all new sheets/books. How can I do this too? The footer to display the saved file name in 8pts. Cheers Ben "Gord Dibben" <gorddibbATshawDOTca> wrote in message news:a5v8j41m2... 27 Apr 2010 22:27

HOW DO YOU ALPHABETIZE A LIST OF NAMES IN AN EXCELL SPREADSHEET?
if anyone has used a list of names in an excel spreadsheet does anyone know how to alphabetise the names in the spreadsheet? ... 28 Apr 2010 02:52

Display Chosen Autofilter Value
Without going into VB, is there a way to display the chosen autofilter value? Column D1 is where I want to filter is located and it has 200 rows. Thanks. ... 27 Apr 2010 22:27

Regular Workbooks vs. Binary Workbooks
Can you tell me the difference between a regular Excel workbook and a binary workbook? We use a shared workbook as a tracking system for our department, and we often have conflicts, crashes, or other miscellaneous catastrophes. My manager was wondering if saving it as a binary workbook might reduce the numbe... 27 Apr 2010 17:57