board

Mark as solution Although the "Mark as solved" concept has never been used at the MrExcel Message Board since Bill launched the forum in 1998, the new feature "Mark as solution" is different in that marking a post as a solution does not lock the thread. This allows members to offer alternative...

Hello Board: I have created a dynamic crostabulated table using the new XLOOKUP function with SORT and UNIQUE so that I can get dynamic toggle between rows and columns. It worked pretty good. The problem I am having is when I am trying to use SUMIFS to dynamically aggregate both row and column...

I am building a fantasy football board. The board is finished and working, but the next step into it would be having the players fall off the list on the individual positions sheets once selected. i am having trouble with it and any help would be appreciated.

I am running the following code to copy and paste from a hidden sheet. I used macro recorder. Sub test12()' ' test12 Macro ' ' Application.ScreenUpdating = False Sheets("Make Ready Board (2)").Visible = True Sheets("Make Ready Board (2)").Select Range("A2:R2").Select...

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

Attempting to calculate the available annual man hours per production worker based on their years of service. Their annual leave both vacation and sick are based on their years on board. Knowing this I can then calculate what their true production man-hours per year are. Having trouble...

I need a formula that will return the contents of a cell if two other cells contain one of the numbers in two different specified arrays. I laid out the argument in another question on this board but may not have done a very good job of if. It can be found here...

Morning folks I have a spreadsheet that has a column with peoples job titles in. Examples of how the data looks is as follows: HSCB*002*IRB Board Member*Contract* HSCC**Commissioning Manager*CS* In another column I would like to bring through the job title that can be found after the second...

I am currently using CORREL and I would like to be able to calculate "cosine similarity". I have searched but not found anything on this message board. https://en.wikipedia.org/wiki/Cosine_similarity

Hi All, I hoping for some advice on how to make a team planning board which reduces the employees holiday entitlement when a holiday is added to the board. Please see below picture to get an idea of what I am looking to create :) - the sheet only needs to capture holidays as a reducing value...

Back Story: A couple years ago I created a FF Draft Board for my fantasy league. I hook up my laptop to my two smart TVs. One screen shows the draft board. The second screen shows each team's roster as they are drafting. The draft board will fill in the players team and position after their name...

Hi, All I have a macro that will send an email when it is triggered...But it will only send if my outlook is open. Is there a way to make this work without having to open my email first? Here is the macro I have. Sub Button7_Click() Worksheets("Tracker").Unprotect Password:=""...

Hi All, I am not sure that this is the correct place to post this, but I have a VBA question. I found a set of code online to do what I desire, but I need to modify it to suit my needs. What I am doing is this: I have a set of Names and values separated in my excel sheet as "Divisions" ex...

Hello everyone, Maybe you are familiar with word Gerber, maybe you are not. It's a file that contains X/Y coordinates, it's most commonly used in different types of Industries, mainly PCB manufacturing and PCB assembly. I need excel to translate form1 to form2 Form1 Examples: %FSLAX24Y24*%...

Dear MrExcel Forum, Thanks for everything. I've been coming here now and again since I started using Excel and every time have had quick replies and great answers from your active and very knowledgable board participants. This clearly is a very well managed message board and provides a great...

Could find anaything about this looking across the Board. Mac

Hi guys, See below, I have used the following formula intending to retrieve the red bits. =LOOKUP(MID(A2,3,2),$J$1:$K$5)&LEFT(C2,5)&"-"&D2&"_"&"PN_"&B2 instead, it Returns as: Finance_Department_43107-43287_PN_876789 I tried to Change the Format cells as Dates, it still won't work. oddly...

Hello Board, Is there a way to set where the MsgBox() function displays on the screen? The Board has helped me previously with an elaborate use of Text boxes but I'm just looking to call MsgBox(), with its Yes/No/Cancel/etc. options and place that question-box in a corner that won't...

Okay, this will need some preface. A lot actually. Bowling lanes are dressed with oil. For my example, there is one moving nozzle that squirts oil on a static brush. This is then transferred to a moving, round brush by being in contact with the static brush. The round brush, called a buffer...

I used to have subscriptions to several sub-forums: "About this board", "Lounge", "General Excel discussion", which generated each day an email with a report of new posts. It partially stopped working some time ago. At the moment I only get a summary of "About this board", the other two...