Hi Apologies if i'm a bit slow but i'm not clear on how this can be acheived. The data on the base data tab is fixed. As it is populated with the responses from the ms form that the engineers complete on their phone / tablet. There is no scope to change the form so i have to somehow acheive my results from that data. Really appreciate your time helping with this, I know excel is really powerful so am sure there is a way.
Bookmarks