lmciciosr84
New Member
- Joined
- Mar 4, 2020
- Messages
- 27
- Office Version
- 365
- Platform
- Windows
- MacOS
I need formula help! In the chart below I need a formula that will look at the information and display them in numerical order and ignore the blanks. So example would be if B2=1 then F2=1 and if C2 is blank but D2 is 1 than G2=1. I want them to line up in order with FGH but be able to shift if one of the BCD cells is blank. I hope I explained that well enough and any help is appreciated!