condition results for multiple Columns sorted and compress?

[Harry0]

If there a way to show results under condition with a certain order?
The results for column 2 to be in oder based on column 3 if column 1 has a certain day to be column 4.
I do not have a example of it I guess copy and past it.

Col 1 Col 2 Col 3 (Col 4 result)
Mon 10 5 20
Tue 50 1 40
Mon 40 4 10
Wed 30 6
Mon 3
Mon 20 2

one way to sold only column 2 is to use this
=IFERROR(INDEX(B$1:B$7,MATCH(SMALL(B$1:B$7,ROWS(AE$4:AE4)),B$1:B$7,0)),"") but the rest I have no clue.

 

[Luke M]

I'm afraid you lost me, I'm not sure what part of your post is what you have, and what part is what you want. Could you upload a workbook showing a "before and after" type scenario?

 

[Harry0]

It seems this site does not put it in a proper order so I am uploading it then. I have no code and the end part I stated was only a partial suggestion.
column 4 is the after and the rest is before.

file uploaded which might clarify.
Thanks

 

[NARAYANK991]

Hi ,

Is it something like this ?

Narayan

 

[Harry0]

Yes like that.
But arrays seem to mess up to give duplicates sometimes or does not work as it should when dealing with a long list. For example see sheet2 that is attached.
Thanks

 

[NARAYANK991]

Hi ,

The problem is not because there are duplicates or because the list is long ; the reason has to do with the values themselves.

See the file now.

Narayan

 

[Harry0]

So the extra % on some parts help.
Thank you