Search:

Type: Posts; User: Scott T; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.09 seconds.

  1. Thread: Pulling data

    by Scott T
    Replies
    2
    Views
    105

    Re: Pulling data

    Is this what you want?

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

    Re: IFERROR Formula help

    IFERROR(value, value_if_error)
    If value does NOT return an error then the result of value is displayed.
    If value does return an error then value_if_error is returned.

    for example...
  3. Replies
    5
    Views
    106

    Re: IFERROR Formula help

    Your last iferror does not have a value-if-error that is the value to return if there is an error
  4. Re: Index Match Return Second Column, not first

    <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 width="25px"...
  5. Replies
    3
    Views
    85

    Re: Drop Down List Based On A Cell Value

    In Data validation
    pick list
    Where I1:I2 is the list for over 10K and H1:H2 is the list for under.
    You did not say what should happen if it is equal to 10K. So if needed change from > to >=.

    in...
  6. Replies
    1
    Views
    96

    Re: SUMPRODUCT / INDEX MATCH Question

    Since this formula does not reference the states on sheet 1 you will need make sure it refrences the correct cities on sheet 2. If they are listed in the same order you can copy across.
    ...
  7. Re: Data Matching Names from One Spreadsheet to Another

    Try

    <TBODY>

    A

    B

    C
  8. Replies
    9
    Views
    258

    Re: Calculating elapsed hours with weekends.

    RED= start date
    Blue= end date
    F2:F7 = holiday list

    ...
  9. Replies
    5
    Views
    157

    Re: IF and MID and ELSE

    You can use OR

    =IF(OR(MID(B18,2,8)="01330701",MID(B18,2,8)="01732401",next sequences goes here,.. ),"11-13 hours","")
  10. Re: Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

    In Acrobat under the File menu select "Export to" then "Spreadsheet" then "Microsoft EXCEL workbook"
  11. Re: Hello Excel gods Please how can I convert a PDF file to Excel is there a good way to do ?

    If you have Acrobat then then you can export it as a spread sheet.
  12. Replies
    3
    Views
    143

    Re: Fill blanks macro

    Select the area and then hit F5 to bring up the go to box.
    Select Special...
    Then Select Blanks
    Type what you want in the cells then press CONTROL and ENTER
  13. Replies
    9
    Views
    258

    Re: Calculating elapsed hours with weekends.

    Forgot to account for if it is a work day but before 6AM this should cover that.

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

    Re: Calculating elapsed hours with weekends.

    Try
    <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 width="25px"...
  15. Replies
    19
    Views
    768

    Re: Match function in reverse direction

    If match is working in reverse then the line with here would be 1 and the row above would be 2...
    So is it just the direction of the lookup that is reversed are both the direction and the row...
  16. Replies
    9
    Views
    215

    Re: Help conditional formatting not working

    If you want code to run automatically you can use a change event.
    This should be put in the sheet module.


    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target,...
  17. Replies
    9
    Views
    215

    Re: Help conditional formatting not working

    If you are willing to use VBA then this should work


    Sub checkdups()
    Dim rng As Range
    Set rng = Range("A2:A310")
    For Each cell In rng
    For Each mcell In rng
    If cell = mcell And...
  18. Replies
    1
    Views
    117

    Re: How do i calculate margin cost

    Gross profit margin = (Net sales-Cost of goods sold)/ net sales

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse:...
  19. Re: AutoFit Row and add 5 to row height via VBA

    This will auto fit row 7 then add 5 to the height. change to fit what you need.


    Sub adjrowheight()
    Rows(7).AutoFit
    myheight = Rows(7).RowHeight
    Rows(7).RowHeight = myheight + 5

    End Sub
  20. Re: Way to use type ahead in a validation list?

    This video show how to type in part of a name and have the list update. It used the new dynamic arrays

    https://youtu.be/Z-h2UER3b_0

    If you do not have the new dynamic arrays then you will can...
  21. Replies
    5
    Views
    167

    Re: Lookup and Populate cell

    I assume you want to use the current year for the number of days in Feb since there are sometimes leap years.

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  22. Replies
    3
    Views
    179

    Re: User Name Based Drop Down

    Sounds like you want depended data validation.

    see video for details

    https://youtu.be/So51kA_LVK8
  23. Replies
    3
    Views
    170

    Re: Constantly Changing Password Macro

    If I understand what you want correctly you could have a input box where the user types in the password.

    something like


    Sub prosheet()
    Dim pw As String
    pw = InputBox("enter password")...
  24. Replies
    3
    Views
    1,589

    Re: Trying to test HTML Maker

    You should have the need code in your clipboard so when you come the forum you can start/reply to a thread and past the code.
  25. Thread: Lookup Help

    by Scott T
    Replies
    2
    Views
    137

    Re: Lookup Help

    <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 width="25px"...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4