determinedtoexceed
New Member
- Joined
- Aug 20, 2019
- Messages
- 38
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: For itemA, "Cell E1" will show " Gap to 1st&Gap to 3rd" when B1=Gap to 1st, C1=No Gap, D1=Gap to 3rd
Thank you very much for your time~
<tbody>
</tbody>
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: For itemA, "Cell E1" will show " Gap to 1st&Gap to 3rd" when B1=Gap to 1st, C1=No Gap, D1=Gap to 3rd
Thank you very much for your time~
A | B | C | D | E | F | ||||
1 | itemA | Gap to 1st | No Gap | Gap to 3rd | |||||
2 | itemB | No Gap | Gap to 2nd | Gap to 3rd | |||||
3 | |||||||||
4 | |||||||||
5 | |||||||||
6 | |||||||||
7 | |||||||||
<tbody>
</tbody>