Thread: [Solved] Assign text string against groups of data
View Single Post
 
Old 04-08-2021, 03:02 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Could you re-attach your file with a few cells (anywhere) with the likes of this picture?
With just 3 possiblities the formula with hard-coded values in was manageable, but as the number of possibilities increases it gets more unwieldy. There are a couple of things we can do: (a) move the possibilities to ranges on a sheet somewhere, (b) be a bit cleverer with the formula!
2021-04-08_105138.png
Reply With Quote