• 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.

sequential order and display functions required.

T

tango

Member
Please help me to find a solution to my requirements: Basically, I am needing of two functions

1) Function 1 is to make a sequential list based on the ID number. It starts as "Attachment0" onwards (from Attachment0 to Attachment30).
If number column has a similar value then 'attach' columns shows sequential order (from Attachment0 to Attachment30) otherwise just Attachment0

2) Function 2 is to display the "file name" cell value in its "AttachmentX" columns based on the "Attach" column.

Hope the attached sample explain it better. Please and thank you in advance.
 

Attachments

Big Thanks Narayanan. You got it right.. By the way, is there a way to have the result all in one row (see sample attached). result could be put in another worksheet or somewhere.
 

Attachments

You must log in or register to reply here.
Back
Top