participant

  1. R

    Loop not working/crashing

    Hello everyone! I am a pretty beginner vba user and having some trouble getting a loop to work. I have a pretty extensive formatting code here, which works perfectly on a single worksheet. When I then try to have it loop through every single worksheet in the workbook except for the "Original"...
  2. S

    Weight Loss Spreadsheet: Tracking new Weight Loss Records

    Hi wonderful people, I'm working on a spreadsheet for a weight loss program where a participant receives a financial reward for every full pound of weight they lose. Not sure if that title is exactly what I'm looking for, but it was a struggle to describe it in a few short words. I am...
  3. G

    Combine Tabs on different work books to One Tab in another workbook

    I really need help with this. So here is my problem. I have 50 Case Mangers in different parts of the state --- they have 50 Participants Each participant has a separate file. That means approximately 250 separate files are sent to me monthly. Each file has approximately 10 tabs Tab 1 Tab 2...
  4. H

    Sum of Questionnaire Scores Based on a Domain Table

    I have created a questionnaire that consists of around 100 questions. These items are separated into 6 domains where. For the sake of easier understanding, let's just call them Domain 1 - 6. I have them typed in one specific table called "Correspondence", with format like below: <tbody>...
  5. S

    Multiple row value-based if/end issue

    Dear reader, I'm having an issue with a formula. I'm trying to accomplish the following: <tbody> A B C 1 Value1 Value2 Result 2 0,7 10,1 Stop 3 0,7 10,1 Stop 4 0,8 9 Stop 5 0,8 9 Stop 6 1 10,5 Ok 7 1 10,5 Ok 8 1 10,5 Ok 9 1,2 11 Ok 10 1,2 11...
  6. A

    Can't find the good Formule

    Hello. I am new to Excel, I am learning it, but I can't do something. So the task is like this: I have to create 1 more collumn in right of "Comitat" named "Ecuson". In that collumn the name from "Nume participant" should be with uppercase(I guess by using function UPPER) but it should have...
  7. R

    RATING changing Values in a data block

    I have been trying to sort this one out for days now and mind you I am not an Excel power user. The problem may even be the way I am phrasing the question to myself. I would like to scan this data block for all the participants numbers an show in a summary a total value for each participant...

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