Excel Formula Issue - Aussie Stock Forums

Results 1 to 3 of 3
  1. #1

    Default Excel Formula Issue

    I'm having an issue with one of my Excel formula. I have a column that is filled with text based on an If Function.

    The Column looks like this:


    Column Title (Direction)



    I want a Formula that will spit out the most common Text field, which would be Sideways in this instance.
    I'm using this formula:
    It works for a normal text column that I tested but I think the If function may be stuffing it up because I only receive a #N/A (so no values input). The Cells are set to text BTW.

    Please help and any suggestions to get around this would be great!


  2. #2

    Default Re: Excel Formula Issue

    One suggestion is:

    Add this formula to a cell: =COUNTIF(B5:B10,"=sideways")

    It will count the cells which match the criteria in this case "sideways"
    You can then add this formula to 2 other cells that count the "Up" and "Down" values instead.

    This will give you totals for each category

    Note: You will need to be aware of case sensitivity for the text you are searching.

    Good luck

  3. #3

    Default Re: Excel Formula Issue

    Thanks mate! Done.

    I used that formula to spit out the three totals for each criteria (up, down & sideways) which I put in cells S4, S5 & S6.

    Then I used the below formula to find out the one with the highest mode and put it in a cell.

    =IF(AND(S4>S5, S4>S6), "Sideways",IF(AND(S5>S4, S5>S6), "up",IF(AND(S6>S4, S6>S5), "Down","")))

    Feels good to have a win

Similar Threads

  1. Formula 1
    By Kryzz in forum General Chat
    Replies: 87
    Last Post: 12th-April-2013, 11:37 PM
  2. Can someone please help with Metastock formula?
    By Rob_ee in forum Software and Data
    Replies: 73
    Last Post: 17th-December-2012, 08:34 PM
  3. Issue with UserCP
    By Joe Blow in forum Announcements and Site News
    Replies: 4
    Last Post: 11th-September-2006, 10:29 AM
  4. Another warrant MM issue
    By GreatPig in forum Derivatives
    Replies: 6
    Last Post: 22nd-July-2006, 07:04 PM
  5. Dividend Issue
    By dshe in forum ASX Stock Chat
    Replies: 3
    Last Post: 29th-September-2004, 09:58 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
Aussie Stock Forums