M
Mark Wolven
Here's my dilemma - I have 2 worksheets.
One has data that needs to be normalized (4400 rows) and 40 colummns.
The second sheet has the unique rows based on a 6 column key (2700
rows).
I want to populate the remaining 34 fields on the second sheet by
retrieving the values from the first sheet- frequently, there is more
than one match in a VLOOKUP. I can do an simple COUNTIF to determine
which records will have more than one match in a vlookup.
A few columns of the data is numeric, and a simple SUMIF does the
trick there.
However, most of the columns are not numeric. For example, there are a
number of boolean (true/false) columns. In this, the logic would be if
any of the matches is true, the new value should be true. There is
also a date column, where I'd want to retrieve the most recent date.
Finally, there are some text columns, and I'd want to concatenate them
together; the order is not really relevant there.
What are my options?
One has data that needs to be normalized (4400 rows) and 40 colummns.
The second sheet has the unique rows based on a 6 column key (2700
rows).
I want to populate the remaining 34 fields on the second sheet by
retrieving the values from the first sheet- frequently, there is more
than one match in a VLOOKUP. I can do an simple COUNTIF to determine
which records will have more than one match in a vlookup.
A few columns of the data is numeric, and a simple SUMIF does the
trick there.
However, most of the columns are not numeric. For example, there are a
number of boolean (true/false) columns. In this, the logic would be if
any of the matches is true, the new value should be true. There is
also a date column, where I'd want to retrieve the most recent date.
Finally, there are some text columns, and I'd want to concatenate them
together; the order is not really relevant there.
What are my options?