I need to compare 2 columns and list the matching in 3rd column
ColumnA ColumnB
servera server1
serverb server2
serverc servera
server1 serverb
I need to matching in ColumnC
ColumnC [Expected output ]
servera
serverb
server1
Can you pls help with this..
Thanks
Hi
My SpreadSheet Has 2 Sheets:
Sheet-1
Server-Name [Col-A]
Serv1
Serv2
Serv3
Serv2
Serv4
Sheet-2
Server-Name [Col-A] Wave [Col-B]
Serv1 P1:W1
Serv3 P1:W1
Serv4 P2:W1
I need the output in Sheet-1 in Col-B
Server-Name [Col-A] Phase...
Hi-
My Spread sheet has 4 worksheets:
Sheet-1:
Serverlist [ Col A ]
Serv1
Serv2
Serv3
Serv4
Sheet-2: [ Col A ]
Pre-check-Failed
Serv1
Sheet-3: [ Col A]
Outofscope
Serv3
Sheet-4 [ Col A]
DeploymnetStatus
Serv4
I need to compare all the 4 work sheets and need output in...