combine

I have the following 3 formulas. Is it possible to combine them into one or write a macro for them. =IF(LEFT(C:C)="R",G:G&" Rack") =IF(AND(LEFT(C:C)="R",RIGHT(C:C)="B"),G:G&" BLM Rack") =IF(RIGHT(C:C)="B",G:G&" BLM",IF(RIGHT(C:C,1)="C",G:G&" BLM",IF(LEFT(C:C,3)="TRT",G:G&" TRT",G:G)))

I have the following statements that ascertain whether a 1 or 0 is shown in a destination cell. I have been trying to combine both statements with no luck. =IF(OR(T29="W"),1,ROUNDDOWN(COUNTIF(T29:T33,"W")/2,0)) =IF(AND(T29="W"),ROUNDDOWN(COUNTIF(AR29:AR33,"W"=2),0)) Is it possible to combine...

Hi Guys, Wondering if you could assist me with this simple formula - I'm trying to combine, "column E" with "column D" with a "." in between, I did the first one as an example - "BQ6924-001" add the "." and then the "3.5UK" so we get "BQ6924-001.3.5UK" I want to ignore the blanks though in...

I have two ranges: R1 and R2. They have same header How to combine them so R1 is on top and R2 is at the bottom to form a new combined range called "R"? Thanks

Hello, I have 35 tabs that are updated daily. I want a summary worksheet that will combine everything that is on the 35 tabs. Info can be updated on these 35 tabs at anytime and would like the summary worksheet to reflect the changes made on any of the 35 tabs. Each tab has the exact same...

Hi everyone, need help to cover excel formula =(B2&"_"&G2&"_"&I2) to vba code. Because I get Alert msg for excel "One or more formulas in this workbook are longer than the allowed limit of 8192 character." I need to combine B$&G$&I$ in-between space insert "_" to F$ (automate fill up when key...

I have a spreadsheet that contains a couple hunded date/times with coresponding sample results. I use several different arrays to combine multiple sets of dates into one column and then use this formula to organize them by date and ignore blank cells...

I have six columns with anywhere from 5 rows to 99 rows in each column. I need to combine EVERY possible combination of the rows. Here's some of the data. I know how to concatenate, but don't think that is what I need to do. Please help!! <tbody> Entity Location Department GL Account Fund...

Hi All, I hope that you can help. I have 4 tabs on this sheet. 1st tab is my shipping info that I drop into the sheet and 3 of them have info I need to reference from. The problem is I keep getting 0 on half my look ups. So I tried to use =IFNA(IF(VLOOKUP(A2,'Redding...

So I have a simple 2-column table; basically just a list of names where each has a corresponding number. Simply, I want to comb through the list and find things like "| Company A | 5 |" and "| Company A Inc. | 5 |" and combine them. I guess this could turn into "| Company A | 10 |" or "| Company...

I have set of excel files in a folder with 52(week names) sheets in each workbook, e,g have 10 workbooks. each week need to enter data in the particular week sheet. i would like to consoildate, particular week sheet data (eg WK22 sheet ) as combine one as in particular location workbook sheet...

Hi I want to say from & to dates based on cell values I have this formula: ="From "&D$15-SUM(D$14*7)&" To "&(D$15-49) which returns result From 43602 To 43651 so to convert serial numbers to date format I tried: ="From "&TEXT(D$15-SUM(D$14*7),DD-MMM-YY)&" To "&TEXT(D$15-49,DD-MMM-YY) But...

Thanks for taking the time to read. I have a list of surnames in Column A and first names in column B and I need to combine the two into one cell which I can easily do by joining strings. However I also need the format changed with characters adding so: from this: Smith John to his: Smith...

Hello, I have test equipment numbers in separate columns. How can I combine them into one column with the numbers separated by commas and one space after each comma? Note some columns don't have numbers. Thank you Excel...

Hi, I need to combine contents to 7 of the 10 worksheets in a workbook that all have the same column headings. I would like it to combine on a master sheet that i can go in and refresh once a month. Please Help!!

Hi all: I have Folder Parent with child folder: 2019, 2018, 2017. Each folder have child folder too: 201901,201902,201903,201904.....201912 It's look like: <tbody> Parent 2019 201901 201902 201903 201904 . . . . . . . 201912 2018 201801 201802 . . . . . . . . . 201812 2017 201701 201702...

Hi, I have 60 excel files that each contain data for one day of the last 2 months. They are identical formatting wise, although they obviously contain different rows of data. Is it possible to combine all 60 excel files into one document? In other words, I'm just just trying to get the data...

Hello, I have a workbook with 3 sheets, I am trying to copy the first 2 sheets to a new workbook without formulas. Each sheet needs a set range, which is different, can I combine these 2 Macros together? Sub JointingTracker() Sheets("jointing Tracker").Copy Range("A1:P70").Copy...

I have multiple financial budgeting excel workbooks that I would like to combine into a single workbook in order to cut down on the number of files I have to open. How would I go about doing something like that?

Hi I've got multiple macros that I want to run in order with one button press. Is it as simple as just copying all in one new macro? I also then need to <colgroup><col></colgroup><tbody> combine macros create new book named xx remove formulas from certain columns on each sheet save...