vertical data

  1. R

    Last 6 Months Production Summation

    Hello Excel Forums, I have a large vertical table built like the table below. The table has many IDs with many dates. I would like sum the last 6 months of each ID. Does any one have any ideas? Thank you! ID DATE OIL PRODUCTION DUMMYCASE1 01/31/2022 100 DUMMYCASE1 2/28/2022 32...
    • RECLIP
    • Thread
    • last 6 months many to many relationship vertical data
    • Replies: 2
    • Forum: Excel Questions
  2. G

    Request for VBA code for importing multiple tab-delineated .txt files into Excel 2010

    Hello all, Thank you for taking the time to review my request. I've been poking around the boards and Google trying to find a code that will work for what I'm trying to do. This forum has been very informative, but I'm not a programmer and I'm having trouble changing all the coding from the...
    • gmackey
    • Thread
    • import .txt file multiple import single worksheet vba & excel 2010 vertical data
    • Replies: 4
    • Forum: Excel Questions
  3. C

    match horizontal data set to vertical data set

    Hello, I have two data sets that I need to match; one is arranged horizontally and the other is arranged vertically. I need to determine if the data points in the horizontal data set are also found in the vertical data set. The data sets are rather large - Data set 1 (horizontal) is ~400 rows...
    • chelson
    • Thread
    • excel excel & vba 2013 horizontal chart vertical data
    • Replies: 0
    • Forum: Excel Questions
  4. T

    Formula needed to copy certain data from Rows to Columns

    I am sure this is a simple fix for the experienced Excel user... and I apologize if this is explained in other threads. I could not find what I needed after two hours of searching. Anyhow... here it is... I have a file that is over 400,000 fields by two. A small portion of the file looks...
    • txart
    • Thread
    • horizontal list transpose data vertical data
    • Replies: 26
    • Forum: Excel Questions
  5. A

    Sum vertical data

    I am looking for a way to sum vertical data below. What i am trying to do is to get the fomula to look for the name "Bill" on top then sum anything below that name. I tried SUMIF but it seems to sum only horizontal data. Below is very small example of data: <TABLE style="WIDTH: 157pt...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top