Hi All,
Im trying to get specific Row data from table 1 to table 2 IF column H on table 1 has been completed
Please point me in the right direction
Hi All,
Im trying to get specific Row data from table 1 to table 2 IF column H on table 1 has been completed
Please point me in the right direction
I3=COUNTIF($H$3:$H3,"<>"&"")*1
B15=INDEX($A$2:$I$10,MATCH($A15,$I$2:$I$10,0),MATCH(B$14,$A$2:$J$2,0)) and drag across.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
This is excellent.
But is there a way to have the COUNTIF column skip a value of 0?
Seems to be including a value of 0 and i dont want this?
Explain more.
Since in your file there are no items with a zero, in table 2.
I changed the COUNTIF to reference the length column instead of the description
With Table 2 - when i filter it to only show lengths with a value greater than 0 the item column is not uniform (1,2,3,4,5,6 etc)
I3 =if(or($d3="",$d3=0),"",countif($h$3:$h3,"<>"&"")*1)
The data is inconsistent. Why is ther PB04 in row 7, there is no other data in that row.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks