member

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!

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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