Distribute Data With 2 Columns

[muhammad susanto]

hi all...

how to distribute this data below :

Excel 2007 32 bit

	D​	E​	F​
2​	data1​	data2​	expected result​
3​	70​	70​	70​
4​	180​	45​	180​
5​		45​	45​
6​		45​	45​
7​		45​	45​
8​	152​	38​	152​
9​		38​	38​

Sheet: Sheet1

any helps much appreciated...

m.susanto

 

[NMa91]

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

=MAX(D3,E3)