Hi there,
I have a problem but am really unsure of which function to use to get the correct data, I have tried a number of different approaches to no avail.
The spreadsheet contains a lot of data but too try and cut it short I need to this:
I have a load of customer ID's in Col A.
In Col M...