Hi,
You can use Conditional format.
If your data is in Column A, say A2:A51, then select all your data, starting
with the first cell.
Then choose Conditional format from the format menu
Select Formula Is from the first dropdown
Then paste in the following:
=COUNTIF($A$2:$A51,$A2)>1
Select the fo
Use CountIf function. see attached file for example. Any cells having value
more than 1 in column B has a duplicate record on its left.
_
"There are known knowns. These are things we know that we kno
Hello Mayank,
Thanks for the same. Yes it has somewhat solved my problem. Will check with
my peers to write a macro for the same. But Thank you very much for looking
into it.
On Sat, Nov 1, 2008 at 6:55 PM, Mayank Patel <[EMAIL PROTECTED]> wrote:
> Hi Steve,
> Please check the attached file. let
Its working well... could you pls let me know is there any other way
through forumula do the same function without using macro.
On Nov 1, 4:43 am, [EMAIL PROTECTED] wrote:
> Use below code.
>
> Sub DupFinder()
> Dim r As Range, t As Range
> Cells(1, ActiveCell.Column).Select
> Range(Selection, S
Thanks..
On Nov 1, 4:43 am, [EMAIL PROTECTED] wrote:
> Use below code.
>
> Sub DupFinder()
> Dim r As Range, t As Range
> Cells(1, ActiveCell.Column).Select
> Range(Selection, Selection.End(xlDown)).Select
> Set t = Selection
> For Each r In t
> v = r.Value
> If Application.WorksheetFunction.Coun
