Create top 10.

[red1234]

Hi,

I have a question I have a list with top 10 names let's say:
Name1
Name2
Name3.. Name10

Then I have a number of 1000 items in a sheet. One of the columns contain the names. I would like to mark (in another cell) those that are part of the top 10 with 1 and the rest that are not part of the top 10 with 0.

Example

Name1 1(because is part of the top ten)

Name30 0(because is outside of the top ten)


The names in top 10 are unique.


In need a solution for this so I won't be needed to do it manually.


Thank you in advance!

[canapone]

Hi

in column A names, in column B 1 or 0 to select (...it's a big help!)


In D1 to be copied down

Please Login or Register  to view this content.

Please see the attached file...

[red1234]

Hi,

Thanks for the answer, I am not sure if I explained correctly.
But from my list of 1000 items some items names are part of top 10. I therefore, would like to mark them with 1 if they are part of top ten otherwise 0.

I am not sure the formula does that. I don't know the column B with 1 or 0. But I have the top 10 names in a another column.


Best regards,
red1234

[vlady]

To better explain.

To attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Regards,
Vlady

[popipipo]

May be this way?