I
inta251 via OfficeKB.com
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)
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)