Solved. Thanks for assistance once again, stay safe all.
*****
Hi All,
I need a few formulas that look at a date range (entered into two cells by a user) and then scan a list of names (that are on rows with dates in the same row) and returns the unique names that are found.
Then another formula that looks at the monetary values of them rows based on the names.
Example attached as I probably have not explained it brilliantly!
The cells in blue are where I need the formulas – I have manually entered in the results I would expect to assist.
Thanks BVG
Bookmarks