origin

Hi Team I got one vba solution on this site given by DanteAmor, if any header missing then I want to add message box for user and exit sub Option Explicit Sub copy_paste_data_based_column_headers() Dim sh1 As Worksheet, sh2 As Worksheet, a() As Variant, b() As Variant Dim i As Long, j...

hi, everyone i would code to show difference values between columns into two sheets and show the result in another sheet for more explanation sheet1: <tbody> ITEM BRAND TYPE ORIGIN QUNTITY 1 10.00-16 8PR FSM THI 7 2 10-18 10PR FG FG *** 10 3 10-16.5 8PR FG INDO 20 </tbody>...

I’m working with SQL in Excel, and it’s working well. Now I want to add a new query that’s slightly more complex than the others and is outside my limited SQL comfort range. I have 3 tables (worksheets): Table1 contains JourneyRef, RouteNum, DepTime, ArrTime Table 2 contains RouteNum, Origin &...

Hello If I have a set of data that will have an unknown number of rows, how can I calculate the number of rows with data in them if the sheet will change each time Example below, I only wish to count the rows with actual data not the blanks and because the range will change I can use a...

Hi, I have a series of .csv files that contain 2d x&y coordinates like so {x:416.83624,y:379.13855,status:0},{x:415.50653,y:378.78394,status:2},{x:414.4428,y:379.13855,status:2},... There are thousands of these points, all in text in one cell. How can I pull out the x & y coordinates and drop...

I will try to keep this a simple as possible. I have a sheet with a list of flights, the origin of the flight in column A and the destination of the flight in column B. I want to be able to type in an origin and destination in lets say cells F1 and G1, and have a macro determine all possible...

Hi all, I’m a basic user but a big fan of pivot tables. I’ve to rush out a report for several thousands of records but struggle to achieve the outcome with pivot. Hence, my SOS reach out to this community. My table has more headers but let me simplify it to a table with 3 columns - Name, Origin...

I'm trying to create a new connection and import a text file so I can work with power query. I was expecting to see File Origin Delimiter 1252: Western European (Windows) ~ but I only see File Origin 1252: Western European (windows)...

<tbody> Hello, I need help identifying a formula that will locate the "country of origin" attribute in a data set (Example below) and extract it. All of the html exists in a single cell & I want all of it to remain there, except for the country of origin portion. However, each row might have a...

Hi I am trying to build a spreadsheet that will produce several results based on referencing one value in one particular cell. How do I build a formula that will produce the results like in Match? Leaving blanks if the incorrect Animal I input in Lookup? Any help will be HUGELY appreciated...

Hi I am trying to build a spreadsheet that will produce several results based on referencing one value in one particular cell. How do I build a formula that will produce the results like in Match? Leaving blanks if the incorrect Animal I input in Lookup? Any help will be HUGELY appreciated...

Hello My xyScatter chart has an annoying habit of always including the origin. Often I'm only interested in the immediate range of the data being plotted. Is there a method to disregard the origin? I've included the code for the chart data. I would like a chart property that "zooms" in on the...

I thought I had my answer with index match, but it doesn't seem to work for me. I have two spreadsheets, one with only unique data. The other one has repetitive data. I would like to paste data from Sheet 1, to a column in Sheet 2, when matches are found. In my example below, the columns that...

I thought someone would have asked this, and they may have, but I was not successful in finding the answer in Excel. I have a large spreadsheet in rows that I would like to copy and convert to columns. Example of what I have: <colgroup><col width="64" span="4" style="width:48pt">...

Hello all! (Newbie here) I'm currently doing a multi data graph on Excel 2003 (Strain gauge experiment), the problem I'm trying to get my head around is how to set the data to pass through or start at the origin? If the data doesn't then I'm presuming it will display it over or under (0,0)...