column A =3/4/5/6 but column B show always 2, here if column A=1 then column B show 1
pls solve
excel problem
(15 posts) (5 voices)-
Posted 4 months ago #
-
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 # -
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 problemPosted 4 months ago # -
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-15Posted 4 months ago # -
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 # -
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 rulespls solve
Posted 4 months ago # -
2nd problem
examplerow 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 1Posted 4 months ago # -
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 # -
@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-62Since 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 # -
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 problemPosted 4 months ago # -
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 easyPosted 4 months ago # -
Hi Nazmul
Try this by seting A1 as 0.
=A1+1&"-"&A2
Amritansh
Posted 4 months ago # -
HI,
ALL FRIEND
PLS SEE MY PROBLEM & SOLVE MY PROBLEM
PLS 1ST & 2ND PROBLEMPosted 4 months ago # -
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 15Now please explain with an "Example" what do you want??
Regards,
Posted 4 months ago # -
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 actuallyPosted 4 months ago #
Reply
You must log in to post.

