Excel - How To Do A Random Number With No Repeats In Excel - Episode 1806 

That is a great tip! I have never seen that combo of RAND and RANK before!

I've used RAND and RANDBETWEEN a lot. RANK is one that I've never used or thought to ever seek out.

This is cool! RANK is a new function for me. I've never needed this directly but I can see its use for generating bogus/random datasets--just like the gamezilla.

Coloured ( through conditional format)cell of that chart should automatically show project name I.e management. Thanks ..

I just love a simple solution!!

Bill, once again a great video I have one question I have a conditionally formated gnatt chart of a project planner consists of fields as project topic , start date, no of days, end date (which is automatically calculated. And a conditionally formated gantt chart now my question is as soon as I enter a record in project name field it should be seen in chart on the first coloured cell for eg.. if my project name is management and the start date is 1st april to 10th april and on the first ... ctd

No. 3 in your first example?!

But I did see repeats, the