Formula to list floors based on data input

[chullan88]

Hi,

My input would be two cells :

No of basements:2
No of floors:3

I need a formula to list the floors horizontally according to the above data:

For eg: as per above data,output should be:

Basement 2 | Basement 1| Ground Floor| 1st Floor|2nd Floor|3rd Floor|Roof Floor

Thanks in advance..

[AliGW]

The problem with this is the illogical aspects of this: how is Excel to know that the basements should be listed in reverse order, that there are also ground and roof floors to add, and the the floors should be listed in ascending order?

[chullan88]

Hi AliGW,

Thanks for the reply..

Unfortunately these reasons are the challenges in forming a good solution to this problem..

Hope the gurus can help...

[AliGW]

Not without some more input from you. What other parameters are there? Excel cannot make assumptions any more than we can. What else needs taking into consideration? Give some more examples, please.

[chullan88]

What other parameters are there? What else needs taking into consideration?

Nothing more..
As a general rule, Roof Floor should be the last
Ground Floor should come after the last basement floor
If there are no basements, the list should begin with Ground Floor..
The no of floors will never be zero in my case..so no need to consider that possibility..

[AliGW]

Give some more examples, as requested in post #4. Attach a workbook.

[chullan88]

Attached with examples..

[Bo_Ry]

Please try at D1

Please Login or Register  to view this content.

[chullan88]

Excellent!
Thanks a lot.. Bo_Ry