Dear Pros,
Please help me with 1 function that can determine whether there is any gap by item name.
example1: For itemA, "Cell E1" will show "No Gap" if b1,c1,d1 all are"No Gap"
example2: For itemA, "Cell E1" will show "Gap to 1st" when b1 ="Gap to 1st" while C1 and D1 ="No Gap"
example3...