combining formulas

  • Thread starter Thread starter Yolande Koval
  • Start date Start date
Y

Yolande Koval

7738 WE 080903 -737.65
7738 WE 081603 -340.06
7738 WE 081903 -393.96
7738 WE 082103 -68.29
7738 WE 082303 -248.88
7738 WE 082903 -62
7738 WE 083003 -176.5
7738 WE 083103 -173.04
310167 WE080203 -105.61
I am trying to say that if the first column is the same,
give me the second column in one CELL.
ex: 7738 WE 080903 WE 081603 WE 081903 WE082103 WE 082303
WE 082903 WE 083003 WE 083103
Is that possible.
Thanks
 
Try this formula
=IF(D12=D11,E11&F11,0)

e and f just reprsenting the two columns you want to
combine.

Dave Pierce
 
Back
Top