is this possible???

[appu_gusai]

hello everyone

i want to this one
in A1 cell =SUM(123,456,789)

in B1 cell = A,B,C

i want if B1 1st value is A, C1 = 123, if B1 2nd value is B, D1 = 456 & if B1 3rd value is C, E1 = 789

thank's in advance

 

[SirJB7]

Hi, appu_gusai!

Could you elaborate a bit more and upload a sample file with a few examples? Either I'm unable to understand the logic (not the usefulness) or you're missing something.

Regards!

 

[Faseeh]

Hi appu,

Call you list all the combination of A, B , C under consideration?

 

[appu_gusai]

suppose if A1 column shows =sum(123,456,789) and the total of that shows in screen is 1368
and assume a=123, b=456 and c=789

now my question is

if i want to plot the value of a (i.e. 123) in another column (say in A5) then what is the procedure
and if i want to display the a, b, and c individually in individual column then what should i do.????

 

[Debraj]

Hi Opu,

Yes.. its possible.. but why you are making it complicated.!!!
when you can make manual input in parameter, then you can also make manual input in required cell..

still try this.. UDF.

Function getParameters(RAJ As Range) As Variant
  DEB = Join(Split(Split(RAJ(1).Formula, "(")(1), ","), "|")
  getParameters = Split(Left(DEB, Len(DEB) - 1), "|")
End Function

 

[appu_gusai]

thank's a lot

 

[appu_gusai]

hello DEBRAJ

one more question is, this function is working with if function?