Search:

Type: Posts; User: wideboydixon; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Re: Combine all possible combinations from single column without vba

    Public Sub GetUniquePairs()

    Dim lastRow As Long
    Dim thisRow As Long
    Dim i As Long
    Dim j As Long
    Dim k As Long

    lastRow = Cells(Rows.Count, 1).End(xlUp).Row
    thisRow = 1
  2. Re: Want script to not aply on ceartin rows and columns

    Try:



    Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
    Dim c As Range
    Cancel = True
    For Each c In Target
    If c.Row > 5 And c.Row <> 12...
  3. Replies
    3
    Views
    126

    Re: Sumproduct if cell value = "J"

    =sumproduct(($e$9:$e$297="j")*(isnumber(k$9:k$297)))


    wbd
  4. Re: Possible corruption with Named Ranges

    Try this implementation of your function:



    Sub ListNames()

    Dim nm As Name
    Dim ws As Worksheet
    Dim lo As ListObject
    Dim i As Long
  5. Re: VBA Extract unique values in multiple sheets

    It grabs A3 down on the data sheets but then has to remove duplicates / sort the entire column on the new sheet.

    WBD
  6. Re: how can i change time to AM/PM in this code

    Option Explicit
    Private Sub Worksheet_Change(ByVal Target As Range)
    ' hiker95, 12/04/2012
    ' http://www.mrexcel.com/forum/excel-q...stamp-out.html
    If Intersect(Target, Range("A2:A3000")) Is...
  7. Re: VBA Extract unique values in multiple sheets

    Try it like this (untested):



    Sub UniqueValues()

    Dim ws As Worksheet, newWS As Worksheet, r As Long, N As Long, i As Integer
    Application.ScreenUpdating = False

    For Each ws In Sheets
  8. Replies
    7
    Views
    353

    Re: Macro to sort data in an Array

    Start:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col...
  9. Replies
    3
    Views
    153

    Re: Conditional rank on three criteria

    Quick note that although these two solutions are based on the same logic and provide the same values on the example data, if there are any ties on cost then they will not. See below:

    <b></b><table...
  10. Replies
    3
    Views
    153

    Re: Conditional rank on three criteria

    I think you can use COUNTIFS:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  11. Re: VBA to compare rows in two different sheets and if they match highlight in red

    Based on Fluff's code:



    Sub CheckRows()
    Dim cl As Range
    Dim Ws1 As Worksheet
    Dim Ws2 As Worksheet
    Dim Vlu As String
    Dim Lc As Long
  12. Re: IF Function- To reflect changes when another column changes

    This bit doesn't make sense:



    A19>H19+7<=H19+14


    This is where I got to:
  13. Re: VBA to compare rows in two different sheets and if they match highlight in red

    You're welcome. Fluff's code (once you adapt it) is probably faster and is a little more concise. If you run into performance issues, take a look at that.

    WBD
  14. Replies
    3
    Views
    216

    Re: help understanding formula

    Let's break it down:



    IF(AND($C2=1,G2<>0),0


    If LENTH is 1 and the value under 30/06/2016 is not 0 then the value is 0.
  15. Replies
    2
    Views
    168

    Re: Do Search Criteria

    I think you should split the If statement over multiple lines like this:



    Do Until Range("A" & R).Value = ""
    If Sheets("checkSmart").Range(QRiskRule1 & R).Value = "Annual Review" _
    Or...
  16. Re: VBA to compare rows in two different sheets and if they match highlight in red

    Comparing an entire row is quite complex. It would be better if you had a unique value to test against. However, in order to check the whole row you could try something like this:



    Sub...
  17. Re: Count Number of Employees Absent Within Dates

    Oops. I anchored the column not the row. Change A2 to this then copy across:



    =COUNTIFS('Employee Leave Tracker'!$C:$C,"<="&A$1,'Employee Leave Tracker'!$D:$D,">="&A$1)


    WBD
  18. Re: conditional formatting based on number of days between two dates

    Steps:

    1. Highlight the cells in Column B that you want to format
    2. Choose Conditional Formatting -> New Rule from the menu
    3. Select the option to "Use a formula to determine which cells to...
  19. Re: Count Number of Employees Absent Within Dates

    In A2:



    =COUNTIFS('Employee Leave Tracker'!$C:$C,"<="&A$1,'Employee Leave Tracker'!$D:$D,">="&$A1)


    WBD
  20. Re: Conditional Concatenation of Multiple IP Address Values Into One Cell

    Thanks Rick; I missed the follow up.

    I would agree here but with a small mod on the first part:



    =IF(COUNTIF($A$1:$A$12,LEFT($D$1,15)&"*"),TEXTJOIN(",...
  21. Re: Counting rows between each specific value

    Not sure how efficient this will be based on how big you data set it but you could use this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  22. Replies
    4
    Views
    177

    Re: If formula

    Or is it like this?

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  23. Replies
    3
    Views
    202

    Re: VBA Error handling Loop

    Welcome to the forum. Please use code tags around code; it makes it easier. You could try like this:



    On Error Resume Next

    Dim sws As Worksheet
    Dim tws As Worksheet
    Dim cel As Range
  24. Replies
    2
    Views
    209

    Re: Day of week

    You'd have to provide a list of public holidays; Excel doesn't store that information. Once you have them then it's relatively simple:

    <b></b><table cellpadding="2.5px" rules="all"...
  25. Replies
    9
    Views
    257

    Re: If statements with a blank result

    Cool. It's just using a hard-coded VLOOKUP table. See here:

    https://exceljet.net/formula/self-contained-vlookup

    WBD
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4