Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
my listbox contains 3 values:
value1,value2,value3
in want 3 textboxes:
texbox1: first value of listbox (value1)
...
textbox3: third value of listbox(value3)
looking for something like:
=rank(listbox,3)
hi
if column name is value in listbox which contain 3 values i.e value1,value2,value3
then
in 3 text boxes try folling formulas
=only(if(value='value1',value)
=only(if(value='value2',value)
=only(if(value='value3',value)
value1 is the first position value .. this is not a fixed text.
i really need something like rank(value,3)
u can use something like
=fieldvalue('fieldname used for listbox',1) as a text in textbox1
=fieldvalue('fieldname used for listbox',2) as a text in textbox2
and so on
thanks
tauqueer