Hi,
I have a dataset with cells in different colours, where I would like to extract data from column A and row 2 based on the colour of the cell (see attached example). The example contains a table showing the scenario of the data I have and how I would like to present the extracted data.
I am not really sure how to go about doing this, please advice.
Bookmarks