Previous Topic Next Topic

Lookup unique text values with criteria

[Closed]
Report
Posts
1
Registration date
Saturday July 29, 2017
Status
Member
Last seen
July 29, 2017
 -
Hello,

Data as follows

cheque date tr code amount realised on
1/Jan/2011 164845 1000 1/Jan/2011
1/Jan/2011 154375 2000 1/Jan/2011
1/Jan/2011 164328 5000 1/Jan/2011
1/Jan/2011 268543 3000 5/Jan/2011
1/Jan/2011 547653 5000 5/Jan/2011
1/Jan/2011 754975 5475 5/Jan/2011
5/Jan/2011 164375 7000 5/Jan/2011
5/Jan/2011 553865 5333 7/Jan/2011
5/Jan/2011 642864 5000 7/Jan/2011
7/Jan/2011 653754 4000 7/Jan/2011
7/Jan/2011 764286 5754 7/Jan/2011
7/Jan/2011 753975 4678 7/Jan/2011
7/Jan/2011 653875 5477 7/Jan/2011
7/Jan/2011 763975 6478 7/Jan/2011
7/Jan/2011 764975 5377 8/Jan/2011
7/Jan/2011 648763 5484 8/Jan/2011

result

1/Jan/2011 5/Jan/2011
tr code amount tr code amount






result of date 1/jan/2011 should show the transaction code and amount if the realisation date if greater than 01/jan/2011