All data is copied in the first column i.e. A
Below is a sample of data that I need to work with. it is comprised of text and other weird format. The numbers that I am interested in have a space 0. example - "89.45 0"
In these figures, I need to find the values that come below a cell having value - failed.
below the cell that has failed, will always be a cell having value - node this is.
now I need to count the number of rows of decimals that are coming below the failed cell.
for example, using the below data, the data will be pasted starting from cell A1. Below the first "failed" cell value, comes "the node this is" cell, below this cell are the decimal numbers that have failed. unfortunately there is no clear end to the failed data except that the cell "node this is" is repeated. this will mark the end of the data that needs to be copied to a different location. The "failed" value can be repeated in the column, and I need the cells having the decimal formats.
To make things simple and sum up the requirement. I need the values that come under "Failed" and that is starting after "node this is" and ending before the next " node this is"
here
there
89.45 0
and there is
failed
node this is
76.98 0
lala
32.78 0
meow
12.89 0
here is
node this is
blah
98.56 0
what
failed
node this is
43.89 0
56.65 0
haha
node this is
23
54
hee
Bookmarks