| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inconsistent Sorting | Excel Discussion (Misc queries) | |||
| macro | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
Threaded Mode
