Generating a sub array with multiple criteria

[Eyas Hawashin]

Hi

I explained everything in the attached simple file. Will appreciate your help. Thanks

Eyas

 

[bosco_yip]

Please see attached file and checked with Data Validation formulas.

Regards
Bosco

 

[Eyas Hawashin]

Thank you so much, but could not find the attached file.

 

[bosco_yip]

Thank you so much, but could not find the attached file.

File uploaded already.

Regards

 

[Eyas Hawashin]

File uploaded already.

Regards

Thanks so much. Highly appreciated.

 

[Eyas Hawashin]

Hi again, can you please help in this?

 

[bosco_yip]

Hi again, can you please help in this?

Place data in 9 Boxes

1] Helper M2, formula copied down :

=A2&IFERROR(","&CHAR(10)&INDEX(M3:M$23,MATCH(B2,B3:B$23,0)),"")

p.s. Helper Col M can be hide as per your need.

2] In "Box1" D16, formula copy/paste to other boxes :

=VLOOKUP(0+RIGHT(D20),$B$2:$M$22,12,0)

Regards
Bosco

 

[Eyas Hawashin]

Thanks so much. I copied your formulas to my sheet and got some problems, please have a look. I am really to keep asking but I could not find what went wrong and I need to understand. Thanks again.

 

[bosco_yip]

1] The formulas did a bit amendment.

2] See attached file

Regards
Bosco

 

[Eyas Hawashin]

Thanks, but what if I insert a new row in the "Positions" sheet, the results sheet will not be affected. See attached file.

 

[bosco_yip]

Thanks, but what if I insert a new row in the "Positions" sheet, the results sheet will not be affected. See attached file.

1] See attached file "Results" sheet revised formulas.

2] Try to test by insert a new line in the "Positions" sheet and check the "Results" sheet whether have affected.

Regards
Bosco

 

[Eyas Hawashin]

Thanks, but what if I insert a new row in the "Positions" sheet, the results sheet will not be affected. See attached file.

 

[Eyas Hawashin]

I

1] See attached file "Results" sheet revised formulas.

2] Try to test by insert a new line in the "Positions" sheet and check the "Results" sheet whether have affected.

Regards
Bosco

I inserted a new row with "HR Manager" title in the "Positions" sheet, what happened in the "Results" sheet is this:

It added a row, but as a count, I mean the last record was Position 53, so it added a position 54. I want it to be added in the same row number inserted in the Position sheet and I want it to have the same text I enter i.e. "HR Manager".

Please try to insert a row yourself and see, I am sure you can solve this.