Results 1 to 3 of 3

Thread: rank.eq with multiple if conditions
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2016
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default rank.eq with multiple if conditions

    Hi, can anyone provide guidance/examples on rank.eq formula with multiple conditions?

    I am generating pivot table for Company A filtered by year, and I want to set up a linked table - table 2 (so row values change when my pivot filters change) to display rank.eq for each row value generated in the pivot, relative to the cohort (e.g. all companies in 'Year', 'Region'), from which my filtered company is taken.

    I am guessing this would be formula in table 2 comprising a combination countifs/rank.eq formula looking up 'Year', 'Region', 'All', 'F', 'M' and returning in each case the rank.eq of company A?

    table 1. Pivot table
    Year = 2019

    Company A (England)
    All % F % M %
    Red
    Blue
    Green
    Orange

    table 2. Linked table showing rank.eq for Company A row values relative to all companies in a region

    Region "England", Year "2019"
    All % F % M %
    Red
    Blue
    Green
    Orange

    Hope this make sense and any help on how to write this would be appreciated, many thanks!

    A

  2. #2
    Board Regular James006's Avatar
    Join Date
    Apr 2009
    Posts
    3,587
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    1 Thread(s)

    Default Re: rank.eq with multiple if conditions

    Hello,

    Have you tried an array formula with all your conditions ... ?

  3. #3
    New Member
    Join Date
    Jul 2016
    Posts
    17
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: rank.eq with multiple if conditions

    Hi, no, but I will do - I'm struggling at the moment with the formula to combine the rank.eq with the conditions.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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