could not find title

[Khalil Handal]

This looks very complicated to me!
39 numbers are in a range H15:AT15, each three numbers forms a group (has
title) because they are related.
ex. h15, i15, j15 forms group1
k15, l15, m15 forms group2
.. . . . . . . . . ... ..
AR15, AS15, AT15 forms group13

I need a formula to be used in cells AX15, AZ15, BB15 to get the names of
the three groups basd on the following:
if J15<$J$14 then check values in previous 2 cells (H15, and I15), if
H15<$J$14 then write "group1 a" in cell AX15 if I15<$J$14 write "group1 b"
and if Both cells H15 and J15 < $J$14 then write "group1 a &b".

If AX15 has a value and another value for another group exists then use the
cell AZ15 to write the result .
I need to have only the first three groups.

 

[Khalil Handal]

Thanks, I added what is missing and is OK

We're somewhat OK to this point, but you have some undefined conditions.
Sorry about the line wrap. In AX15:

=IF(J15<$J$14,IF((H15<$J$14)*(I15<$J$14),"group a &b",IF(H15<$J$14,"group1
a",IF(I15<$J$14,"group1 b","NOT DEFINED"))),"NOT DEFINED")


Can't do this with a formula because a formula in AX15 can't populate some
other cell.