Forum Discussion
Got in over my head, now I need formulas to get the right data.
A program creates an excel spreadsheet that has 2 columns, I need to know out of the 51 possible location points in column A, which ones are missing. And list those in say column D. This sample is ob...
Great Solution for 1st scenario. NOW ONTO the 2nd scenario. Column A input....
| -003-Outside Entrance Front Right Wall-003 |
| -004-Left Vestibule Front -004 |
| -005-Right Vestibule Front-005 |
| -006-Middle Entrance to Store Column-006 |
| -007-Café Entrance (including door)-007 |
| -009-Indoor Seating Area #1-009 |
| -010-Indoor Seating Area #2-010 |
| -012-Café Mens Restroom-012 |
| -013-Café Womens Restroom-013 |
| -014-Sub Shop/Pizza Area-014 |
| -015-Marche/Soup Area-015 |
| -016-Sushi/Rotisserie Area-016 |
| -017-Resturant Foods Area Salmon Case-017 |
| -018-Service Meat/Seafood Area-018 |
| -020-Donut/Bagel Area Black Pole-020 |
| -021-Bakery Cold Case Area-021 |
| -022-Produce Berry Area-022 |
| -023-Produce Cut Veggies Case-023 |
| -024-Floral Portable Cutting Machine-024 |
| -025-Produce Cut Fruit/Veggie Area-025 |
| -026-Produce Cold Case Salad Pkg Area-026 |
| -028-Floral Shop Wooden Post-028 |
| -029-Deli/OWC Area-029 |
| -030-FE Mens Restroom-030 |
| -031-FE Womens Restroom-031 |
| -032-Customer Service Desk-032 |
| -033-Register #1-033 |
| -034-Register #18-034 |
| -035-Meals-To-Go Desk (catering)-035 |
| -036-Aisle 2B Back-036 |
| -037-Aisle 5A Front-037 |
| -038-Aisle 6B Back-038 |
| -039-Aisle 9A/9B Middle-039 |
| -040-Aisle 10A Front-040 |
| -041-Aisle 13B Steel Pole-041 |
| -042-Aisle 14A Front-042 |
| -043-Aisle 16B Back-043 |
| -044-Aisle 17A Front-044 |
| -045-Aisle 20/21 Paper Towels-045 |
| -046-Aisle 22A Front-046 |
| -047-Aisle 19A Front-047 |
| -048-Dairy Milk/Egg Area-048 |
| -049-Aisle 19B Water Area-049 |
| -050-Dairy Yogurt Area-050 |
| -051-Dairy Packaged Meat Area-051 |
Out of these 51, I have 13 in this group that are assigned to a certain route. I will need to pull them out and place in another tab (SO THATS MY QUESTION SCENARIO), also will then need to see if they missed any of those 13( i will use the previous formula that was just supplied).
| -012-Café Mens Restroom-012 |
| -013-Café Womens Restroom-013 |
| -015-Marche/Soup Area-015 |
| -016-Sushi/Rotisserie Area-016 |
| -020-Donut/Bagel Area Black Pole-020 |
| -021-Bakery Cold Case Area-021 |
| -022-Produce Berry Area-022 |
| -023-Produce Cut Veggies Case-023 |
| -029-Deli/OWC Area-029 |
| -030-FE Mens Restroom-030 |
| -031-FE Womens Restroom-031 |
| -032-Customer Service Desk-032 |
| -033-Register #1-033 |
| -034-Register #18-034 |
| -035-Meals-To-Go Desk (catering)-035 |
Sorry, I didn't catch entire logic, could you please clarify a bit.
- do you have a list of all 51 locations somewhere?
- How Excel know which locations (13 in your sample) are assigned on this or that route?
- Could one location be assigned on more than one route?
- Is first list of locations contains non-assigned one?
- If so we update this list each time when new route is defined, correct?
- Do you have separate sheet for each new route, or one sheet into which all routes are collected?
Or how it works in general?
