Chaostheory72
New Member
- Joined
- Oct 3, 2021
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Going to do my best to describe my issue. I have a spread sheet that tracks welds we are making on a project. The project will have welds labeled 1-1000. These welds will either be accepted or rejected. If the weld is rejected it will have a reason why listed in another cell. I have everything setup to auto populate and calculate to a main summary page for easy to read results for the end user. With that being said is there a formula that would allow all the rejected said welds to be copied to the summary page. I only want it to copy and display the rejected numbers on the summary page. But if the criteria is met and say weld 1 is rejected I would like the summary page to display "1" and in the adjacent cell to copy the text for why the weld was rejected. I have gotten this formula to work for copying all the said rejected welds to the summary page. =INDEX($C$3:$C$10,MATCH(0,COUNTIF($G$2:G2,$C$3:$C$10)+($B$3:$B$10<>$E$3),0))
I am lost on how to get the summary page then to compare the results to other page and copy over the reason why said weld was rejected.
Attached is my example which hopefully helps more than my ramble above. Any help would be greatly appreciated.
I am lost on how to get the summary page then to compare the results to other page and copy over the reason why said weld was rejected.
Attached is my example which hopefully helps more than my ramble above. Any help would be greatly appreciated.