• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Same Naming For Repeated Transactions

bharath

Member
Hi,
for repeated transactions should be got same names
Please find the file
 

Attachments

  • TASK_same naming for repeated transactions.xlsx
    10.2 KB · Views: 19
Sir, Thanks for your time, but here the requirement is...if a trip like...
79781
trip name should be the same

Thank you
 
I think you may need a lookup table and take same trip name for both side as in attached sheet.
and then use VLOOKUP to fetch trip name.
 

Attachments

  • TASK_same naming for repeated transactions.xlsx
    10.6 KB · Views: 3
Try this formula solution of which required Excel 2019 and up.

In E2 array (CSE) formula copied down :

=TEXTJOIN("-",,TEXT(BASE(IFERROR(SMALL(DECIMAL(C2:D2,36),ROW($1:$20)),0),36),"[>]0;"))

79826
 

Attachments

  • TASK_same naming for repeated transactions (BY).xlsx
    11.3 KB · Views: 1
Back
Top