jenniferpattaui
New Member
- Joined
- Nov 3, 2022
- Messages
- 1
- Office Version
- 2010
- Platform
- Windows
Product | Name | Amount | Product | |||
Product A | Jane | 100 | Product A | |||
Product B | Rachel | 101 | ||||
Product A | Jane | 102 | Product A | |||
Product A | Jane | 103 | Product A | |||
Product B | Rachel | 104 | ||||
Product B | Jane | 105 | Product B | |||
Product A | Jane | 106 | Product A | |||
Product B | Rachel | 107 | ||||
Product B | Rachel | 108 | ||||
Product B | Jane | 109 | Product B | |||
Product A | Rachel | 110 | Product A | |||
Product A | Jane | 111 | Product A | |||
Product B | Rachel | 112 | ||||
Product B | Rachel | 113 | ||||
Product A | Jane | 114 | Product A | |||
Product A | Jane | 115 | Product A | |||
=IF(OR(A2="Product A",B2="Jane"),A2,"") - I used "" but I really do not want empty cells to appear
I have no time to study VBA and want Excel only for the answer
Last edited by a moderator: