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
TARUNKANTI1964's avatar
TARUNKANTI1964
Brass Contributor
Apr 13, 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 19, 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.

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

        SergeiBaklan 

        Respected Sergei Baklan Sir,

         

        Yes, repeated Chasis Number such as Chasis No. 61 which would be found in Sheet 1, Column – A and Row – 12 and it also must be found in Column – C, otherwise it will not be otherwise, it will definitely be found, actually data in Column B and in Column C is basic data and data in Column B is co related (fixed) with data in Column C row wise as per my shared excel book “SAMPLE IN SHORT FORM”

        Now I need all Chasis No which would be found in Column A, which are repeated with Chasis No also definitely found in Column C along with License No as per Row found in Column B that would be Transferred with Excel Formula or Excel VBA Code to Sheet 2 as shown in my shared file as marking with RED Highlighted which I had done it manually from Sheet 1

         

        With Humble Regards

         

        @TARUNKANTI1964

Resources