board

  1. smozgur

    October 2020 Forum Update

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

    Using Dynamic Arrays and The XlLOOKUP function

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

    Building a fantasy football board

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

    Copy and paste from hidden sheet

    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...
  5. 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...
  6. H

    Multiple Nested IF functions

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

    How to use an array in an IF(AND statement

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

    Bring through job title in between two * asterisks

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

    Cosine similarity

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

    Planning Board that deducts holidays when added

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

    Fantasy Football Draft Board

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

    email macro

    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:=""...
  13. T

    Combining Duplicate Rows and Summing the Values using VBA - Beginner Question

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

    Very specific question to translate form1 to form2

    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*%...
  15. J

    Just Thanks

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

    Contacting an Administrator?

    Could find anaything about this looking across the Board. Mac
  17. J

    Issues with reverting numbers to dates

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

    Set display-positiom of MsgBox() function

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

    Spread the value of a cell into multiple cells, with lessening amounts.

    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...
  20. J.Ty.

    Forum subscriptions not working

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

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