I am given a list which has 1000 accounts. I am asked to find opportunities between stage0-5 that are present on these 1000 accounts. I should differentiate these 1000 accounts into 2 ways.
1 If Account has opportunity which is in stage 0-5, it should be seperated from the account that has no opportunity or opportunity that is in stage 6 or above. I need to differentiate the 1000 accounts into 2 lists so that we know which account has opportunity and which doesn't.
Your reply would be really of great help. Thanks