| 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. |
|
#2
|
|||
|
|||
|
Its a User Defined Function. You need to provide the code for it. The UF in
the name of the function says that its a user function. Press Alt F11 to view the code. Check the standard modules on the left and see where the code is and post it. Mangesh "carl" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
I can see that ConcatUF is a UDF of yours, which you don't show, but I don't
get what the formula currently does or what you want. Can you try re-posting with the start data (use a character as a cell delimiter like ||) and expected results? -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... 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. |
|
#4
|
|||
|
|||
|
Hi Bob. Thank you trying to help me.
The function concatenates a selected range. I tried to show the expected results in the last table of my post: ColA ColB ColC Row1 Time A B Row2 10:30:00 AM U4 Q1 Row3 9:30:00 AM E1;Y0 D1;Q1 For example in B2, I need a formula to look at the value in $A2 and $B1, find all values in the data table that map up to these 2 cells, and concatenate them with a ";" as the separator. Sorry I can't explain this any better. Thank you again. "Bob Phillips" wrote: I can see that ConcatUF is a UDF of yours, which you don't show, but I don't get what the formula currently does or what you want. Can you try re-posting with the start data (use a character as a cell delimiter like ||) and expected results? -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... 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. |
|
#5
|
|||
|
|||
|
Carl,
Sorry to keep pushing mate, but that data looks scrambled to me. I cannot tell whether Row 1 is a label in a cell, signifies a row or what, And is the 10:30:00 in B, C.? Is AM U4 Q1 all in one cell. If you could relay before and after I can give it a shot, but at present I am not clear what is required. Another thing, is this to work on a set of rows, or just one? If the former, can you give an example with more than one row of results? -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... Hi Bob. Thank you trying to help me. The function concatenates a selected range. I tried to show the expected results in the last table of my post: ColA ColB ColC Row1 Time A B Row2 10:30:00 AM U4 Q1 Row3 9:30:00 AM E1;Y0 D1;Q1 For example in B2, I need a formula to look at the value in $A2 and $B1, find all values in the data table that map up to these 2 cells, and concatenate them with a ";" as the separator. Sorry I can't explain this any better. Thank you again. "Bob Phillips" wrote: I can see that ConcatUF is a UDF of yours, which you don't show, but I don't get what the formula currently does or what you want. Can you try re-posting with the start data (use a character as a cell delimiter like ||) and expected results? -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... 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. |
|
#6
|
|||
|
|||
|
Thanks again Bob. The fomating of this post makes it tough to explain.
Perhaps I could send you an example spreadsheet. If so, just let me know where to send it. "Bob Phillips" wrote: Carl, Sorry to keep pushing mate, but that data looks scrambled to me. I cannot tell whether Row 1 is a label in a cell, signifies a row or what, And is the 10:30:00 in B, C.? Is AM U4 Q1 all in one cell. If you could relay before and after I can give it a shot, but at present I am not clear what is required. Another thing, is this to work on a set of rows, or just one? If the former, can you give an example with more than one row of results? -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... Hi Bob. Thank you trying to help me. The function concatenates a selected range. I tried to show the expected results in the last table of my post: ColA ColB ColC Row1 Time A B Row2 10:30:00 AM U4 Q1 Row3 9:30:00 AM E1;Y0 D1;Q1 For example in B2, I need a formula to look at the value in $A2 and $B1, find all values in the data table that map up to these 2 cells, and concatenate them with a ";" as the separator. Sorry I can't explain this any better. Thank you again. "Bob Phillips" wrote: I can see that ConcatUF is a UDF of yours, which you don't show, but I don't get what the formula currently does or what you want. Can you try re-posting with the start data (use a character as a cell delimiter like ||) and expected results? -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... 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. |
|
#7
|
|||
|
|||
|
You could post an example at http://www.savefile.com/filehost/ and let me
know your URL. But show expected results as well. -- HTH Bob Phillips "carl" wrote in message ... Thanks again Bob. The fomating of this post makes it tough to explain. Perhaps I could send you an example spreadsheet. If so, just let me know where to send it. "Bob Phillips" wrote: Carl, Sorry to keep pushing mate, but that data looks scrambled to me. I cannot tell whether Row 1 is a label in a cell, signifies a row or what, And is the 10:30:00 in B, C.? Is AM U4 Q1 all in one cell. If you could relay before and after I can give it a shot, but at present I am not clear what is required. Another thing, is this to work on a set of rows, or just one? If the former, can you give an example with more than one row of results? -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... Hi Bob. Thank you trying to help me. The function concatenates a selected range. I tried to show the expected results in the last table of my post: ColA ColB ColC Row1 Time A B Row2 10:30:00 AM U4 Q1 Row3 9:30:00 AM E1;Y0 D1;Q1 For example in B2, I need a formula to look at the value in $A2 and $B1, find all values in the data table that map up to these 2 cells, and concatenate them with a ";" as the separator. Sorry I can't explain this any better. Thank you again. "Bob Phillips" wrote: I can see that ConcatUF is a UDF of yours, which you don't show, but I don't get what the formula currently does or what you want. Can you try re-posting with the start data (use a character as a cell delimiter like ||) and expected results? -- HTH RP (remove nothere from the email address if mailing direct) "carl" wrote in message ... 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. |
| Reply |
| 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) | |||
Hybrid Mode
