Distribute Data With 2 Columns

[muhammad susanto]

hi all...

how to distribute this data below :

Excel 2007 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

D​

[/th][th]

E​

[/th][th]

F​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

2​

[/td][td]

data1​

[/td][td]

data2​

[/td][td]

expected result​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

3​

[/td][td]

70​

[/td][td]

70​

[/td][td]

70​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

4​

[/td][td]

180​

[/td][td]

45​

[/td][td]

180​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

5​

[/td][td][/td][td]

45​

[/td][td]

45​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

6​

[/td][td][/td][td]

45​

[/td][td]

45​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

7​

[/td][td][/td][td]

45​

[/td][td]

45​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

8​

[/td][td]

152​

[/td][td]

38​

[/td][td]

152​

[/td][/tr]


[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

9​

[/td][td][/td][td]

38​

[/td][td]

38​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

any helps much appreciated...

m.susanto

 

[NMa91]

Place below formula in Cell F3. Copy formula up to last row.

=MAX(D3,E3)