display summary from multiple cells as a comment in cell

[alexiss]

Good evening,

Just wondering if there is any way to summarise a data, sourced from multiple cells in one row into a comment linked to an empty cell located in the same row?

The idea is, the user could get a quick summary of data presented in one row by 'mouseover' action in a cell

Maybe there are other ways of getting a quick summary without the use of comments?

Thanks,

 

[baitmaster]

welcome to the board

You can merge multiple cell values using ampersand (&) e.g. "= x & y", where x and y are cell references you want to join. You can also use =CONCATENATE() function

Comments would have to be written using VBA, but would be a complex way to do this task and I wouldn't recommend it