members

  1. userxyz777

    replace the comas in strings that separate substrings to pipes using VBA

    Hello, I have text cells in a column that comes from a checkbox in a survey. the checkbox has an option list that people can select as many of the options as they want Example of option list of checkbox <tbody> Advocacy organizations Business community - Small and Medium-sized Clergy...
  2. J

    Identifying overlapping date ranges with single criteria

    Hi All, I have a single table query containing rows of members identified with a member number and their eff date and end date. There are members in this table with the same member number whose date span on one row overlap wit their date span on another row. I am trying to identify these...
  3. M

    Find a cell that contains....

    I recently posted a similar request but I think I need to modify this. I have work book with a list of members. One of the column is the last name of the members. I have a workbook with a bibliography. One of the columns is a list of authors. [LN1, FN1, LN2, FN2,.......etc] In the...
  4. FracinDean

    General Questions: Member Status and Board Funding

    Hello members. This is an awesome board. I have two questions that I haven't been able to find answers to within the existing threads, FAQs, etc. They may be there -- but I couldn't find them. 1. What determines a members status ("New", "Board Regular", "Mr. Excel MVP", etc.)? 2. How is...
  5. mgirvin

    Members Upload Files to Workspace at powerbi.com?

    Dear Team, I have created a Workspace at powerbi.com and added members by e-mail. But when one of the members tries to upload, they cannot see the Workspace. I would like all the members that I have added by e-mail to be able to upload files to the Workspace. More Detail: 1) In powerbi.com on...
  6. L

    Find next available number in 2 columns on different sheets

    I have a workbook for memberships, with 2 sheets "Members Due" and Members Paid". When a member pays, their row is moved from members due to members paid. Row A on both sheets containes their membership number (I like to give them their same number every year if the stay) If someone doesn't...
  7. jakeman

    Issue with Loop

    Hello everyone - I have a loop statement that's not working correctly and I'm stuck. What I'm attempting to do is loop through an entire range of values in a single column and where a cell in that range has a value of 1, I return a value from a column adjacent to that column (3 columns away...
  8. A

    Row to Column Data distribution

    Hi All, I have tried to get data by using an excel formula. But I felt. Actually I want to generate data distribution from down row to column wise and right side. Suppose, I have some data in row 1, 2, 3 and 4 by an household ID of that household's all 4 members. Now i want to take all...
  9. M

    Macro To Populate Cells

    Hi I have a workbook with 2 worksheets - (A & B) Worksheet B holds a list of teams, I.e. Team 1 in Column A, Team 2 in Column B etc.... On worksheet A, in Cell A1, I have a drop-down with all the relevant teams on worksheet B What I would like to do, is: If for example, Team 1 is chosen from...
  10. P

    Creating an EXCEL Graph with lines and bars

    I want to create a graph which contains the following fields: - Program Name - Volume of Program Members - Sales Volume Data Point for each program The bars are across the X axis and need to be in order from lowest number of program members. It needs display volume on each bar. The y axis...
  11. H

    excel vba : how to make hidden members visible

    Hi, I tried to copy a set of data from sheet "RawData" which was filtered and paste it at sheet c but there is something wrong in the code line "ActiveSheet.Paste", it says "cannot jump to active sheet as it is hidden". When I click excel help, it says "You specified a name that is in the type...
  12. D

    Dax - filter, all, allexcept

    Hi, I have a monthly snapshot of our member data, and am trying to create a measure showing the income effects of members joining / leaving / dying etc. For example, members who have died in the month are identified by a flag column, Died_Flag. I would like to calculate the income for this...
  13. C

    Comparing Two Sets of Data and Adding a Value to a Field when Match

    Greetings, It's been a few months and I'm still piecing together my dashboard. I'm getting closer! This might sound extremely basic but I cannot find examples online, or that I can identify as what I'm looking for, that does the following. I run a report for members that contains all kinds...
  14. K

    Copy values that are next to the columns of the value found using a VLOOKUP

    Hi, So I'm working on a spreadsheet that contains information from members on different tabs. The current month's information does not include all of the member's information, so I decided to use a VLOOKUP formula to find those members in the previous month. Is there a way to make it do a...
  15. L

    list all members of an object - vba

    Hi Inside vba editor when I type range. then vba will list all the members of range, but when I type this workbooks(1).worksheets(1).range. nothing will be listed? can I force vba to list all members, anytime? Thanks
  16. H

    Power Query help

    Hi All, Hoping you could help with my current problem I have with Power Query. I have a raw data file which is updated monthly. I use Power Query to split this raw data file into a number of workbooks based on the centre code as different members are responsible for their own centre codes...
  17. D

    Weighting Question!

    Good Evening! I am having trouble getting the last step of this worksheet done. Basically I have 1 Budget and 3 projects types. I want to weight the projects by importance but maintain a balanced budget. For example: Budget: 1500 Project A: 5 Team Member Project B: 4 Team Members...
  18. B

    Extracting all items if they equal a location

    I have a spreadsheet contains the different offices for our company. I would like to extract, using a formula, all the members that work in that office. If the Office was named Alcosta, for example, and their were 10 members I would like to show all the members belong to that office. Then, in...
  19. K

    Compare between 2 values

    Hello Folks , I am working on an excel sheet where in i have business done by staff members for 2 weeks. I have 4 staff members , Need to compare their current month business from last month business. A1 has current month business 120000000 B1 has last month business 100000000 I need a...
  20. B

    Tracking additions/deletions to linked flles

    I haven't done this yet but there is a possibility that I will have to create a master file which is linked to 5 separate Excel files. We have members that don't occur in our Members database and need to manually added to our Excel files so they show up in our Leadership reports. I created an...

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