Making presence list

[helpmeplzush]

Hello, I am trying to make excel make me a list of my students based on the day.

For example:

I want excel to check who is here on Monday and show me the names in a list on "F"

 

[RasGhul]

Where F6 is the day of the week try;

=IFERROR(IF(MATCH("here"&$F$6,INDEX(M8:S8&$M$7:$S$7,),0)>0,L8,""),"")

 

[helpmeplzush]

Maybe you could explain in words what you want.
Your image is very hard to see.
Like you said Monday

Will it always be Monday?

How will the script know what Day to look for?

And its hard to know what row to start looking on

Please say something like this:

When I enter Monday in Range("G14") search column E starting in row 12 for all cells with Monday in it and put these values in column F starting in row 12

Do not say look at my image.

I have blown my screen up to about 400 percent and still have a hard time seeing your image in detail

Tell us what column Monday is in like say Sun in column A Monday column B and on and on.

If you can provide these details maybe I can help you.

The day will change when i will write another day.
I want it to scan the list on the day i choose (ex monday) and then check who of my students is here (ex Student 6 & Student 9) and write the names on F8,F9 and on.. (if needed)

 

[My Aswer Is This]

Not much help here:

The day will change when i will write another day.​

Write another Day where?

And I asked several questions which you did not answer like:

I said this:

Please say something like this:

When I enter Monday in Range("G14") search column E starting in row 12 for all cells with Monday in it and put these values in column F starting in row 12​

What column is Monday in and Tues.

 

[helpmeplzush]

Hi. the last threat wasn't simple to understand so i made a simpler one:

I want the list on D10 and on to show me who was here by the day i put on D9.
For example:
I wrote on D9 "Sunday" so it should scan the "Sunday" list on O10 and give me Students 1,2,4,5 on D10:D13 because Student number 3 was not here. (D14 should stay empty)

Thanks everyone.

 

[Peter_SSs]

Hi. the last threat wasn't simple to understand so i made a simpler one:

I have merged them. Refer to #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Try this in D10, copied down

=IFERROR(INDEX(P$10:P$14,AGGREGATE(15,6,(ROW(P$10:P$14)-ROW(P$10)+1)/(INDEX(I$10:O$14,0,MATCH(D$9,I$9:O$9,0))="here"),ROWS(D$10:D10))),"")

 

[My Aswer Is This]

Just curious:
Why does your screenshot show your worksheet in reverse order?

Column A is to far right instead of far left

 

[Peter_SSs]

Just curious:
Why does your screenshot show your worksheet in reverse order?

Column A is to far right instead of far left

It is an option for any worksheet (File-Options-Advanced-Display options for this worksheet). The default direction for reading/writing for some languages is right-to-left and if you look at the sheet name tabs, ribbon labels etc you will see that the OP is definitely using a different language version.

(I turned my sheet right-to-left to check my answer to the question before posting it, & found the layout & operation of the sheet very disconcerting. )

 

[My Aswer Is This]

Thanks Peter:
I thought it might be something like that but was not sure.

I tried to emulate your formula but was not able to do some looking at things backwards.
I may try again.

I was going to try and provide a vba solution but if your formula works that would be a better solution I assume.

 

[My Aswer Is This]

I tried the formula and it does work for me. I'm not good at all with formulas.
Great Job Peter

 

[Peter_SSs]

I was going to try and provide a vba solution but if your formula works that would be a better solution I assume.

I don't think the OP has specified either way in relation to formulas/vba so who knows, maybe a vba solution will be requested.