evancaldwell
New Member
- Joined
- Jun 17, 2011
- Messages
- 1
i am trying to create a set of named ranges based on cell content.
column A contains ID numbers column B contains an ID number concatenated with either yes or no (column B indicates which ID number in column A that record is assigned to) column C contains a number.
for example:
column A___ column B___ column C
869011____ 101110no___ 500
378225____ 869011yes__ 200
254111____ 869011no___ 300
654766____ 378225no___ 100
789542____ 869011yes__ 700
798465____ 378225yes__ 400
what i want to do is create a named range for each ID number in column A where the criteria is that ID number plus yes or no in column B where the named range contains the corresponding values in column C.
so for row 1 the named range would be _869011group and would contain column C rows 2,3 and 5. because column B rows 2,3 and 5 contain 869011yes and 869011no.
for row 2 the named range would be _378225group and would contain column C rows 4 and 6. because column B rows 4 and 6 contain 378225yes and 378225no.
column A contains ID numbers column B contains an ID number concatenated with either yes or no (column B indicates which ID number in column A that record is assigned to) column C contains a number.
for example:
column A___ column B___ column C
869011____ 101110no___ 500
378225____ 869011yes__ 200
254111____ 869011no___ 300
654766____ 378225no___ 100
789542____ 869011yes__ 700
798465____ 378225yes__ 400
what i want to do is create a named range for each ID number in column A where the criteria is that ID number plus yes or no in column B where the named range contains the corresponding values in column C.
so for row 1 the named range would be _869011group and would contain column C rows 2,3 and 5. because column B rows 2,3 and 5 contain 869011yes and 869011no.
for row 2 the named range would be _378225group and would contain column C rows 4 and 6. because column B rows 4 and 6 contain 378225yes and 378225no.
Last edited:
