Need to consolidate data, pulling data from rows that fit criteria

vfenix

New Member
Joined
Sep 9, 2014
Messages
1
Hey Mr.Excel users,

I have been trying all week unsuccessfully trying achieve the following in excel . There is around 1700 unique ID's that I need to do this for so it would ultimately have to be a formula that can be applied to each column. It does not matter which date is populated if there is more than 1 option for a column.

Here is the test file

Remove duplicates removes all duplicate information and does not really achieve anything. I have tried using a pivot table hoping that it would remove duplicate ID's and populate all fields. I have also tried using vlookup and index(...., match(....)) to return dates in the cells but this also does not work. I cannot think of anything else, does any one have any ideas that may help?

Thanks!
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

WarPigl3t

Well-known Member
Joined
May 25, 2014
Messages
1,609
insert a table with sample data and explain using cell refereneces so we understand.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,922
Messages
5,525,647
Members
409,658
Latest member
Yardcell

This Week's Hot Topics

Top