origin

  1. M

    VBA - Copy specific headers help... check point

    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...
  2. A

    code compare values of columns into two sheets and result in another sheet

    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>...
  3. baitmaster

    help writing SQL query including Join and Subquery

    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 &...
  4. D

    Count number of rows that contain data (rows will be dynamic)

    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...
  5. C

    Coordinates from text & rotate

    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...
  6. A

    finding all available routings/paths

    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...
  7. P

    Pivot table with two headers but same source of input

    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...
  8. C

    Power Query in excel 2016 issue importing text firl

    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)...
  9. A

    Identify & Remove Specific Data Set From String

    <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...
  10. C

    Index experts needed

    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...
  11. C

    Index experts needed

    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...
  12. T

    Dont want chart to include origin

    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...
  13. B

    Paste data from one spreadsheet into another after matches are found

    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...
  14. B

    Convert Rows to Columns

    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">...
  15. B

    Excel 2003 - The start of it all...

    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)...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top