# Search:

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

1. ## Thread: Copy value from cell above if blank

by Mux99
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. ## Thread: Copy value from cell above if blank

by Mux99
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. ## Thread: Copy value from cell above if blank

by Mux99
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. ## Thread: Copy value from cell above if blank

by Mux99
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. ## Thread: If cell contains data, then copy value from another cell only if it also contains data

by Mux99
Replies
2
Views
111

### Re: If cell contains data, then copy value from another cell only if it also contains data

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

by Mux99
Replies
2
Views
111

### 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. ## Thread: Calculating difference in time - conditional formatting

by Mux99
Replies
3
Views
154

### 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. ## Thread: Calculating difference in time - conditional formatting

by Mux99
Replies
3
Views
154

### 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. ## Thread: Military time to regular time in different timezone

by Mux99
Replies
1
Views
124

### 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. ## Thread: Not detecting all arrays

by Mux99
Replies
14
Views
498

### Re: Not detecting all arrays

This works great. Thanks for all the help
11. ## Thread: Not detecting all arrays

by Mux99
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. ## Thread: Not detecting all arrays

by Mux99
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. ## Thread: Not detecting all arrays

by Mux99
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. ## Thread: Not detecting all arrays

by Mux99
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. ## Thread: Not detecting all arrays

by Mux99
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. ## Thread: Delete rows if they don't contain multiple specific text

by Mux99
Replies
1
Views
147

### 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. ## Thread: Delete rows from the bottom with the last different date

by Mux99
Replies
4
Views
196

### 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. ## Thread: Delete rows from the bottom with the last different date

by Mux99
Replies
4
Views
196

### 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. ## Thread: Macro to insert new row when value changes with data from the cell above & autosum

by Mux99
Replies
7
Views
256

### 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. ## Thread: Macro to insert new row when value changes with data from the cell above & autosum

by Mux99
Replies
7
Views
256

### 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. ## Thread: Macro to insert new row when value changes with data from the cell above & autosum

by Mux99
Replies
7
Views
256

### 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. ## Thread: Macro to insert new row when value changes with data from the cell above & autosum

by Mux99
Replies
7
Views
256

### 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