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.