Search : in
By :

Excel unique filters

Last answer on Jul 3, 2009 9:53:00 am BST koushik, on Jul 3, 2009 8:50:01 am BST 
 Report this message to moderators

Hello,
I need to filter unique values from 2 columns and place those value in a third one..
can any one help me

Configuration: Windows XP Internet Explorer 6.0

Best answers for « Excel unique filters » in :
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Download Excel Viewer Show
Download Excel Password Recovery Master Show
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an...
Graphic filters ShowFiltering Filtering consists in applying a transformation (called a filtre) to all or to part of a digital image by applying an operator. There are the following types of filters: Low-pass filters, which consist in attenuating image components...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

 mubashir aziz, on Jul 3, 2009 9:53:00 am BST
  • +5

You can try advanced filter on one column then easily extract these unique records to separate place ....... then you can apply on other column and get the results ......

Never ashamed to get or give Advise.
Muhammad Mubashir Aziz , Lodhran, Pakistan

   
Reply to mubashir aziz
Ask your question Reply
They need your help