Variable data Data pull out request

Hi,

Can you post your example file in excel format instead of .jpeg? Images are impossible to edit and nobody wants to retype the whole thing for you.

Make sure your expected outcome is mentioned (mock up) in the file you upload with enough explanation.

Hi,

I hope I was able to attach the file properly, thanks for the advise.

Cbatrody,

First of all thank you for your assistance, it means alot to me.
If it is not to mutch of a trouble, can you kidly break down the formula for me? I mean I would love to uderstand the logic here.

Tanks again mate

Hi SpongeMind,

The trick here is to identify the unique rows first along with dates in Column D - created after 01/04/2017. I've added a helper column for this with the help of below formula.

Please Login or Register  to view this content.

It's a simple COUNTIFS with IF condition added to remove duplicate values - COUNTIFS(A$1:A2,A2,B$1:B2,B2,C$1:C2,C2,D$1:D2,">="&$I$14)

Please go through the below URL for further help on COUNTIFS function:

https://support.office.com/en-us/art...c-aa8c2a866842


Once the unique values are identified, they need to be listed in columns H to I. I've used INDEX with SMALL(IF array. Please go through the below URL for help on these functions.

https://fiveminutelessons.com/learn-...le-values-list