The attached example file is a traceability system in which there are two sheets. One is Traceability having requirements with unique ids. The other is Test Cases which has various test cases with their own unique ids. The current macro and formula in there, puts test cases ids in a separate column in requirements sheet. The issue is that, I see test cases mapped to '16.2.0' in '6.2.0' and ones mapped to '16.2.1' in '6.2.1'.
Attached example2.xlsm with the scenario..
Reference Thread - http://www.excelforum.com/excel-gene...ml#post2263009
I've replied to your original thread.
Harsh, if you have a new question, please don't post in one of your old threads and at the same time start a new thread about the same topic. This is essentially duplicate posting and wasting people's time.
Thanks
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Bookmarks