willow1985
Wellknown Member
 Joined
 Jul 24, 2019
 Messages
 718
 Office Version

 365
 Platform

 Windows
Hello
I need help with acquiring a random 12 numbers from Column A in the blue table (right). No numbers can be duplicated on the list (column A on the left) and I need the formula to only select Work Order numbers that have an "N" in column E in the table (right)
(see below picture)
I hope I am explaining this well...
Thank you to anyone who can help
Carla
I need help with acquiring a random 12 numbers from Column A in the blue table (right). No numbers can be duplicated on the list (column A on the left) and I need the formula to only select Work Order numbers that have an "N" in column E in the table (right)
(see below picture)
I hope I am explaining this well...
Thank you to anyone who can help
Carla