Hi all
I want to extract unique values based on conditions and put the result in a new cell.
In the attached workbook (tab : data) I would like to extract a unique area for each grower,block,section & year.
I want this result in the first line in and 0 in the rest where the conditions are met. See tab: desired result.
I am using Excel 2019.
Thank you in advance.
Regards
Bookmarks