Results 1 to 3 of 3

Thread: OpenOffice Calc / Gnumeric help?

  1. #1
    Join Date
    Apr 2007
    Location
    Bay Area
    Beans
    30
    Distro
    Ubuntu 11.10 Oneiric Ocelot

    OpenOffice Calc / Gnumeric help?

    I have a column of alphanumeric data and I want to organize it by what values occur most frequently... how do I go about doing this?

  2. #2
    Join Date
    May 2008
    Location
    The Netherlands
    Beans
    2,151
    Distro
    Kubuntu 12.10 Quantal Quetzal

    Re: OpenOffice Calc / Gnumeric help?

    Quote Originally Posted by rapper97 View Post
    I have a column of alphanumeric data and I want to organize it by what values occur most frequently... how do I go about doing this?
    One way is to use subtotals:

    Code:
    Select the column
    Goto menu Data > Subtotal
    In the right field select count
    DeMus

  3. #3
    Join Date
    Apr 2007
    Location
    Bay Area
    Beans
    30
    Distro
    Ubuntu 11.10 Oneiric Ocelot

    Re: OpenOffice Calc / Gnumeric help?

    In OpenOffice? I keep getting the error "Unable to Insert Rows."

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •