Use Pivot as an option put the fields in row and you will have non duplicate
values.
On 15 Feb 2009 05:42:14 -, PUNEET NASA puneetn...@rediffmail.com
wrote:
on e way to do it.
take data in another sheet. and sort the data in asc order and run a
formula
if (a1=a2,1,0)
remove 1 becasue
for this you can create Pivot chart...If you don't know how to create then
you can send a file..so that I can help you in this case.
On 2/11/09, stuartjohnw...@googlemail.com stuartjohnw...@googlemail.com
wrote:
Hope you can help. In column B2:B265 I have a list of names, each
name appears
Hi Stuart.
this may help you.
Sub DuplicateRed()
'color cells in red for duplicates in selected range
Application.ScreenUpdating = False
Rng = Selection.Rows.Count
For i = Rng To 1 Step -1
myCheck = ActiveCell
ActiveCell.Offset(1, 0).Select
For j = 1 To i
If ActiveCell =