Hi all,
I need some help regarding conditional filtering. I tried to look for solutions but was not able to find any.
Basically, I need to filter based on a hierarchy key on column Year and Type. For example in this, A is higher than and F is higher than O. E.g. for 1234 in 2022 since both O and F exist, we just want F. However, in 12345 2023, only O exists so we will take O. X and Y are misc columns whose data should be kept. At the very end, only one row for each year should exist.
Any help is appreciated.
Solved! Go to Solution.
@np123 one way of doing this with the batch macro
Awesome, how did you specify which "type" is outputted?
@np123 Inside the macro i took the min value in the given year, you can change it according to your requirement
In this case it takes the lower ASCII value, is that correct?
Excellent, this is a good start to help figure it out thanks.
@np123 yes