Currently, I have the results of a bat file to ping all of my IPs that show a result in column A, starting at A2.
I have the following formula starting in B2.
. This will indicate which lines did not ping. However, the data I need is also one cell above that line.
I will need another formula in row C2 that states if B3 was true, make the cell before (B2) true and down the column.
The number of rows will be different each week, is there a way in the macro you can say extend to the last line in column A? Here is what the spreadsheet currently looks like below.
<tbody>
</tbody><colgroup><col><col></colgroup>
Thank you
I have the following formula starting in B2.
Code:
=ISNUMBER(SEARCH("100%", A2))
I will need another formula in row C2 that states if B3 was true, make the cell before (B2) true and down the column.
The number of rows will be different each week, is there a way in the macro you can say extend to the last line in column A? Here is what the spreadsheet currently looks like below.
Pinging 10.105.205.79 with 32 bytes of data: | FALSE |
Request timed out. | FALSE |
FALSE | |
Ping statistics for 10.105.205.79: | FALSE |
Packets: Sent = 1, Received = 0, Lost = 1 (100% loss), | TRUE |
FALSE | |
Pinging 10.105.136.231 with 32 bytes of data: | FALSE |
Request timed out. | FALSE |
FALSE |
<tbody>
</tbody><colgroup><col><col></colgroup>
Thank you