Formula Help!

[lmciciosr84]

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!

 

[lmciciosr84]

ideally this list would be long consisting of at least 12 different accounts types.

 

[Scott Huish]

=SORT(FILTER(B2:D2,B2:D2<>""),,1,1)

 

[lmciciosr84]

Thats great exactly what I'm looking for, one more question what if there are other cells I dont want to be in the equation in between example

B

 

[Scott Huish]

=SORT(FILTER(B2:J2,(B2:J2<>"")*(MOD(COLUMN(B2:J2)-COLUMN(A1),3)=1)),,1,1)

 

[Peter_SSs]

Based on your image, another option is to use what is unique about the headers for the columns of interest. This approach has the advantage that if other columns are inserted (eg AMOUNT1, AMOUNT 2 etc) then this formula will automatically adjust to still just pick up the 'TYPE' columns.

=SORT(FILTER(B2:J2,(B2:J2<>"")*(LEFT(B$1:J$1,4)="TYPE"),""))