Hi All,
I have a list of items (assembly list / bill of material) as per attached file.
Can someone please help me apply a filter that will only show Data for the "committed" items which would include adjacent rows below?
Basically full Assembly only for Committed Items.
Thanks in advance
easiest if you can use a helper column.
In cell G2: =IF(AND(D2=0,NOT(ISNA(F2))),F2,IF(D2>0,G1,NA())) then copy down
You can then filter Column G, excluding the #N/A values
<<< If you have valued anyone's contributions in this thread, please click * to thank them for their efforts
This worked well - thank you so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks