if 1st column 5 then 2nd column show 1-5 pls solve this problem
excel problem(7 posts) (6 voices)
Welcome to the forum. Your question is not very clear. I think you want to achieve the following results:
For this you can use the formula = "1-"&A1
Assuming the number "5" is in A1, this would work: =CONCATENATE(A1-4," ",A1-3," ",A1-2," ",A1-1," ",A1)
You can remove the " " if you wish to have no spaces between each number.
I think that's what you requested
HI CACOS/ALL FRIEND,
ACTUALLY MY PROBLEM DISPLAY WITH EXAMPLE SHEET
10 /(ANY NUMBER)SHOW......................1-10
15/(ANY NUMBER)SHOW WITH ADD(B,ROW 1)...11-25
50/ANY NUMBER)SHOW WITH ADD(B,ROW 2).....26-75
MY PROBLEM ACTUALLY LIKE ONE KIND OF LIST MARKING
Is this not the same problem that you have posted here...http://chandoo.org/forums/topic/excel-problem.
Double posting is frowned on by forum members.
Could you make your requirements a bit clearer, you ask a question and when you receive an answer you reply with the word "actually" and then describe some thing totally different to the previous question, members are here to help and they do so willingly but you may be putting members off with your changing requirements. Typing in all UPPER CASE is bad forum manners
Just playing around..
[A1] = A; [B1] = "0-0"
Just for some Dummmy Data.. and drag.. Now come to the point In [B1] use formula as..
Is this whar you are looking for.. for creating Index Page for any Book...
Should I delete one of those or you want us to feel like Clarence in Daktari, as my grandfather used to say (otherwise how could I know what he was talking about?)?
You must log in to post.