indexing column

  1. M

    Indexing & Double Matching Formula?

    <tbody> Center Jan 2017 Feb 2017 March 2017 April 2017 363 263 532 209 120 5032 120 111 123 678 </tbody> <tbody> Center Date Packages 363 Jan 2017 263 363 Feb 2017 532 363 March 2017 209 363 April 2017 120 5032 Jan 2017 120 </tbody> The top table is how I currently have my...
  2. N

    find the last date in the month

    Hi All you Genius I don't know if this is doable but i have an excel spread sheet where in column a i have the list of date and in row b:J i have some tasks is there a way where i can find out the date of the last task with in a particular month? e.g. if the month is October then i would...
  3. K

    Transferring Data from Excel into a Database

    I am trying to export data from Excel and import it into a database (resultsplus!). I don't have much experience with databases (or excel) and really need help. I feel like I have set everything up right but every time I try to import the info into the database, this message pops up: "An update...
  4. T

    Display the value in a given row of the active column

    I have built a distribution database that is basically an order entry sheet and a packing list with a lot of unique features for my business. What I'd like to do to is to be able to click a report button to generate my packing list instead of re-entering data. To achieve this, I need to be able...

Watch MrExcel Video

This Week's Hot Topics

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
Top