whats the longest sequence of unique's in a row between d10:d5003

[Seafreight Discounte]

Hi,

I have two more questions.

1. I would like cell E15 to say Cool when the d4 until d15 are unique

And I have another question if that is allowed here inside one thread. I would like
to know inside I3 whats the longest sequence of unique's in a row between d10:d5003

I hope someone can help. Sorry for my questions but I am still learning step by step.

Thanks a bunch.

[AliGW]

Please update the thread title, which does not match what you seem to be asking for. Use this instead: "whats the longest sequence of unique's in a row between d10:d5003"

1. Use this:

=IF(COUNT(E4:E10)-SUMPRODUCT(1/COUNTIF(E4:E10;E4:E10))>0;"Not Cool";"Cool")

[Seafreight Discounte]

Sorry. added the wrong sheet. This is the correct one.

[AliGW]

Try this:

=MAX(FREQUENCY(IF(D:D="Unique";B:B);IF(D:D="Unique";0;B:B)))

entered as an array formula.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

[Seafreight Discounte]

Thanks. Would you care adding it into my sheet since it doesn't work on my end how it should. The first formula is in english so
my software doesn't accept it.

And the second one makes my excell load very slow. Is this because it's a large row?

[Seafreight Discounte]

It's not working how it should. You know what, can you add the formale to E21. That way it will skip the empty cells d4 to d9 so don't get errors.

Thanks

[AliGW]

No - you need to learn to do the adapting for yourself. I have already provided you with a workbook.

[Seafreight Discounte]

Thanks for your help.