Google Spreadsheet Post #2486
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Aug-15-2018
question by: Krishna Goje
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/WjpB238Fnxc;context-place=forum/docs
Multiple strings comparison
Hello All,
I need a small help from you, what i want is compare the 2 different cells which has multiple strings and return the unique/mismatched values from both the cells.
Say:
CellA : Dilsukhnagar, Hyderabad, India
CellB : Gayathri Nagar, Hyderabad, India
CellA : Dilsukhnagar, Hyderabad, India
CellB : Gayathri Nagar, Hyderabad, India
Output : - Dilsukhnagar
+ Gayathri Nagar
+ Gayathri Nagar
Output must be in a single cell.
Any help will be appreciated.
Thanks,
No comments:
Post a Comment