Angelfish13
New Member
- Joined
- Jan 25, 2017
- Messages
- 14
Hello,
I am currently manually creating a list in excel that is taking a very long time. I was wondering if there is a way to automate this. Please see below for an example. Thank you so much for your help!
Columns for the criteria:
<tbody>
</tbody>
List I manually enter based on columns above (another column in excel):
<tbody>
</tbody>
The list I manually enter actually takes forever because there is hundreds of names and they are all scrambled with people who have a lot of orders. All I am doing is looking who has a zero next to their name and typing their name in another column in a list format. Is there any way to have excel do this automatically with a formula or macro? Please let me know, thanks so much for your help!
I am currently manually creating a list in excel that is taking a very long time. I was wondering if there is a way to automate this. Please see below for an example. Thank you so much for your help!
Columns for the criteria:
Name | Number of Orders Placed |
Justin | 2 |
Bob | 3 |
Fred | 0 |
Sally | 1 |
Mary | 0 |
<tbody>
</tbody>
List I manually enter based on columns above (another column in excel):
People with Zero Orders |
Fred |
Mary |
<tbody>
</tbody>
The list I manually enter actually takes forever because there is hundreds of names and they are all scrambled with people who have a lot of orders. All I am doing is looking who has a zero next to their name and typing their name in another column in a list format. Is there any way to have excel do this automatically with a formula or macro? Please let me know, thanks so much for your help!