Forum Thread

Excel Help

dealgate 6,348 1,085 June 13, 2016 at 10:04 AM
I printed out a directory listing on 3 separate systems and put each into its own sheet in a single excel file. I want to merge these onto a 4th sheet lined up so that duplicate directories are on the same row of the spread sheet and just blank spaces by anything that isn't duplicated.

example:

source1
dir1
dir3
dir5

source2
dir1
dir2

source3
dir1
dir5

combined
source1 source2 source3
dir1 dir1 dir1
dir2
dir3
dir5 dir5

6 Comments

1

Sign up for a Slickdeals account to remove this ad.

Joined Dec 2005
L10: Grand Master
6,348 Posts
1,085 Reputation
Original Poster
#2
fyi: those "dirs" were lined up under the proper heading but formatting was lost. Hopefully you get theidea.
Reply Helpful Comment? 0 0
E finita la cuccagna

Liberals want you to think like them, Conservatives just want you to think!
Joined Oct 2013
Bigger IS better! ;)
1,031 Posts
1,884 Reputation
Pro
#3
I havent used excel in about 10 years, but isn't this just simply going to 4th sheet where you want the data and type = then go click on where the data is that you want there?

for example (=Sheet1!A1)... go to sheet 4. in A1 hit = and then click on sheet 1, then click on the column and row you want to show on sheet 4, then hit enter.

hope this doesnt confuse you more Frown
Reply Helpful Comment? 0 0
Last edited by XXXtreme June 13, 2016 at 10:22 AM
Joined Dec 2005
L10: Grand Master
6,348 Posts
1,085 Reputation
Original Poster
#4
Quote from XXXtreme View Post :
I havent used excel in about 10 years, but isn't this just simply going to 4th sheet where you want the data and type = then go click on where the data is that you want there?

for example (=Sheet1!A1)... go to sheet 4. in A1 hit = and then click on sheet 1, then click on the column and row you want to show on sheet 4, then hit enter.

hope this doesnt confuse you more Frown
If it was exactly like my example, yep that would do it. But I have several hundred directories in 4 or 5 different systems and I need to be able to quickly line up and visually see the duplicate directories. I am running a script that creates a txt file that I import into excel and I need to be able to process the individual pages into one report.
Reply Helpful Comment? 0 0
Joined Oct 2013
Bigger IS better! ;)
1,031 Posts
1,884 Reputation
Pro
#5
Quote from dealgate View Post :
If it was exactly like my example, yep that would do it. But I have several hundred directories in 4 or 5 different systems and I need to be able to quickly line up and visually see the duplicate directories. I am running a script that creates a txt file that I import into excel and I need to be able to process the individual pages into one report.
Sorry, way too advanced for me. I hope someone else here can give you the answer my friend.
Reply Helpful Comment? 0 0
Joined May 2004
L42: The Ultimate Answer
1,440 Posts
993 Reputation
#6
This is a bit more manual than I would normally prefer, but might be okay for a one time thing.

Copy all directory values from all sheets into column A of sheet 4.
Use Excel Remove Duplicates button to dedup column A.
In column B, vlookup the value from A in sheet1, repeat in column C for sheet2, etc...

You'll get #N/A instead of blank, but could use an if to blank it out if you really wanted to.
Reply Helpful Comment? 0 0

#7
use winmerge to compare folders
Reply Helpful Comment? 0 0
Page 1 of 1
1
Join the Conversation
Add a Comment
 
Copyright 1999 - 2016. Slickdeals, LLC. All Rights Reserved. Copyright / Infringement Policy  •  Privacy Policy  •  Terms of Service  •  Acceptable Use Policy (Rules)  •  Interest-Based Ads
Link Copied to Clipboard