# Extract data from a list to make an another summary list

1. ## Extract data from a list to make an another summary list

Hi attached is the excel sheet,in this sheet I have one table and its output. what formula I can use to get this output.  Register To Reply

2. ## Re: Extract data from a list to make an another summary list

Enter this formula in F5 and pull it to G5 and then down for list A

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(\$B\$5:\$B\$19)/((\$B\$5:\$B\$19<>0)),ROWS(A\$5:A5))),"")

For list B

J5 and copy down

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW(\$C\$5:\$C\$19)/((\$C\$5:\$C\$19<>0)),ROWS(A\$5:A5))),"")

in K5 and copy down

=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW(\$C\$5:\$C\$19)/((\$C\$5:\$C\$19<>0)),ROWS(B\$5:B5))),"")  Register To Reply

3. ## Re: Extract data from a list to make an another summary list

Thanks a lot, It worked.
What if I have to make list A & List B into a one list without the zero values.
Means "List" of unique A and unique B in a one column and unique A & unique B values into second column.  Register To Reply