1. B

    Practice Schedule Help

    Hello all, I need some help I have 10 teams that need to be scheduled for practices for a season. I have a spreadsheet of he time slots that are already predetermined. Is there way to distribute the teams across the time slots to reach their required practice counts? For example, tier teams...
  2. A

    VBA Practice?

    Hi all, I find myself always posting on the forums and asking for assistance with VBA. Majority of the times I get the help I need which is great, but usually have a hard time understanding what the code actually does/means. I would say I'm an advanced Excel user but still a beginner with VBA. I...
  3. A

    Pilot needs help for personal project!

    Hi I had made a cool post asking for help but it got deleted so Im going straight to the point. I have an excel and In Column B I have the name of different race car drivers. In columns C and D I have their ranked position in practice 1 (C) and practice 2 (D). In column E I have their rank...
  4. D

    best practice for multiple if conditions

    Hi hoping someone can help I've got multiple if statement which I would be fine writing in excel but struggling in powerquery (the below is not working expecting another then?!) would appreciate any help and what the best practice would be for the below and if anyone can make it work that would...
  5. L

    cleaning file samples

    Hi Where can I find excel files which has raw data need to be cleaned/formatted etc, remove duplicate, blank cells etc. I want to practice that on real life files. Is there any website I can down load these files from? Thank you very much.
  6. M

    Listing multiple diseases for a single patient

    Hi I have an SQL extract table of patients with one or more diseases recorded for them. Each patient/disease information is a separate record/line. Through a pivot, I can see which patient has more than one disease recorded and which diseases are included. However, the pivot contains all...
  7. S

    Excel Question....?

    I'm trying to study a true/false test i'll be having. is there anyway i can input that into the computer so i can practice it.... and what is the code or where can i get it??? I am completly clueless on where to start
  8. L

    Free Access database for educational purpose

    Hi I want to learn how to import data from Access into Excel. I want to practice that. Where can I find free Access database to download so I can practice that? thank you.
  9. T

    Clearing object variables

    Is it good practice to clear an object variable before using it? For example: Option Explicit Sub ClearingObjects() Dim ws As Worksheet Set ws = Worksheets("Sheet1") ws.Cells(1, 1).Value = 1 Set ws = Nothing Set ws = Worksheets("Sheet2")...
  10. jgrob3

    Can you help test our Excel test?

    We recently completed an online Excel test that people can take then post the results to Facebook so if you're an Excel expert and have 5 min to spare, we'd love to get your input on the questions and format to help make it better. If you can help, we'd really appreciate it ... plus you can let...

This Week's Hot Topics

  • separating multiple Proper names (uppercase letters) from a list
    I have a list of proper names that only has spaces between their first and last names. I need a formula that can separate these names into...
  • 'for' Loop
    Hello guys, I am trying to do something new. With the help of a VBA code, in every case, last 2 Values of last 2 cells of columns D-15 to D-28 to...
  • Open specific pdf in folder with vba
    Hi, Below is the code in use , unable to find rich icon to put code inside using a mobile. The code in use is shown below. Everything works as it...
  • What is wrong with this For Loop code?
    I am trying to loop through each cell in Column U from U4 to last row to check if the percentage in the cell is greater than -.050%. In a...
  • Data to match
    Hi there, I have created 2 worksheets with data. First is all materials used and second has the bottle type used for each of material. How can I...
  • Shifting Columns
    Hi Dear Community, I'm trying to find the best way to Shift (Cut - Paste) all the information below and to the right of the "Worker" cell in VBA...

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