Question: How do i only put duplicate cell values from a list into another new list and their adjacent values?

Answer: Here is the formula for the duplicates.

=INDEX(A2:A9,SMALL(IF(COUNTIF(A2:A9,A2:A9)>1,ROW(A2:A9),""),ROW()-1)-1) + Ctrl + Shift + Enter

Here is the formula for duplicates adjacent values:

=INDEX(B2:B9,SMALL(IF(COUNTIF(A2:A9,A2:A9)>1,ROW(A2:A9),""),ROW()-1)-1) + Ctrl + Shift + Enter

INDEX(array,row_num,[column_num])
Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

SMALL() returns the k-th smallest row number in this data set.

COUNTIF(range;criteria)
Counts the number of cells within a range that meet the given condition

Related posts:

1. Create a list of duplicates where adjacent cell value meets a condition in excel
2. Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel part 2
3. Highlight duplicates where an adjacent column is in a date interval using conditional formatting in excel
4. Highlight duplicates where adjacent cell value meets criteria using conditional formatting in excel
5. Filter unique distinct list sorted based on sum of adjacent values using array formula in excel
6. Sum adjacent values using multiple lookup text values in a column in excel
7. Filter unique distinct values where adjacent cells contain search string in excel
8. Sum adjacent values from a range using multiple lookup values in excel
9. Create a list of distinct values from a list where an adjacent cell value meets a criteria in excel
10. Unique list to be created from a column where an adjacent column has text cell values