Dear Vijay, Where is attached excel file.
On Fri, Jul 19, 2013 at 11:00 AM, vijay yadav <vijay.ganesh.ya...@gmail.com>wrote: > Hi Excel experts, > > Please help in above case. > > In simple words I need a formula to calculate output considering > corresponding cell of B column in same row and a cell in A row. > > All details are given in excel attached. > > Kindly help > > Regards > Vijay Yadav > > On Tuesday, 16 July 2013 14:54:41 UTC+5:30, vijay yadav wrote: >> >> Dear All, >> >> I have some data which is in 2 columns A & B. >> A column contains actual number of different type of bottles >> B contains maximum number of bottles that can be placed in the row. >> I want the output in C column which gives the number of bottles that can >> be placed with help of formulae such that for any values in column A and B >> the output of column C will be always available. >> Can someone help. >> >> The sheet is attached along with this post.Please have a look at it. >> >> >> I will explain my problem here with a small example.Kindly note the >> actual ranges of A is max 24 nos,B is fixed 16 nos and output is fixed 16 >> nos. >> >> A B C 54 53 53 48 53 1 49 48 >> Column -A= I have 54 plastic bottles and 48 red glass bottle >> Column B =gives maximum number of same type of bottle which can be >> placed I.e I can place 53 in first row but in second row i can place only 1 >> as 48 bottles are of different type. >> Column C = the actual bottle placed i.e output with help of formula >> >> Kindly note the actual ranges of A is max 24 nos,B is fixed 16 nos and >> output is fixed 16 nos. >> >> A B >> Regards >> Vijay Yadav >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > 2) Don't post a question in the thread of another member. > 3) Don't post questions regarding breaking or bypassing any security > measure. > 4) Acknowledge the responses you receive, good or bad. > 5) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don't ever post confidential data in a workbook. Forum owners and > members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
