Hi,

Im hoping you could please help me with this formula as I cant do it after lots of tries!   I have 2 sheets. One is a front page and one is a data page. The front page contains a unique number with a special instruction.  The information is from the data tab. This unique number is multiple times on the data sheet with special instructions and there are four different columns with the special instructions (unable to combine in 1 column as all looking for different things from different columns).  I have concatenate the line to bring the special instruction which it does.  On the front page I would like it to show the line with the maximum instructions but it just pulls through the special instruction from the first line with the unique numbers.  Is there a way to do this or is it just not possible?

​Hi, Im hoping you could please help me with this formula as I cant do it after lots of tries!   I have 2 sheets. One is a front page and one is a data page. The front page contains a unique number with a special instruction.  The information is from the data tab. This unique number is multiple times on the data sheet with special instructions and there are four different columns with the special instructions (unable to combine in 1 column as all looking for different things from different columns).  I have concatenate the line to bring the special instruction which it does.  On the front page I would like it to show the line with the maximum instructions but it just pulls through the special instruction from the first line with the unique numbers.  Is there a way to do this or is it just not possible?   Read More

​