Solution provided is not working, thread was closed as it was duplicated so I am posting this thread again. Sorry for making a mess

Status
Not open for further replies.

Jonam711

New Member
Joined
Jun 11, 2022
Messages
24
Office Version
  1. 365
Platform
  1. Windows
In A1 I've got drop down list of employees. From C1 I have months as header in 1st row until N1. When i select a employee from the drop down list in A1 the cells from C2 to N2 has to remain blank to enter the data for every month for that employee. When I chose next employee from drop down the cells has to be blank again to enter the data for that respective employee. Such that for every employee in the drop down. Is it possible?

Solution provided:
=IF(COUNTIFS(A2:G2, "X")>1,"GOOD",INDEX($A$1:$G:$1,MATCH("X",A2:G2,0))&"only")

In the image, A1 is drop down list of names, B1 to M1 are the months header. In the cells B2 to M2 I've to enter the data (numbers for every month) for corresponding names. Whenever I choose a different drop down the cells B2 to M2 should remain blank to enter the data for that corresponding employee.
 

Attachments

  • IMG_20220612_001728.jpg
    IMG_20220612_001728.jpg
    117.1 KB · Views: 7

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
Please stop posting the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
 
Upvote 0
Status
Not open for further replies.

Forum statistics

Threads
1,223,911
Messages
6,175,327
Members
452,635
Latest member
laura12345

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top