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

excel problem

Good day nazmul_bd08


Probable reading your question wrong but if you want column B to display the contents of column A then just =A1 in column B and drag down, again I am certain that I am reading your question wrong so my apologize in advance. Not sure how you get 2 from 3/4/5/6 what formatting or formula/functions do you have in Column B?
 
actually my problem

row 1 in input 2/3/6/5 i want

row 2 display show all time 2 but if row 1 in input 1 then row 2 display 1

pls solve this problem
 
2nd problem

when column A(row 1) in input 5 then column B(row 1) show 1-5 but

when column A(row 2) in input 10 then column B(row 2) show 6-15
 
Not very sure but are you trying to construct something like this:


=IF(A1=5,"1-5","something else")

=IF(A2=10,"6-15","something else")


If your requirement is something different then plz upload sample workbook and provide some manual input and output data layout of your requirement.


Kaushik
 
example

column A (input) column B (output)

first 10(any element) ..................... 1-10

20(any element)...................... 11-30

15(any element)...................... 31-45

5(any element)....................... 46-50

12(any element)...................... 51-62

i input any element but out put show this rules


pls solve
 
2nd problem

example


row 1.......row 2.......row 3.......row 4........output row 5........ row 6


5...........3.........1..........6......................7..............15

actually i want row =2/5/6/4/8 out put count altime 2 but when if row input 1 then out put count 1
 
Try this at B1 (considering A1 is your input cell):

=IF(A1=10,"1-10",IF(A1=20,"11-30",IF(A1=15,"31-45",IF(A1=5,"46-50","51-62"))))


Kaushik
 
@nazmul_bd08


If i am right your data looks like this in some sheet:

[pre]
Code: 
ColA   ColB
10     1-10
20     11-30
15     31-45
5      46-50
12     51-62
[/pre]
Since you are looking for a Exact match you can safely use:


'=VLOOKUP(A1,A1:B5,2,FALSE)'


Your data is in Cell A1:B5


Regards,
 
row 1.......row 2.......row 3.......row 4........output(main) row 5........ row 6


input..5............3.............1..............6..........................= 7............=15


actually i want row =2/5/6/4/8 out put count all time 2 but when if row input 1 then out put count 1

pls solve the problem
 
thanks faseeh,

actually i want as like list here input however but out put show (column a=7,column b= show 1-7,&again column a=15,column b=show 8-22)this type

pls again sent me easy
 
Hi nazmul_bd08,


Can you upload a sample file for me??? Upload it to some file hosing site and drop a link here in your post.


Secondly you can use back tics (`) and enclose your codes in them to show the layout of the sheet here if you are copy pasting data like this:

[pre]
Code: 
Row   row 1   row 2   row 3   row 4  row 5   row 6
Input 5       3       1       6      7       15
[/pre]

Now please explain with an "Example" what do you want??


Regards,
 
hi,faseeh

i want row 5= 7(row1+row2+row3+row4)every row count 1 or 2

row6=15(row1+row2+row3+row4)every row count actually
 
You must log in or register to reply here.
Back
Top