I want to compare two columns namely column A and column B. Column A contains names that are dealing different people in column B. I am attaching a sample excel file. I want outcome like this
Column A Column B
Albert 5
John 5
sample.xlsx (8.2 KB)