Same text in column as one
- From: "inta251 via OfficeKB.com" <u30987@uwe>
- Date: Thu, 22 Feb 2007 08:23:00 GMT
I have sheet1 by name trips, where in column W I’ve companies’ names.
Same companies’ names can be infinity.
Sample:
Column W
Row2 Uuuuuuu
Row3 Aaaaaaa
Row4 Ccccccc
Row5 Ddddddd
Row6 Aaaaaaa
Row7 Zzzzzzz
Row8 Ccccccc
Row9 Ddddddd
Row10 Uuuuuuu
and so on.
Need formula in Sheet2 Column A from row2 .
Look for names in Sheet1 column W and put same company name as one text.
Sample:
Column A
Row2 Uuuuuuu
Row3 Aaaaaaa
Row4 Ccccccc
Row5 Ddddddd
Row6 Zzzzzzz
Row7 blank
Row8 blank
and so on
If no new companies name live blank
Similar to this I’ve formula for Dates
=IF(MAX(trips!A$2:A$1200)>MAX($A$3:A3),
MIN(INDEX((trips!A$2:A$1200>N(A3))*(trips!A$2:A$1200)
+(trips!A$2:A$1200<=N(A3))*10^9,0)),"")
Thanks in advance.
Sincerely, Igor (inta251)
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200702/1
.
- Prev by Date: Re: How do I count the number of even weeks in the current month.
- Next by Date: calculating back 4 years
- Previous by thread: Re: Lookup and Match with not exact numbers
- Next by thread: Re: Same text in column as one
- Index(es):
