| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Modifying A Formula
I would like to use this formula "=ConcatUF(times!B7:B16,";",FALSE,FALSE)"
in the table below. ColA ColB ColC Row1 Time A B Row2 10:30:00 AM Row3 9:30:00 AM My data table is setup like this: ColA ColB ColC Row1 Time A B Row2 9:30:00 AM E1 GG Row3 9:30:00 AM Y0 D1 Row4 10:30:00 AM U4 Q1 Can the formula be modified to perform the concatenation like this: ColA ColB ColC Row1 Time A B Row2 10:30:00 AM U4 Q1 Row3 9:30:00 AM E1;Y0 D1;Q1 Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop Insert Row modifying formula data | Excel Discussion (Misc queries) | |||
| dragging a formula | Excel Discussion (Misc queries) | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Named SUM Formula with relative refernce(s) | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
