Forum Discussion
asking for help to solve my problem
I have an excel work book contains with two sheet as Sheet1 and Sheet2. in Sheet1 there is three columns named Column A - Chasis Number , Column B - License ID and Column C - Chasis Number. in column...
Do you mean repeated Chasis Number could be the same in any row of column A and/or in any row of column C, not the same numbers in the same row? If the former, for which rows to take License ID?
- Respected Sergei Baklan,due to my language problem i feel like i cannot clear my matter to You i apologies to You for this. actually in Sheet1 in Column A all Chesis Number must be Found in Column C but i do not know which Chasis Number in Column A are repeating in Column C in which Row. Now let's talk about License ID, actually License ID is related with Chasis Number found in Column C and it will must be transferred to Sheet2 in Column B. in Sheet2 there is also found Column A for Chasis Number, Column B for License ID and Column C for Chasis Number. now i want an Excel system by which i may get data in Sheet2 from Sheet1 as per Serially Row and Column wise. After that if You have any difficulty in understanding then You can let me know again
Many thanks to all of tech community team member
With Humble Regards
TARUNKANTI1964More clear, thank you. However, still not sure how it shall work. Perhaps you may share desired results on small sample, let say source data (Sheet1) is like
What shall be for above data in output (Sheet2)?
Another question is on which Excel your are, is that 365? If not, which version/platform?
Respected SergeiBaklan Sir
For Your understanding I have attached another sample like the one You showed me here. Please open the sample attachment I provided and You will understand what I really mean.
I am using Excel 2016
With Most Humble Regards
TARUN1964!
- Respected, actually I like to say repeat means if a Chesis Number found in Column C it may be found in Column A so in this situation I need which Chesis Number found in both Column A and C that would be transferred from Sheet1 to Sheet2 with Licence Number as per row would be found in Sheet1 in Column B
