Sep 28 2021 06:13 AM
Hello,
I would need your help to find the right formula to use to analyse a set of data as follows:
first excel file is made of codes (column A) and for each code I have cities (column B):
001 - ROME
001 - MILAN
002 - ROME
003 - ROME
003 - MILAN
in the second excel file I have the unique list of codes (column A) and I need to differentiate in two different columns when I have ROME=YES (column B) and when I have MILAN=YES(column C):
column A column B (ROME) column C (MILAN)
001 YES YES
002 YES NO
003 YES YES
I cannot use a vlookup, what kind of formula I can use?
Thanks a lot
Sep 28 2021 07:17 AM
@FrancescoCavazza Perhaps a pivot table with some custom formatting will work for you. See an example in the attached file.
Sep 28 2021 07:19 AM
Sep 28 2021 08:00 AM
Solution