Use Pivot as an option put the fields in row and you will have non duplicate values.
On 15 Feb 2009 05:42:14 -0000, 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 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 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 column H2:H265 there is a list > >> containing either "PC", "Laptop" or "CAD" corresponding to what type > >> of computer each individual in column A is using. I'm looking for a > >> formula or series of formulas that will tell me how many PC's, > >> laptops's and CAD's are being used but only counting one per name once > >> (hope that makes sense)." > >> > >> > > >> > > > > > >-- > >Best Regards > >Pooja Sharma > > > >> > > > > Regards, U r s... > > PUNEET NASA > > 9971987033 > > ¨`·.·´¨) Always > > `·.¸(¨`·.·´¨) Keep > > (¨`·.·´¨)¸.·´ Smiling! > > `·.¸.·´ > > (¨`·.·´¨) (¨`·.·´¨) > > `·.¸(¨`·.·´¨)¸.·´ > > `·.¸.·«*:·. > > .·:* > > *:·. > > *«*:·. > > .·:* > > *:·. > > > [image: > Shopping]<http://adworks.rediff.com/cgi-bin/AdWorks/click.cgi/www.rediff.com/signature-home.htm/1050715...@middle5/2705639_2677138/2680795/1?PARTNER=3&OAS_QUERY=null> > > > -- Jitendra Gupta Sr Accounts Officer, People Infocom Pvt. Ltd. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com If you find any spam message in the group, please send an email to Ayush @ jainayus...@gmail.com -~----------~----~----~----~------~----~------~--~---
