Hi my friends ..
Formula in G work best with text, but with date fail to work after concatenate
any idea to work together date and text?
thanks
Hi my friends ..
Formula in G work best with text, but with date fail to work after concatenate
any idea to work together date and text?
thanks
Do you mean formula in K instead of G?
=IFERROR(Concentrate(J$3:J$60,ROW(K1)),"")
What is "Concentrate" formula?
Quang PT
please explain precisely what you are attempting as the UDF is confused thinking.
true concatenation only works with strings as (text).
K3 is not correct time result....
7:46 need..
Please try
=IFERROR(--Concentrate(J$3:J$60,ROW(K1)),"")
@Bo_Ry, briliant formula
thanks..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks