This is the excel sheet i am making right now.
TEST.xlsx
Column A = Random numbers (in cents) and some numbers are missing
Column D = All the numbers in the range (2-35)
Column E = If E5 is true, the number in D5 is missing in Column A.
Now I want create a new list in Column G.
I want all the numbers with TRUE in Column G.
(ex: E5 is TRUE. So I want the number in D5 in Column G.
Thanks.
Bookmarks