One way assuming your version of Excel (you did not mention it as asked inWelcome to your Excel discussion space!) has function TEXTJOIN inB4and copy down as necessary: =TEXTJOIN(", ",TRUE,OFFSET(A$4,(ROW()-ROW(A$4))*B$1,,B$1)) Your file with the above formula is attach...
ADDED: IF($C$8=$B$14:$B$48,$C$9=$C$14:$C$48) performs no concatenations AND only compares C9 to C14:C48 when C8 equals corresponding entries in B14:B48. Thus fewer AND shorter string comparisons than comparing C10 to all items in B14:B48&C14:C48. Last edited by hrlngrv;...
If you are open to a VBA solution, please find the attached which contains Sheet Change Code on Foglio 2 Sheet Module and a macro on Module1. On Foglio 2 Sheet, if you change the rate in cell T2 (yellow cell), you will get the desired output in column B. Subodh_Tiwari_sktneer, T...
If that's a problem you can add a comma in the concatenation... we'll be able to send you in the right direction as soon as we know more about your problem! garethmann101 SSCommitted Points: 1980 More actions September 18, 2008 at 6:30 am ...
address like ROWS(A$1:A2)),ROWS(A$1:A3)),ROWS(A$1:A4)). As the address is given as A$1:A1, the first A$1 is absolute address so excel does not adjust it. So in E3 we shall get 2 for formula ROWS(A$1:A2)). As A$1:A2 has 2 rows. In E4 get 3, in E5, get 4...
Date Time Creation Functions (Currently Just Concatenation) MakeDate: Create a new date from Year, Month, Day(C++) MakeTime: Create a new time from Hour, Minute, Second(C++) MakeDateTime: Create a newDateTimefrom Year, Month, Day, Hour, Minute, Second(C++) ...
Insert single quote into string: ways other than concatenation? Interop Assemblies for Excel 2016 for c# application Invalid Arguement with InStr() Function Is it possible to change excel sheet as culture specific? is it possible to insert picturebox control in vba Is it possible to use the "...
Insert single quote into string: ways other than concatenation? Interop Assemblies for Excel 2016 for c# application Invalid Arguement with InStr() Function Is it possible to change excel sheet as culture specific? is it possible to insert picturebox control in vba Is it possibl...
How about this, then, as a solution: Use a cell off to the side (or on a different tab) to do the concatenation involved in the formula =A1&"California",&B1. Let's say it's cell Z1 Then in C1, protected, just have the entry =Z1 And column Z can be hidden from sight altog...
I am working on a project at work which requires us to have a workbook with anywhere from 1 to 10 sheets of data. On the last sheet we have a Contract...