excel problem

[nazmul_bd08]

if 1st column 5 then 2nd column show 1-5 pls solve this problem

 

[amrit1186]

Hi Nazmul


Welcome to the forum. Your question is not very clear. I think you want to achieve the following results:


A B

5 1-5

7 1-7


For this you can use the formula = "1-"&A1

 

[cacos]

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

 

[nazmul_bd08]

HI CACOS/ALL FRIEND,


ACTUALLY MY PROBLEM DISPLAY WITH EXAMPLE SHEET

A..................................................B

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

PLS SOLVE

 

[bobhc]

Nazmul_bd08


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

 

[Debraj]

Hi Nazmukl,


Just playing around..


[A1] = A; [B1] = "0-0"

[A2] =RANDBETWEEN(1,20)&"/"&RANDBETWEEN(200,400)

[pre]

Just for some Dummmy Data.. and drag..

Now come to the point
In [B1] use formula as..

[/pre]
=(RIGHT(B1,LEN(B1)-FIND("-",B1))+1&"-"&

(RIGHT(B1,LEN(B1)-FIND("-",B1))*1)+

(LEFT(A2,FIND("/",A2)-1)*1))`


Is this whar you are looking for.. for creating Index Page for any Book...

Regards,

Deb

 

[SirJB7]

@Debraj Roy

Hi!

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?)?

Regards!