combining

In A1 I have 43244 Software Application. I want it to be 24/05/18 Software Application. I thought combining TEXT and LEFT would work but it doesn't.

Hi everyone, I would like to add a vertical line passing through the maximum point on of the graph and touching the x-axis. How do I go about it by combining two charts. I have the x and y values. https://1drv.ms/x/s!AgQdYsSdg735ez8qaqRpoC-34QY thanks

Hello! i am back playing with a status sheet again. had to start a new plane. i am trying to make it less error prone. in the Next Due Column H Hours =f16+K16 Months =EOMONTH(j16,f16) Cycles =l16+f16 Days =(J16+f16) Years =EOMONTH(J16,F16*12) Ldgs =L16+F16 AC Hours =IF(G131="AC...

Hi excel master I need help solving cases looking for and combining and also sum the same data from my sales report. and here is my sample data A B C D E F G 1 apple manggo banana orange apple apple banana 2 orange peach apple peach banana apple 3 apple...

I need help combining the following 2 IF statements:=IF(D3="Y","Y",IF(D3="N","N","")) and =(IF(F3="pos","Y",IF(F3="neg","N",""))). I have tried multiple ways and it keeps erring out on me.

How do I combine these two formulas? =VLOOKUP(A4,Units,2,FALSE) =MID(A4,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A4&"0123456789")),1)

Hi Folks, So I have two Subs that I would like to work together. One to create a new folder, if it doesn't already exist and the second to SaveAs with the file name based on cell values. I would like for the code to 1) create the folder (if needed) 2) SaveAs with new file name (based on...

Hi, I have two variables declared as string and I am combining them using </code> Cells(lngrow, 27) = strSRowA & "," & strSRowB </code> So I have one cell as 1154 the second as 1155 I wish to combine as <b>1154,1155</b> but the value in the cell displays as 11,541,155 and is stored in the...

I have had some great success receiving help from this website, looking for another hero. I am looking for a way (macro maybe) to combine multiple spreadsheets into one starting at A23 until the first blank row. Any suggestions?

I have created a list of potential "skill sets" that leadership in my company may want to track. Now I have sent this list out to the leadership for review. The list is set up in the following manner: Skills down the 1st column. Career fields/specialty across the first row. Now I am asking...

Hi All, I am looking for a VB script which will help me combine information which I currently do manually. I pasted the table which i currently have below and is in sheet 1. I am looking for the following: Sheet 2 Col A should show all the types of fruit from Sheet 1 Col A without the...

I have a workbook (WB1) that contains multiple worksheets. I need my current workbook (WB2) to go into workbook (WB1) and copy the multiple worksheets and combine them into one worksheet in WB2. I was able to work out... within the same workbook to combine all the worksheets into one but have...

Alright so as the title says, my task is to combine around 100 tables into one giant table. The first 3 headers will be the same for them all and then the next 2-10+ headers depending on the data in that table will all be in different orders. I would like them all to match up in one layout which...

Hello, I have 12 excel 2010 workbooks with 6 tabs each that I need to combine into one table using either PowerQuery or PowerPivot. I could do it manually, but that would take a few hours and it's not really efficient, so I have been trying to figure out a way to do it using one of the BI tools...

Hi Everyone, I have two tables one with revenue & cost. I want to combine both.my situation is as below, Data table Table I nature Product Customer Revenue Revenue A ABC 100 Revenue B DEF 200 Revenue...

I am trying to combine these 2 code lines to accomplish a drop down list with suggestive text. That also auto populates other cells when a menu is selected it populates menu items. The suggestive text works well but I'm a bit stumped on how to go about adding the auto population of the cells...

Hi there, I have the following code which works perfectly to combine and stack multiple sheet column data (35 sheets) into one Master sheet. What I also need is for the name of each sheet to be copied down column A against each data block coming from a sheet. Below, it brings two columns of...

Hello, I have a list of locations and a list of units. I need a way to make it so that each location has a the same list of units. For example: Units List: a, b, c, d, e, f Location list: 1, 2, 3, 4, 5 Need it to look like this: 1 a 1 b 1 c 1 d 1 e 1 f 2 a 2 b 2 c 2 d 2 e 2 f etc.

The point of this workbook I'm creating is to make an ugly system-generated report look nice. The user pastes the report onto the first page, then clicks a macro button that does everything. "Everything" includes deleting some columns to make it line up correctly, then copying and pasting the...

How would I combine these 4 IF statements into one? =IF(A2="A",IF(ISNUMBER(MATCH("B",$A$2:$A$21,0)),"B",A2),A2) =IF(B2="D",IF(ISNUMBER(MATCH("E",$A$2:$A$21,0)),"E",B2),B2) =IF(C2="L",IF(ISNUMBER(MATCH("O",$A$2:$A$21,0)),"O",C2),C2) =IF(D2="F",IF(ISNUMBER(MATCH("K",$A$2:$A$21,0)),"K",D2),D2)...