How to assign the data on different columns

[parthoc]

what i'm looking for is if I select the position closed in Drop-down then automatically below columns will come up with the data that how many students actually appeared for English who are coming under Position Closed.

Attached is the sheetStudents Data.xlsx

[adhawan06]

Hi Partho,

Please refer to the attachment. I have included the summary in "Devtool" sheet tab.


Please let me know if it solve your purpose.


Also, please change the title of this post as this Your post does not comply with Rule 1 of our Forum RULES

Thanks,
Anil Dhawan

[Kyle123]

How is this amazing?

I have made the correction in your post for you this time, as a courtesy. Please remember in your future posts. This has merely been a harmless warning to underline the importance that you read and follow the Forum Rules we are all expected to abide. Thank you for your understanding and compliance.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[parthoc]

Hi Partho,

Please refer to the attachment. I have included the summary in "Devtool" sheet tab.


Please let me know if it solve your purpose.

Thanks,
Anil Dhawan

Hi Anil,

that's too fast, it's almost what i want, but plz have a look in other TAB "MAIN" i want those numbers in that box.

[parthoc]

How is this amazing?

I have made the correction in your post for you this time, as a courtesy. Please remember in your future posts. This has merely been a harmless warning to underline the importance that you read and follow the Forum Rules we are all expected to abide. Thank you for your understanding and compliance.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Hi Kyle my Apologies,

i was not much familiar with Titles anyways I've changed it.

thanks for the information.

Partho c

[Glenn Kennedy]

Can I check one thing. If you select shortlisted in F2, do you want ALL shortlisted candidates for "English" to be listed in D4>? If not, what do you want?

What are Tricks?

[parthoc]

Thanks again for reply Glenn.

like if i choose the data in F2 say Potion closed

then English french oleo and tricks will have their own data according to devtool sheet

for example i've selected postion closed then D4 will be 1 H4 will be 1

i hope i'm able clear my point glenn !

[adhawan06]

Hi Partho,

Just want to check as you mentioned F2 allow to select the status. So how come D4 & H4 will contain 1 if F2 is "Position Close". Because, Category mentioned in C4, C5, C6, E4, E5, G4, & G5 are not in your "Devtool" database.

So my question is that, from where the second criteria will be matched?

[Glenn Kennedy]

OK so far... See attached. What are the criteria to count as interviewed shortlisted + position closed, or something else?

[parthoc]

Oh My God !

you did it,

you are amazing glenn thanks for all your help !
This forum rocks

[adhawan06]

Glad to see that you have got your answer Partho.

Now, please take few seconds to mark this thread as SOLVED ans say thanks to user who helped you by adding *Add Reputation.


Cheers!!!

Anil Dhawan

[parthoc]

Glad to see that you have got your answer Partho.

Now, please take few seconds to mark this thread as SOLVED ans say thanks to user who helped you by adding *Add Reputation.


Cheers!!!

Anil Dhawan

Anil and Glen thanks again for the help
how to close this thread any idea !

[adhawan06]

Go to Thread Tools->Mark thread as Solved).


Cheers!!!


Anil Dhawan

[Glenn Kennedy]

Thanks for the Reputation that you have added. It's much appreciated.

[adhawan06]

Thanks Partho for adding Reputation.

Keep posting your questions here and exchange your knowledge with people around the world!!!