Forum Discussion
Todd444_64
Jan 02, 2020Copper Contributor
IF statement
Basically a simple Franchise order form for wine. They have a list of wines and enter number of cases required in column D ie 2 cases. I would like to take all those requests and place into an orde...
Alan_Murray
Jan 02, 2020MVP
Todd444_64 It sounds like the simplest method would be to just Filter the list to exclude the blanks and zero response and then copy and paste the wines into the other sheet. Then sort them into the order you want for printing.
I can't see the need for the IF function in this scenario.