Excel filter problem

Help Activities
, , , ,
1

Hi everyone,

I have a scenario and i got struck in filtering the excel I’m unable to understand the conditions
Can anyone help me.
I’m attaching the flowchart and the excel file

tmp_3027719f-5eed-48a0-b54c-d876e7f92aa4
tmp_3027719f-5eed-48a0-b54c-d876e7f92aa4827×1169 35.5 KB

Data for filter.xlsx (9.3 KB)

2

Hi @Learner007 ,
What’s expect output?
Can you explant chart?
rhombus-> is condition we have true/false step
in here I want to know step is true or false and else step, like first step
I’m doing with your file, please confirm to continue

image
image1383×727 40.7 KB

3

Hi @Nguyen_Van_Luong1 after applying all filters i need to send that filters report email that’s it.

4

after applying all filters i need to send that filters report email that’s it.
Yes, I want to know filter step, can you check flow, in condition, if yes , what will we do, else what will do
Explain your conditions more clearly, what we need to do about it

1
1665×726 73.2 KB

I think this process is simple with if/else, but I need clear requirement

5

@Nguyen_Van_Luong1

In if condition:

  1. i need to filter status column with Authorised, declined etc.
    If it matches - next step i need to Check date column with today date. If we minutes today day with Excel date. If the difference is <=22 months i need to pick those records.

1.1) Else : here i need to filter same status column which are blank or null and copy that data.

2)if condition:
Field1, field2,field3 any one column should be greater than 20 then i need to pick that record.

After this i need to take the lowest value from those columns.

  1. if condition:
    Highest value from column is < 25 . Copy data

  2. if condition:

Number column value should be >=24. I need apply that filter.