Hi, I have the following data and I want to create a formula that will help me list all the names for which the amount is negative and type is yes. So if type is yes and amount is negative, return name. But my challenge is how to offset it so I get the next name with a type yes and a negative amount. Could anyone help please?
Name amount type
abc $(1) YES
efg $(2) NO
qwr $(3) YES
zxvv $(4) Maybe
sdgd $(5) NO
Bookmarks