dilleyo725
Board Regular
- Joined
- Jan 31, 2006
- Messages
- 65
I'm looking for a formula to do the following and seem to be stuck.
I have a log that tracks merchants who have been approved. I want to track (on a separate sheet) ONLY the merchants who have been approved and the corresponding approval dates. So ideally, if I enter the information in sheet 1, and specify that "yes" the broker was approved in Col C, it will automatically update the list of approved merchants and the dates on sheet 2. I started by implementing an "IF" formula but the problem with that is that it produces gaps on sheet 2 based on a merchant is approved or not.
Column headers are as follows:
Col A = Date file received
Col B = merchant name
Col C = Approved?
Col D = Date approved
Any suggestions on how to accomplish this?
I have a log that tracks merchants who have been approved. I want to track (on a separate sheet) ONLY the merchants who have been approved and the corresponding approval dates. So ideally, if I enter the information in sheet 1, and specify that "yes" the broker was approved in Col C, it will automatically update the list of approved merchants and the dates on sheet 2. I started by implementing an "IF" formula but the problem with that is that it produces gaps on sheet 2 based on a merchant is approved or not.
Column headers are as follows:
Col A = Date file received
Col B = merchant name
Col C = Approved?
Col D = Date approved
Any suggestions on how to accomplish this?