One possibility:

Sheet3

A B C D 1 Product Jan Feb March 2 ABC 0 1 2 3 DEF 3 4 5 4 5 Product 6 ABC 1

Spreadsheet Formulas

Cell Formula B6 {=INDEX($B$2:$D$3,MATCH($A6,$A$2:$A$3,0),MIN(IF($A$2:$A$3=$A6,IF($B$2:$D$3<>0,COLUMN($B$2:$D$3)-COLUMN($B$2)+1))))} Formula Array:

Produce enclosing { } by entering

formula with CTRL+SHIFT+ENTER!

Excel tables to the web >> Excel Jeanie HTML 4

## Like this thread? Share it with others