ItalianPlatinum
Well-known Member
- Joined
- Mar 23, 2017
- Messages
- 793
- Office Version
- 365
- 2019
- Platform
- Windows
Hello - I couldn't find anything to uniquely accomplish what I am ultimately trying to do.
- I have a grid of data where column A7 down is my account #
- Starting at O6 to no end zz6 say for sake of argument where the accounts are grouped by a group #
- Currently I manually update the grid to place an X if the account is in the group #
- my file is going to grow exponentially so I can no longer manually support
Book1 | |||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | |||
1 | Count | 10 | 2 | 2 | 6 | 4 | 10 | 2 | 10 | 6 | |||||||||||||||
2 | Purpose | Tracking | label | ship | Needs | XXX | XXX | XXX | XXX | XXX | |||||||||||||||
3 | Owner | Team 1 | Team 1 | Team 1 | Team 1 | Team 1 | Team 1 | Team 1 | Team 1 | Team 1 | |||||||||||||||
4 | Unique | Unique | Basic | Unique | Basic | Unique | Basic | Unique | Basic | Basic | |||||||||||||||
5 | Account | Desc 1 | Desc 2 | Account # | Name | Filler | Filler | Filler | Filler | Filler | Filler | Filler | Filler | Filler | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 | Group 6 | Group 7 | Group 8 | Group 9 | ||
6 | 10000 | 20000 | 30000 | 40000 | 50000 | 60000 | 70000 | 80000 | 90000 | ||||||||||||||||
7 | 1 | Large | L1 | XX1 | J | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | X | X | X | ||||
8 | 2 | Large | L2 | XX2 | M | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | X | X | X | ||||
9 | 3 | Large | L3 | XX3 | L | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | X | X | |||||
10 | 4 | Large | L4 | XX4 | O | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | X | X | |||||
11 | 5 | Medium | L5 | XX5 | P | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | X | ||||||
12 | 6 | Medium | L6 | XX6 | Q | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | X | ||||||
13 | 7 | Medium | L7 | XX7 | R | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | |||||||
14 | 8 | Small | L8 | XX8 | S | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | |||||||
15 | 9 | Small | L9 | XX9 | T | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | |||||||
16 | 10 | Small | L10 | XX10 | U | NA | NA | NA | NA | NA | NA | NA | NA | NA | X | X | X | X | |||||||
Grid |
Cell Formulas | ||
---|---|---|
Range | Formula | |
O1:W1 | O1 | =COUNTA(O7:O10000) |