excel problem « Chandoo.org - Learn Excel & Charting Online

Chandoo.org - Learn Excel & Charting Online - Forums » Ask an Excel Question

excel problem

(15 posts) (5 voices)

Started 4 months ago by nazmul_bd08
Latest reply from nazmul_bd08

Tags:

No tags yet.

nazmul_bd08

Member
Joined: Dec '12
Posts: 15

column A =3/4/5/6 but column B show always 2, here if column A=1 then column B show 1
pls solve

Posted 4 months ago #
bobhc

Excel Ninja
Joined: Jan '12
Posts: 1,433

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?

Posted 4 months ago #
nazmul_bd08

Member
Joined: Dec '12
Posts: 15

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

Posted 4 months ago #
nazmul_bd08

Member
Joined: Dec '12
Posts: 15

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

Posted 4 months ago #
kaushik03

Member
Joined: Sep '11
Posts: 776

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

Posted 4 months ago #
nazmul_bd08

Member
Joined: Dec '12
Posts: 15

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

Posted 4 months ago #
nazmul_bd08

Member
Joined: Dec '12
Posts: 15

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

Posted 4 months ago #
kaushik03

Member
Joined: Sep '11
Posts: 776

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

Posted 4 months ago #
Faseeh

Excel Ninja
Joined: Jan '12
Posts: 1,591
@nazmul_bd08

If i am right your data looks like this in some sheet:
```
ColA   ColB
10     1-10
20     11-30
15     31-45
5      46-50
12     51-62
```
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,
Posted 4 months ago #
nazmul_bd08

Member
Joined: Dec '12
Posts: 15

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

Posted 4 months ago #
nazmul_bd08

Member
Joined: Dec '12
Posts: 15

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

Posted 4 months ago #
amrit1186

Member
Joined: Dec '12
Posts: 50

Hi Nazmul

Try this by seting A1 as 0.

=A1+1&"-"&A2

Amritansh

Posted 4 months ago #
nazmul_bd08

Member
Joined: Dec '12
Posts: 15

HI,
ALL FRIEND
PLS SEE MY PROBLEM & SOLVE MY PROBLEM
PLS 1ST & 2ND PROBLEM

Posted 4 months ago #
Faseeh

Excel Ninja
Joined: Jan '12
Posts: 1,591
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:
```
Row   row 1   row 2   row 3   row 4  row 5   row 6
Input 5       3       1       6      7       15
```
Now please explain with an "Example" what do you want??

Regards,
Posted 4 months ago #
nazmul_bd08

Member
Joined: Dec '12
Posts: 15

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

Posted 4 months ago #