Search : in
By :

Matching the case in excel cell

Last answer on Aug 28, 2009 10:10:33 am BST Ashish, on May 1, 2009 7:32:45 am BST 
 Report this message to moderators

Hello,
I need to know is there any way where in I can match contents of two excel cell. for ex: A1 has the value A.K.Traders and cell A99 has Traders A.K.; is there any formulae which will show that this name is getting repeated.

Configuration: Windows Vista Internet Explorer 7.0

Best answers for « Matching the case in excel cell » in :
Excel tips : How to insert date In an Excel cell Show Excel tips : How to insert date In an Excel 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...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
Inserting an animated gif in Excel ShowInserting an animated gif in Excel To insert an animated gif image in an Excel spreadsheet, you must insert the image into a control. To insert the control, go to the View menu/Toolbars/Control Toolbox Activate the first button Design...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
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...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Spreadsheets - Cell Selection ShowCell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. Line Selection An entire line can be chosen by clicking directly on the line...

1

mikethedike, on May 1, 2009 7:44:05 am BST

The simplest of all is add filter to the cells that contain the data

awaiting acomments


Melisio Masvarenhas
mikethedike
India

Reply to mikethedike

2

Ashish, on May 1, 2009 7:52:07 am BST

Thanks for the reply but putting filter and then manually checking it for 20000 records is not possible. Is there any formulae which can show me the repetition?

Regards,
Ashish Ranjan

Reply to Ashish

3

 Vishal, on Aug 28, 2009 10:10:33 am BST

You can do this by either of two ways:
1. Sort the contents and in the blank column put the formula in row # 2 =if(A2=A1,"Duplicate,"") and fill down the formula till the last record... The word "Duplicate" will appear against the values which are duplicated.

2. You can create a Pivot table in another working sheet wherein put the Values in Columns and the count of Values in Data field... this will show you A.K. as column header in pivot and 2 as its count.

Reply to Vishal