11 December 2007

How to select data from all same data?



You have database all many same data, but you want to select one data from all same data. You should do as below


1.Type fomular => if(B4=B3,1,"") on cel A3


























2.Copy formular to A4:A17


3.You will see digit "1" or " "


4.Copy A2:A17 and Phase value to A2:A17


5.Sort data


6.Data will display group "1" and " "
7.Delete data so you don't want out from sheet.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.