indexing row

  1. G

    Help with something more effcient (CPU usage high)

    I have this performing the tasks needed, however when ever data is changed or the file is saved, Excel takes 30-60 seconds to complete the task. I'm sure there is a more effcient way of performing the same task, but I'm at a loss. I've linked to an example with 50 rows of fake data to...
  2. A

    Index Match along with SMALL and COUNTIF

    Hello Guys, I got a three formulae that return results from another worksheet. One of these is working alright - the one that returns the dates. But the two other are not working. I am posting a portion here. Any help is appreciated and THANKS in advance. Excel WorkbookABCD1LAST NAMEFIRST NAMEDC...
  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. R

    Help Needed with big spreadsheet

    I am new to VBA I am designing a spreadsheet that is used in sports It has a list of players names down a columns with the different skills going across in rows divided in to halves Attack and Defence It has 16 players and 10 skills in Attacks section and 16 Players and 11 Skills In the...

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