Forum Discussion

TARUNKANTI1964's avatar
TARUNKANTI1964
Brass Contributor
Apr 12, 2024

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...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 12, 2024

TARUNKANTI1964 

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?

TARUNKANTI1964's avatar
TARUNKANTI1964
Brass Contributor
Apr 12, 2024
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

TARUNKANTI1964
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 13, 2024

    TARUNKANTI1964 

    More 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?

    • TARUNKANTI1964's avatar
      TARUNKANTI1964
      Brass Contributor
      May 07, 2024

      SergeiBaklan 

      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!

    • TARUNKANTI1964's avatar
      TARUNKANTI1964
      Brass Contributor
      Apr 18, 2024

      SergeiBaklan 

       

      Respected @Sergei Baklan Sir,

       Actually what that is what I want, You may find it which I shared in attached file as sample for Your understanding. Data shall be transferred as my per desire from Sheet 1 to Sheet 2 as per my attached Excel Book named “Sample in Short Form” According to Row wise. ROW number may be extended up to 30000 No's in every Sheet.

       

      Platform - EXCEL 2016

      Hope for Kind solicitation

      With Humble Regards

      @TARUNKANTI1964

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 19, 2024

        TARUNKANTI1964 

        For the sample file, let speak about Sheet2. 

        In column A you enter data manually, i.e. 61 in A2, 69 in A3, etc., correct? If not, what is the logic behind, how the shall be selected.

        In column C we just repeat the number which is in column A. Other words

        =A2 in cell C2

        =A2 in cell C3

        etc.

        Now, since we have no duplicates in column C of Sheet1, we could find License ID as

        =INDEX(Sheet1!B:B, MATCH(A2,Sheet1!C:C,0) )

        and drag it down.

         

        If we could have duplicates in column C (as well as in column A) of Sheet1, that could be another approach. But with that it's not clear how to place result, see my previous question.

Resources