Search:

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

Search: Search took 0.01 seconds.

  1. Replies
    7
    Views
    283

    Re: Copy value from cell above if blank

    Thanks. This one worked but I already got it working with the formula below.

    =IF(Sheet1!$B2<>"",IF(Sheet1!$A2<>"",Sheet1!$A2,Sheet1!$A1),"")
  2. Replies
    7
    Views
    283

    Re: Copy value from cell above if blank

    Also did not work for what I'm trying to do but maybe it's my fault as maybe I wasn't clear enough with what I need. Ignore my first post and see the examples below. I need a formula to output the...
  3. Replies
    7
    Views
    283

    Re: Copy value from cell above if blank

    Did not work. It fixed the even number rows but now the odd ones are blank.
  4. Replies
    7
    Views
    283

    Copy value from cell above if blank

    In column A every two cells are merged (A1 with A2, A3 with A4 etc...) so my formula only works properly for odd number rows. I need the below to use the value from the cell above if A6 is empty and...
  5. Re: If cell contains data, then copy value from another cell only if it also contains data

    Works perfectly, thanks.
  6. If cell contains data, then copy value from another cell only if it also contains data

    The formula below works but returns 0 when B2 is empty. What I'm trying to do is if B5 contains data then copy B2 only if B2 also contains data, if B2 is empty I would need the cell where I have the...
  7. Re: Calculating difference in time - conditional formatting

    Sorry about that as I did not copy the whole table. I meant to say D2:E2 & B3:C3. Please see the example below


    <tbody>

    A
    B
    C
    D
    E
  8. Calculating difference in time - conditional formatting

    Hi all

    I would like to calculate Time-in - Time-out and if there is less than a 9 hour difference, highlight the cells. In the example below B4:B5 & C2:C3 would be highlighted.


    <tbody>...
  9. Military time to regular time in different timezone

    Hi All

    I would like to convert a list of military time in Column C to regular time in a different time zone (+3hr) and also deduct 45 minutes off the new calculated time.


    <tbody>
    Scedule
  10. Replies
    14
    Views
    498

    Re: Not detecting all arrays

    This works great. Thanks for all the help
  11. Replies
    14
    Views
    498

    Re: Not detecting all arrays

    This worked with that worksheet but when I tried it with another one with different keywords it deleted some of the arrays with numbers included. Ex.


    With the above it only detected First Floor...
  12. Replies
    14
    Views
    498

    Re: Not detecting all arrays

    The below is almost working perfectly for what I need. It deletes all rows that don't contain the exact keywords in column D. There are some cells in column D with the word "OFF" in it and it is not...
  13. Replies
    14
    Views
    498

    Re: Not detecting all arrays

    I decided to stick with the first code that uses perfect match to avoid mistakes since some of the keywords I will be using are similar. Thanks for the help
  14. Replies
    14
    Views
    498

    Re: Not detecting all arrays

    This fixed the issue. Thanks



    This one almost worked, it did the opposite of what I needed. I wanted to keep the rows containing the array and delete all other rows.

    I'm wondering if it's...
  15. Replies
    14
    Views
    498

    Not detecting all arrays

    I'm using the code below to delete all rows that don't contain a list of words. For some reason it is deleting the cell that contains the word Apple and keeps the other three with Banana, Orange &...
  16. Delete rows if they don't contain multiple specific text

    I would like to delete all rows that don't contain multiple specific text in column D. The below code works great for two options but I have a list of twelve words that I would like to add.


    ...
  17. Re: Delete rows from the bottom with the last different date

    Thanks for this. I replaced .ClearContents with .EntireRow.Delete and it worked great.
  18. Delete rows from the bottom with the last different date

    Hi all

    Is it possible to create a macro to delete the last rows from the bottom of the worksheet with a different date? In the example below I would need it to select and delete from rows 1161 to...
  19. Re: Macro to insert new row when value changes with data from the cell above & autosum

    This one works perfectly. Thanks for the help
  20. Re: Macro to insert new row when value changes with data from the cell above & autosum

    Column D is Col B minus Col A
  21. Re: Macro to insert new row when value changes with data from the cell above & autosum

    Thanks for your help. This added a new row and copied the data from row C but the total for row D didn't work. Also is it possible to insert a new row like the rest on the last row with data in it.
  22. Macro to insert new row when value changes with data from the cell above & autosum

    Hi all

    I would like to insert a new row after the value changes in column C and in the new row copy the value from the cell above in column C and display the total in column D.
    ...
Results 1 to 22 of 22