Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.88 seconds.

  1. Re: Vlookup not working and it's driving me MAD!!!

    In relation to this comment, please refer to #4 of the Forum Rules, especially the second paragraph.
  2. Replies
    2
    Views
    65

    Re: Countif no duplicates

    A very minor thing but you could save a little processing by removing that red $
    For example, in row 4 of your sample data, the fact that the logical test in your if statement is TRUE, means that...
  3. Replies
    2
    Views
    43

    Re: Code for character allowance in cell

    Try this Worksheet_Change event code. To implement ..
    1. Right click the 'MC LIST' sheet name tab and choose "View Code".
    2. Copy and Paste the code below into the main right hand pane that opens...
  4. Re: Same Data (date) Validation List for 2 cells; 1 cells to be greater than other cell

    Would this be any use?
    I have my Start Date Validation cell as A1 on Sheet2 and End Date DV cell as A2 on Sheet2.

    On Sheet 1 I have the list of dates in A1:A24 & formulas as shown, copied down.
    ...
  5. Replies
    6
    Views
    110

    Re: count until "X" number appears again

    If you are interested in a formula that doesn't require the Ctrl+Shift+Enter confirmation and also doesn't matter if there were blanks within the column A numbers then you could try this. Like...
  6. Re: VBA: If Range Contains Cell Value Copy than del

    Still not very clear but I notice that you have not made the red & blue changes that I suggested in post 5. That would be a good place to start.
  7. Thread: colour row

    by Peter_SSs
    Replies
    3
    Views
    31

    Re: colour row

    If you did want a vba solution, then I think gallen's Worksheet_Change code needs some tweaks to be robust and do what you want. To implement ..
    1. Right click the sheet name tab and choose "View...
  8. Thread: colour row

    by Peter_SSs
    Replies
    3
    Views
    31

    Re: colour row

    1. Select from A2 to L50
    2. Home ribbon tab -> Conditional Formatting -> New rule ... -> Use a formula to determine which cells to format -> Format values where this formula is true:- =$L2="Yes" ->...
  9. Re: VBA: If Range Contains Cell Value Copy than del

    I'm afraid that I really have no idea what that means.
  10. Replies
    2
    Views
    19

    Re: VBA subtotal depending on indent

    Quite likely, but some more specific detail about exactly what you have, where and what result you want, where would help.
  11. Re: VBA: If Range Contains Cell Value Copy than del

    Almost. If you want to operate on sheet "path" I would add the blue bits and remove the red bits. Also, always best to declare (Dim) your variables.

    Sub Poster_Index()
    Dim ws As Worksheet

    ...
  12. Re: Splitting out title, first name, middle name, last name

    If you are happy to deal with the few miscreants that kweaver's formula might leave, then here are some considerably more compact formulas that I think should still do the same job.

    <b>Extract...
  13. Re: IF any of 10 columns equals any of 4 other columns

    Have I understood correctly?

    <b>interference</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:8pt; background-color:#ffffff;...
  14. Re: VBA: If Range Contains Cell Value Copy than del

    Give this a try in a copy of your workbook.
    I have assumed no empty cells among the column A data & same for column C.


    Sub Poster_Index()
    With Range("A1:E" & Range("C" &...
  15. Replies
    13
    Views
    204

    Re: Sum numbers between two specific cells

    Edit: Oops, FormR posted basically same thing while I was composing my post. :)

    See if this is any use. It doesn't matter whether the 2 specified numbers are in the correct order (left to right)...
  16. Re: How do I automatically count the finished goods of raw Materials?

    Duplicate to https://www.mrexcel.com/forum/excel-questions/1107631-countif.html

    Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per...
  17. Replies
    8
    Views
    233

    Re: 0 formula with blank cells

    :confused: I don't really understand that as the idea of the TEXTJOIN function was to completely replace the longer original formula.

    Anyway, if you have something that you are happy with that's...
  18. Re: INDEX / MATCH / OFFSET / AVERAGE Formula

    Welcome to the MrExcel board!

    Because the OP wanted to start the average 1 column to the right of where the 22222 was found in the heading row and end the average 3 columns to the right of where...
  19. Re: Help with VBA for background color in selected cells.

    Good idea to try a fresh start! You're welcome. :)
  20. Replies
    7
    Views
    198

    Re: Count of cell blocks

    Ah, not your mistake. I just didn't realise that you were using my sample data where I had changed that 2 to a 1. :)
    Now I understand.

    OK, I'm assuming the use of the regular expression UDF...
  21. Replies
    77
    Views
    6,538

    Re: Extract multiple keywords from text string

    No problem. Same to you. :)
  22. Replies
    17
    Views
    262

    Re: get value from cell in a range

    Firstly, given the above, would you still be interested in a standard formula solution?

    If so, let's consider thisIf L3 does in fact contain a space (or spaces) then that would mean that "KIRBY...
  23. Replies
    7
    Views
    198

    Re: Count of cell blocks

    OK, understand that now. My codes need a slight tweak to account for that - see below.

    First part doesn't make sense to me. Given your answer to 1 above, Jan had 4 appointments in the first block...
  24. Replies
    77
    Views
    6,538

    Re: Extract multiple keywords from text string

    Try

    Sub Components_v4()
    Dim RX As Object
    Dim aResults As Variant
    Dim c As Long, i As Long, ubaResults As Long, lr As Long
    Dim sComp As String

    Set RX =...
  25. Re: Hide Multiple number of rows based on a value

    Welcome to the MrExcel board!

    The details and example you gave don't quite add up to me. You said on Testing Records that data can be entered from row 5. With your example of 350 you said rows 351...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4