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
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 one is Duplicate data
Use pivot table and put name in rows and field H in columns then count the
number non blank cells for pc laptop and cad
On 2/11/09, stuartjohnw...@googlemail.com
wrote:
>
>
> Hope you can help. In column B2:B265 I have a list of names, each
> name appears about 4 time each. In column H2:H265 th
one 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 one is Duplicate data and Zero is sigle data which we req.
On Sat, 14 Feb 2009 20:24:15 +0530 wrote
>for this you can create Pivot chart...If you don't know how to crea
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
wrote:
>
>
> Hope you can help. In column B2:B265 I have a list of names, each
> name appears about 4 time each. In colu
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 = myChe
