compare columns return first duplicate only

D

Dee

I have 2 worksheets:

First worksheet, 1st column has department abbreviations, 2nd columns
has the formal department names names
Second worksheet, 1st column has abreviations, 2nd column contains
department nicknames, 3rd column contains floor space by the floor for
each department, 4th column contains the total workspace for each
department. (I did a vlookup to sum)

On a new worksheet
First column compare abreviations from first column in other
worksheets and return the nickname (and only first duplicate
instances)
and in the
Second column return the total workspace for the department (including
only the first duplicate value)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare columns pull unique values and first duplicate value 0
Mail Merge Help 1
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
lookup and return column number 2
I copied Visible Cells Only, but it pastes only the first cell 1
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
how can compare data between two worksheets? 2
list items from one table in another table based on value in first table 2

Top