Hello there, a two stage question on custom sorting.
Attachment 465130
Aims of the sort:
Stage one: “C” should equal the number of unique values of code “B” from linked to location value of “A”, both ar text strings but must return a number as the total unique values present.
ie: if three values of “B” are are associated with a value of AA01 in “A” this would = 3
Stage two: “E” is the summed score of SR2016 values and should equal all values of “D” that are associated with a unique location value in “A”
ie: if three "B" codes are present in location “A3” this would = 3
what would you lovely people recommend to start tackling this logically?
Many thanks in advance!
Mr ferret ~
Bookmarks