I'm trying to figure out which function to use to take information from a table on one sheet to display in a single cell in another sheet. The source table will have multiple entries with duplicates of those entries, but I need to display one value in another table to represent an individual number from that source table.
Example: How would I ask excel to display "X" from a column such as this into a single cell, "Y" into another cell, "Z" in yet another cell, and so on? The purpose being to grab data related to this entry to populate a set on another sheet. Basically a distribution of data from a single table into many smaller tables to organize data that will be used to make specific calculations.. Pivot table?
X
X
X
Y
Z
X
Y
Y
Z
Z
Bookmarks