| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Same text in column as one
I have sheet1 by name trips, where in column W Ive 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 Ive formula for Dates =IF(MAX(trips!A$2:A$1200)MAX($A$3:A3), MIN(INDEX((trips!A$2:A$1200N(A3))*(trips!A$2:A$12 00) +(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.a...tions/200702/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF: 2 criteria: Date Range Column & Text Column | Excel Worksheet Functions | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| To copy values in a column relevant to text in an adjacent column? | Excel Worksheet Functions | |||
| Wrap text in column headers to fit text in column | Excel Discussion (Misc queries) | |||
| How I can print full text bigger than column, in repeat column | Excel Discussion (Misc queries) | |||
Threaded Mode
