Using offset to align data?
The formula below, starting in row 2, and assuming that account is in
column A and the OUT, IN, Between etc data are in column B
=IF(UPPER(B2)="OUT","OUT",IF(AND(OFFSET(B2,-1,1)="OUT",UPPER(B2)<"IN",UPPER(B2)<"BETWEEN")," OUT",""))
results in...
Company1......OUT.................OUT
Company1......OurProduct$.....OUT
Company1......TotalMarket$....OUT
Company1......Share%............OUT
Company1......IN....................
Company1......OurProduct$....
Company1......TotalMarket$...
Company1......Share%..........
Company1......Between.........
Company1......OurProduct$....
Company1......TotalMarket$...
Company1......Share%..........
Company2......OUT...............OUT
Company2......OurProduct$...OUT
Company2......TotalMarket$...OUT
Company2......Share%..........OUT
Company2......IN...................
Company2......OurProduct$....
Company2......TotalMarket$....
Company2......Share%..........
Company2......Between.........
Is this what you are after?
Ken Johnson
|