member

  1. J

    Daniel Klann (dk) website

    Hi there, Does anyone know about Daniel Klann's new website / blog? From what I saw the last time he came in here was in February. https://www.mrexcel.com/board/members/dk.14/ Thank you!
  2. S

    Return lowest date across two tables

    Hello- I am new to Power BI & DAX. I am struggling to work out how to return lowest date across two tables. I want the following rules applied If deceased date blank then end date If deceased date before end date- deceased date All else end date Format Looks like Below...
  3. E

    Counting the number of blank cells between a specific value

    I am looking for a way to count the number of blank cells between a specific column value - in this case the number 1, which represents a member order that was shipped on that specific date. So in my example below, the first member would show one day between orders shipped, the second and third...
  4. H

    Formula for multiple conditon

    Sir/Mam, I would like to request for a formula that will categorize my data. As seen on table below, i have Member ID and Category. what formula will i use to have the Category to identify VIP and REGULAR customer. i have separated table that have the list of MEMBER ID which is VIP. <tbody>...
  5. R

    VBA Code to mail from excel is attaching all files in range

    Hello Everyone, This is my first post so thank you very much in advance for any help.. I am trying to send individual mail from excel to three team members. I have member name range in C column, email id range in D column and file location path range in F column. My problem is when code is...
  6. J

    debugging VBA code: compile error: member or member data not found

    Please help what's wrong with this code: results in compile error: member or member data not found Sub test() Dim rng1 As Range Worksheets.Sheet1.Range("D15").Value = "test" Stop End Sub Thanks
  7. alm395

    Hiding Used Items in Drop Down List (multiple columns)

    I have a spreadsheet I am working on. I was able to hide used items in the drop down list in column D, but I can't figure out how to carry it over to column H. What would be optimal is: 1) to have the same exact formula/drop down list that is in D:D to be in H21:H23, 2) then to have any...
  8. R

    How to make a directory in Excel

    I'm trying to make a directory in Excel. Say I have a sheet that lists all of the members of an organization such as this: Member # Name Date Joined 27 Smith, Bob 04/05/1998 42 Jones, Larry 06/07/2000 143 Wilson, Frank...
  9. A

    Where to start with a Speadsheet for calculating what points a person has accumulated

    Hi All, my first post so sorry if its in the wrong place! Im looking to make a spreadsheet for a local club which im involved with that will track their points throughout a season and show who is the winner at the end. Basically its a horse riding club and they have around five events a year...
  10. 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...
  11. 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...
  12. G

    SUMIFS Error??

    I've been stuck on this formula for like 8 hours and I am dying to solve it. I'm dealing with a household dataset from the Demographic and Healthcare Survey (DHS) with unique identifiers and household characteristics on the same row. HHID = household id SEX1 = sex of household member 1...
  13. R

    Thisworkbook property

    In the below lines the first 6 and the 11th work, but lines 7, 8, 9 and 10 don't work Do you have to use Sheets when using ThisWorkbook [myrange] = "Yes" [myrange].Offset(0, 1) = "Yes" Sheets("Sheet1").[myrange].Offset(0, 2) = "Yes" Range("myrange").Offset(1, 1) = "Yes"...
  14. J

    How to indicate tell Excel that if someone has accomplished all training on certain training, mark an "X" in a box?

    I'm a special needs Excel user so that Title is a good as I could get for a description. But I added photos to help. Basically, my job requires me to track training for pilots. However, what I would like to do is to have two spreadsheets talk to each other. The first image is a picture of...
  15. S

    Protect the Workbook & share

    Hello All, I have a workbook, which is placed in a shared drive, as i now need to update the work allocation & for each team member in different sheets under there name. Help required; 1. Need to protect the columns in all the sheets of the team member & allow few columns AB to AZ to allow...
  16. K

    Pop-Out Tables for relevant data

    Hello, I apologize in advance because my question is going to be vague. A year or so ago a collegue sent me an excel workbook which had the ability to click on certain fields wihtin the summary page and the data related to that cell would break out in a new table on a new tab. I have a list of...
  17. H

    Filtering in locked sheets

    Hi We produce compliance templates for the rest of the business to use. The template itself is locked, with the exception of cells we are happy for team members to type in to. Each team member has a row that includes -some free text cells (unprotected) - some formula cells (projected) A...
  18. U

    Make my UserForm a "Multi-Tasker"

    This UserFormAddMembers code is used to add new members to Sheets(“Members”) I wish to use the same UserForm to update Member Data when cells are empty. Private Sub UserFormAddMembers_Initialize() Dim i As Long With Sheets("Members") For i = 2 To .Cells(Rows.Count, "C").End(xlUp).Row...
  19. G

    SUMIF over multiple columns

    Hi all, Apologies if this is a duplicate post. I have read a few posts around this subject, but all are numerous years old and none of the suggestions have worked on my sheet so far! I have a spreadsheet containing number of orders processed on a daily basis and I would like to add these up to...
  20. A

    Extract using power query or VBA

    I have a data that is in raw form i want to extract 3 rows and convert them to the columns. Row are E-mail, company name which is always below member id and rep. I have also bold the rows which need to be converted to columns. I have about 10000 rows of data <tbody> <tbody> 1. MEMBER ID...

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