The attached spreadsheet forum.ozgrid.com/index.php?attachment/55851/ has an array in cell M2:
(This is copied down to M5, with the Row number changing automatically)
The formula SHOULD look in Col B for all instances of the name in M1 (“STAFF”), and list the corresponding values from Col F into M2 – M5.
Unfortunately it isn’t working.
- The name “DR” occurs three times in Col B, but the array shows only two instances.
- Whichever name is selected, all the values are “0” and not the actual values in Col. F.
Any pointers received gratefully.