Hi, Ron!
This formula wich you create for date working perfect.
{=IF(ROWS($A$2:$A2)<=SUM(--(FREQUENCY(trips!$A$2:$A$100,trips!$A$2:$A$100)0) )
,SMALL(IF(ISNUMBER(trips!$A$2:$A$101),IF(ROW(trips !$A$2:$A$101)=MATCH(trips!
$A$2:$A$101,trips!$A$2:$A$101,0)+1,trips!$A$2:$A$1 01)),ROW()-1),"")}

Now i have similar situation, but i need formula which working with text.
In worksheet 'trips' in column W i put Company names. Same company names
infinity.
Sample:
column W
row2 Company1
row3 Company3
row4 Company5
row5 Company1
row6 Company1
row7 Company4
row8 Company5
and so on.
Need formula in worksheet 'company' column A row 2
Sample:
column A
row2 Company1
row3 Company3
row4 Company4
row5 Company5
row6 blank till new company name
and so on.

THANKS in advence for your time.
Sincerely, Igor (inta251)

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200702/1