Dynamic filtering data Macro.

[Pradeep66]

Hi Folks, 

I am trying to write a macro for dynamic filtering of data. 

input data:

Date	File Name	Max File number Expected
11/23/2022	file1	1
11/22/2022	file1	2
11/22/2022	file2	2
11/21/2022	file1	3
11/21/2022	file2	3
11/21/2022	file3	3

now I need to output my data like this with the help of a batch macro.

Date	File Name	Max File number Expected
11/23/2022	file1	1
11/22/2022	file2	2
11/21/2022	file3	3

[Felipe_Ribeir0]

Hi @Pradeep66 

One way transforming your input into your output, to do this you dont need a batch macro:

[binuacs]

@Pradeep66 One way of doing this with the batch macro