Vignesh Veerasamy
Member
Hi Excel gurus
This is related to one formula used to pull the vertical values to horizontal values.
Challenge is able to get the data but it is duplicated. I need to remove the duplicate and show only on value.
Formula : =IFERROR(INDEX($H$7:$H$66611,SMALL(IF($J2687=$G$7:$G$66611,ROW($G$7:$G$66611)ROW($G$7)+1),CEILING(COLUMNS($K2687:K2687)/2,1))),"")
Thanks for support.
This is related to one formula used to pull the vertical values to horizontal values.
Challenge is able to get the data but it is duplicated. I need to remove the duplicate and show only on value.
Formula : =IFERROR(INDEX($H$7:$H$66611,SMALL(IF($J2687=$G$7:$G$66611,ROW($G$7:$G$66611)ROW($G$7)+1),CEILING(COLUMNS($K2687:K2687)/2,1))),"")
Thanks for support.
Attachments

10.1 KB Views: 6