Im working on a sheet that has numbers for a sports club. At the moment we use two columns and at the end of the columns of data, we calculate values in one column leaving another empty.
What I would like to do is move to a single column design. A3:A15= Date B,D,F,H,J,K,etc,1=team name B3:B14 = Point values C3:C14 = Goal values B17:B22 = calculated values for B1 team. Example data: B3=3 B4=0 B5=1 B6=3 B7=0 C3=7 C4=10 C5=2 C6=1 C7=4 What I would like to do is: B3=3,7 B4=0,10 B5=1,2 How would I access the first or second value a pair value? -- Registered Linux User: #480675 Registered Linux Machine: #408606 Linux since June 2005 -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
