Count IF To sort/classify

[Lyaliuae]

Hi,

At the beginning, I would like to thank you for your help.

However, I need your help with choosing the right function.

The Data that I have is Grades:

Gade 1/Class A

Grade 2/Class B

Grade 3

Grade 4

Grade 5

Grade 6

Grade 7

Grade 8

Grade 9

Grade 10

Grade 11

Grade 12

Grade 12

Grade 13

Grade 14

Grade 15

Manager

Supervisor

Engineer

Judge

Laywer

Etc..
I wanted to use if function, but I couldn't as there's a limit on the characters that can be used in "IF Function", but unfortunately, I can't because I exceeded the limit, as I have too many grades to include in "Logical_Test",

What I am looking for if one of this data was found write 45 Days, if other grades that is not listed was found write 30 Days.

Thank you.

[TMS]

If you make a list of the roles in a column somewhere, maybe on another sheet, you could use COUNTIF to check if the role is present. For example:

Please Login or Register  to view this content.

Regards, TMS

[Vuqar]

You can use countif function:If value exists in this range,cell is equal to 30 days,if not 45 days.So if you range is in A1:A21,and your values are in B column,you write this formula in C1 and fill:
=IF(COUNTIF(A1:A21;B1)>0;"30 days";"45 days")

[Lyaliuae]

If you make a list of the roles in a column somewhere, maybe on another sheet, you could use COUNTIF to check if the role is present. For example:

Please Login or Register  to view this content.

Regards, TMS

Thanks TMS for the reply, but can you attach a sample so that I have an example?

[Lyaliuae]

You can use countif function:If value exists in this range,cell is equal to 30 days,if not 45 days.So if you range is in A1:A21,and your values are in B column,you write this formula in C1 and fill:
=IF(COUNTIF(A1:A21;B1)>0;"30 days";"45 days")

Hi,

Thank you for you help.

I've created a sample. Can you please take a look at it, and tell me the formula for this sample?

COUNTIF.xlsx

[TMS]

The example you have given is not the same as the scenario you originally described. In the OP, you said

What I am looking for if one of this data was found write 45 Days, if other grades that is not listed was found write 30 Days.

.

That requires a VLOOKUP:

Please Login or Register  to view this content.

This looks for the Grade in the table and, if it finds it, returns the number of days. If it is not found in the table, the IFERROR function will return "30 days".


Regards, TMS

[TMS]

You're welcome. Thanks for the rep.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.