Forum Discussion
Match four columns and color code match's
Hey guys,
I have four columns of computer names, each on a different sheet. I want to export all these to a new column on a new sheet. Showing only unique values from across all those four sheets (dupes are merged) and then have a column representing each sheet that shows by color if its on that sheet or not.
| ExistsInAll | 1 | 1 | 1 | 1 |
| MissingInSomething | 1 | 0 | 1 | 1 |
Excel is really not my thing lol, so hope that makes sense 🙂
- The arrangement of similar data sets across multiple sheets is not ideal for analysis. However, if you're on 365, VSTACK can consolidate the data without much trouble. If you have a sample workbook you can share via OneDrive link or even include it in a message to anyone in this discussion, that would be a big help.
- I think its only us bud lol 🙂
But essentially its the export from three systems merged into one workbook with a sheet for each. What I'm then trying to do, pull one column (computer names) from each sheet to a new sheet and create a list of every computer across the three systems. Then use this aggregate to compare what's there, or missing from the other systems.
The data is very simple, its just three columns (different sheets) of computer names like this;
computer1
computer2
computer3
I did try the vstack in the application version of excel, but it didn't merge them (found duplicates) is this an online web app thing?- So looking though this guide,
https://www.techrepublic.com/article/excel-vstack-function/
Tried turning the column into a table, but again its just appending the column, not actually combining it.
I thought I might be able to use a pivot table and select the three columns like;
https://www.extendoffice.com/documents/excel/1966-excel-extract-unique-values-from-multiple-columns.html
But it doesn't workI also cant seem to post screen shots 😞
