Calculated Column If Column Has A Value

[brent_milne]

I have a table in the data model with 5 columns which sometimes contain a value and sometimes are empty. I would like to add a calc. column that would show which columns have a value.

No. AA BB CC DD EE
1 344 555
2 666 444 5555
3 222 333 888
4 111 777 999
5 222 666

example: No. 1 has values for AA and BB so I would like the new column to show "AA-BB". No.2 has values for AA, BB and CC so would like to show "AA-BB-CC".

If had a little success with a huge nested IF(AND) function but it is way to large so I was hoping that somebody might be able to point me in the right direction to how I can achieve this.

[sweep]

Hi,

Assuming your table is A1:F6, on row 2 and copied down,

Please Login or Register  to view this content.

or for those who prefer their formula less readable and more compact....

Please Login or Register  to view this content.