Results 1 to 5 of 5

Thread: Quick question about Calc/Excel (Spreadsheets)

  1. #1
    Senior Member Workaholic's Avatar
    Join Date
    Oct 2004
    Location
    Manchester
    Posts
    1,500
    Thanks
    187
    Thanked
    14 times in 12 posts

    Question Quick question about Calc/Excel (Spreadsheets)

    Basically I have a spreadsheet that I use to manually gather information and names etc,. What I want to do is have a cell showing me patterns such as what names keep popping up the most (i.e. most common, frequent entry!)

    Is there any formulaes for this or do I have to write a VERY long IF this then that...............

    Thanks in advance.

    P.S. its mainly gonna be used for OpenOffice 1.1.2 Calc, but can be used in 2.0 or excel elsewhere..
    Woohoo now Assistant Manager!


  2. #2
    Flower Child stytagm's Avatar
    Join Date
    Aug 2004
    Location
    London
    Posts
    754
    Thanks
    47
    Thanked
    23 times in 18 posts
    MODE would seem to do the trick for numerical data, but I'm not sure for things like text.

    http://malektips.com/microsoft_excel...tion_0005.html
    They told me I was gullible ... and I believed them.

  3. #3
    Senior Member Workaholic's Avatar
    Join Date
    Oct 2004
    Location
    Manchester
    Posts
    1,500
    Thanks
    187
    Thanked
    14 times in 12 posts
    I need it for text unfortunately.....

    Also another thing I need to do is compare a couple of numbers (each one taking a cell vertically) then finding the one with the highest value then showing as a result the name stored in the far left of THAT COLUMN.
    Woohoo now Assistant Manager!


  4. #4
    listen to escape fails :) luap.h's Avatar
    Join Date
    Jan 2004
    Posts
    569
    Thanks
    4
    Thanked
    2 times in 2 posts
    Pivot tables are usually pretty useful for collating that type of data

  5. #5
    Senior Member Workaholic's Avatar
    Join Date
    Oct 2004
    Location
    Manchester
    Posts
    1,500
    Thanks
    187
    Thanked
    14 times in 12 posts
    ^^ Didn't want to use tables /graphs as such..

    In the end used a VLOOKUP formula, faily compicated and meant I had to to rearrange everything but it works!
    Woohoo now Assistant Manager!


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Quick Question: PSU's with 1x120mm fan question
    By philyau in forum PC Hardware and Components
    Replies: 10
    Last Post: 05-09-2005, 02:30 PM
  2. Quick Linux question from a newbie...
    By madmonkey in forum Software
    Replies: 19
    Last Post: 26-08-2005, 09:07 PM
  3. Quick and easy question!
    By planetgong in forum Help! Quick Relief From Tech Headaches
    Replies: 4
    Last Post: 01-03-2005, 06:25 PM
  4. Quick Question About Flashing Bios
    By Fresco in forum PC Hardware and Components
    Replies: 1
    Last Post: 25-02-2005, 12:16 AM
  5. Quick bios question
    By SansSouci in forum Help! Quick Relief From Tech Headaches
    Replies: 3
    Last Post: 08-02-2005, 01:55 PM

Posting Permissions

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