picks

  1. D

    SUMIFS formula picking up all values instead of criteria

    https://1drv.ms/x/s!AvjBsEPEq12ngT3R9p-e8rqgVZkN?e=k7e4yd I have two columns. First column =age of invoice Second column = $ I want to do SUMIFS for invoices > 365 days E6 works fine for invoices 'Not Due' E7 should pick up $0.00 but instead picks up everything Not sure why..
  2. B

    Can I do this?

    I draft a bunch of fantasy football teams and would like to take all the players I have drafted (from about 20 drafts, 28 players each) place them into an Excel file to determine ownership percentages. Trying to determine my exposure to player. The app I use to do the drafts allows me to...
  3. S

    Hide rows or access only specific rows based on userform login

    I have a tricky question. I have a workbook I am using for a game about 1000 people will be playing. The workbook consists of several sheets but the only sheets users will have access to is a sheet called "Picks". Admin users will have access to all sheets so I already have a system in place...
  4. Y

    Project Workplan Dashboard

    Hi guys, I am very new to VBA and I am looking for some help with some code that would help me at work, basically I am looking to optimize a simple dashboard for my projects Workplan for the year. The table on "2019 Plan" shows the number of projected days and to the right of it the actual...
  5. S

    Hide rows using a userform login

    I have a workbook with 3-4 sheets. I havecreated a registration and a login userform. The registration userformconsists of a Reference number, Full Name, address, email, phone, etc. andallows each user to create a username and password for logging in later. Once registered, ALL of their...
  6. J

    For each and If with worksheet function

    Trying to find time gaps based off each cell and its offset (the next cell down) in a dynamic range. My error message right now is 'object required' in the if statement. For Each cell In picks() If WorksheetFunction.Abs(cell.Offset(-1, 0).Value - cell.Value) > 0.02083 Then do something ElseIf...
  7. F

    Sum automatically picks where there is either data in cell A or cell B

    Hi all, I need the sum in cell D of either cell A OR cell B + cell C. Cell A or Cell B does not always contain data. It's either there is data in cell A or in cell B. example 1: cell A = 250000 cell B = cell C = 120 cell D = 250000 + 120 = 250120 cell A = cell B = 350 cell C = 120 cell D =...
  8. J

    Filter Exact word from Columns having No. of strings VBA

    I am using below criteria to search exact string out of a column of string sCriteria = "*" & " " & Range("H" & i).Value & " " & "*" But it only picks up the word that is preceded and followed by a word.Even if I add space at the start and end of string. Is there any way
  9. D

    VBA code to randomly pick from a list of names

    Hi, I have this code that randomly picks a different name from a list. Sub CommandButton1_Click() Dim lrcd As Long SendKeys "%^{F9}" Range("H31").Copy 'Range("C2:C7").PasteSpecial xlPasteValues lrcd = Sheets("Sheet1").Range("E" & Rows.Count).End(xlUp).Row Sheets("Sheet1").Cells(lrcd +...
  10. JTL9161

    VLOOKUP plus Conditional Formatting

    Not sure if this is do-able or even clearly explain-able. I have a fantasy baseball spreadsheet that calculates the number of correct daily picks for 20 people I have each person picks labeled as the teams "2nd name" (i.e. Red Sox, Yankees, Mets, Dodgers) I then have the scores from each...
  11. B

    Formula Improvement

    Hi, I have a table of two types of product codes (finished products with associated sub-product codes. I want to be able to search the column of sub-codes and identify all the finished product codes associated, and then to use the results of that search to draw data from a separate table. The...
  12. L

    Graph Question

    I have a simple Spreadsheet with 3 Columns,"Date, Revenue and Cost." I have highlighted the 3 Columns as my Data for the Graph. I have deleted all the Rows that would be Saturday or Sunday. So column A has Jan 1-5, there is no Jan 6 or 7 and then picks up with Jan 8. However, the Bar Graph...

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