Forum Discussion
Excel help sorting.
In that case, this should demonstrate the formula works. It may be a couple of steps too far for implementation but, hopefully, of interest.
- As you can tell I’m not super advanced with excel. So bare with me. I have the drop down list on H3 ( this is where the accounts are listed.) Do I need to put the formula too left corner cell where I want the result displayed?
You are correct. That relationship between the formula location and the placement of the results is the key feature that makes spreadsheets an implementation of functional programming, as opposed to imperative programming. Each value is determined by its definition (associated by sharing a cell) and it cannot change as a result of the state of the calculation elsewhere.
You may well find OliverScheurich's implementation easier to follow. He has written out tests for the 3 columns explicitly and used '+' as the equivalent of an 'OR' operator acting row by row. All I have done is to use more modern functionality 'BYROW' to run through the dataset row by row and embedded the 'OR' within a Lambda function so that it can accept the row ranges from 'BYROW'.
I might even speculate that the more experience one has of traditional spreadsheet working, the harder the move to modern Excel. Others may be of a different opinion!