Please help in advicing a way to do the extraction from following table?
Record No. Status Validation
1.1 add gtc
1.2 modify gtc
1.3 cancel gtc
2.1 add time less than now
2.2 modify time less than now
3.1 add gtc
3.2 modify gtc
4.1 add time greater than now
need to extract data in exact match all 3 criterias of:
1) last record with same figure before decimal, output are 1.3, 2.2, 3.2
2) < cancel
3) validation column contains a mix of text and date/time value, output are
all gtc and time greater than now()
Advanced filter function can easily meet the 2) < cancel, but can't figure
out how can I filter 1) & 3)
Expected final result should be record no. 3.2 & 4.1
I would like to filter & copy result to a new sheet by using macro instead
of asking users to proceed steps from manu bar.
Thanks in advance.