Hello,
I have been struggling for a few hours now, but my back is getting sore. So finally I got wise and am asking for help. I think my question is that hard, but I am new to excel.
I want to sort different sets of data by giving three possible outputs.
Every cell with data needs to have the output '170'
Every cell with data including the character "h" needs to have the output '85'.
Every cell without data needs to have a blank output "".
More explanation in the attachment.
Thanks!
Bookmarks