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

S.NO With indents in Excel

S

SAN04

Member
Please suggest any formula to automate Sr. Nos. with indenting in subsequent rows as below:
1.
1.1​
1.1.1​
2.
2.1​
2.1.2​
 

SAN04​

Column A s.no to come automatically once I put s.no as 1 in cell 1 of column A
How column A s.no can come automatically if You're putting it as 1?
As written For the best/fastest results, Upload a Sample File
 
vletm said:

SAN04​

Column A s.no to come automatically once I put s.no as 1 in cell 1 of column A
How column A s.no can come automatically if You're putting it as 1?
As written For the best/fastest results, Upload a Sample File
Click to expand...
vletm said:

SAN04​

Column A s.no to come automatically once I put s.no as 1 in cell 1 of column A
How column A s.no can come automatically if You're putting it as 1?
As written For the best/fastest results, Upload a Sample File
Click to expand...
It should start with 1..
 

SAN04​

As You can read three times
For the best/fastest results, Upload a Sample File
How automatic is it - if Column A s.no to come automatically once I put s.no as 1 in cell 1 of column A?
 

SAN04​

Okay, there seems to be some challenges to send a sample file.
Why do You need to times same data in A- & B-columns?
It's possible to use indents in A-columns 'automatic'.
... if You'll write A-column values as You've written in #1 reply.
 

Attachments

  • SAN04.xlsb
    15.1 KB · Views: 2

SAN04​

Many things are clearer now - maybe someone else could suggest something.
Your original ... suggestion ... is different than any of those three same pictures.
You really skip to send an Excel-file, which could give some which can use.
Of course, it could be possible someway control indents with formulas.
How about those Sr. Nos. - which You have asked?
 
vletm said:

SAN04​

Many things are clearer now - maybe someone else could suggest something.
Your original ... suggestion ... is different than any of those three same pictures.
You really skip to send an Excel-file, which could give some which can use.
Of course, it could be possible someway control indents with formulas.
How about those Sr. Nos. - which You have asked?
Click to expand...
Sr. No shd start from 1
1 No indent
1.1 - 1 indent
1.1.1 - 2 indent
1.2 - 1 indent
1.2.1 - 2 indent

And continued based on Indent
 
You must log in or register to reply here.
Back
Top