If Statement Formatted on Unique IDs

[BREngineer07]

Hello, any help would be much appreciated! For each set of unique IDs, if the minimum grade level in column is 3 or less, state "not-transfer" in column C. Otherwise state "transfer". So for example in the data-set attachment, for all unique IDs 1, the minimum grade level is 5, which is greater than 3, and is therefore labeled as a "transfer" in column C.

[avk]

Try in "C2"

Please Login or Register  to view this content.

copy paste down

[BREngineer07]

Yes, but for each set of unique IDs, such that for all rows with Unique ID 1, all the values in C are false, but for rows with Unique ID 2 (which has a row with grade level 3 or under), all the values are true.

[JeteMc]

Try the following:
1) Select cell C2,
2) Paste the following array entered formula* into the formula bar:

Please Login or Register  to view this content.

*3) Simultaneously press the Ctrl, Shift and Enter keys,
4) Pull the fill handle of C2 down to C10.
Let us know if you have any questions.

[BREngineer07]

Hi there, thanks for the response, but it doesn't seem to work. It returns #VALUE! instead. Any other ideas?

[JeteMc]

That the error was #VALUE likely means that the array entered formula was activated by pressing only the Enter key, as opposed to simultaneously pressing the Ctrl, Shift and Enter keys, as is necessary.
Attached is a copy of your file using the array entered formula.
Let us know if you have any questions.

[BREngineer07]

That worked great - thank you so much!

[JeteMc]

You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.