can you help!!
I am trying to resolve 2 different issues in excel.
1. I want to have a validation table that only allow 6 numeric characters AND does not allow duplications. (I can do either but not together!)
2. I have set up two fields that only accept entries from two different validation tables but I also want to have a total field running on the sheet showing how many times each entry is used?
eg: Products reasons
car wheel
train engine
plane cost
So how many times car appears & how many time wheel appears with car etc.
I am trying to resolve 2 different issues in excel.
1. I want to have a validation table that only allow 6 numeric characters AND does not allow duplications. (I can do either but not together!)
2. I have set up two fields that only accept entries from two different validation tables but I also want to have a total field running on the sheet showing how many times each entry is used?
eg: Products reasons
car wheel
train engine
plane cost
So how many times car appears & how many time wheel appears with car etc.