validate 1 item has 5 variations; if not add missing variations

**ccampbell14** · 09-25-2013, 11:23 AM

How do I validate the assigned number (Column A) has 5 versions (Column B)?
AND if the number in Column A does not have 5 versions, how do I automatically add/insert the missing versions? (not sure if a formula or macro would be better to do all of this in one 'transaction'/command??)

Thank you!
Cheri

**daffodil11** · 09-25-2013, 01:02 PM

Are you able to provide a sample of your work?

The variations aren't listed, so it's difficult to write a formula to automatically include them.

**ccampbell14** · 09-25-2013, 02:55 PM

For some reason, I am not able to attach a file; below is a sample of the data: Column A = Assigned Number
Column B = the corresponding 1-5 variations; 'assigned numbers' 10001-10003 meet the requirement; 13002 & 13003 do not (hope this helps) - Thanks again!!

Assigned Number Item Number
10001 1211.10001
10001 1212.10001
10001 1213.10001
10001 1214.10001
10001 1215.10001
10002 1211.10002
10002 1212.10002
10002 1213.10002
10002 1214.10002
10002 1215.10002
10002 1341.10002
10002 1342.10002
10002 1343.10002
10002 1344.10002
10002 1345.10002
10003 1111.10003
10003 1112.10003
10003 1113.10003
10003 1114.10003
10003 1115.10003
13002 1214.13002
13002 1215.13002
13003 1214.13003
13003 1215.13003

**daffodil11** · 09-25-2013, 03:03 PM

There appears to be 10 variations in Column B for 10002.

10002 1211.10002
10002 1212.10002
10002 1213.10002
10002 1214.10002
10002 1215.10002
10002 1341.10002
10002 1342.10002
10002 1343.10002
10002 1344.10002
10002 1345.10002

I would ultimately write a formula to pull the unique values out of Column A.

Then I would write another formula to iterate each copy of the unique values 5 times, and put one of the variaitons alongside each unique item and have the process repeat itself.