+ Reply to Thread
Results 1 to 2 of 2

Comparison Formula Help

  1. 07-09-2019, 05:02 PM #1
    MoodoHarajli
    MoodoHarajli is offline
    Registered User
    Join Date
    02-02-2018
    Location
    Nowhere
    MS-Off Ver
    Microsoft 2016
    Posts
    21

    Question Comparison Formula Help

    Hey everyone,

    I have a test profile with some baseball players that I need help with. As it is now, I have a separate worksheet that I can go to to find the top 5 comparisons. However, I would like to figure out a way so that the comparisons are on the main worksheet so that I don't have to go to the second worksheet. Specifically, how do I put a formula into the column AL (Comparison #1) in which it accomplishes the same goal as D2 in the second worksheet (Player Comparison) without the actual use of a list.

    Thank you to anyone in advance who can help me out with this situation!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 07-10-2019, 12:44 AM #2
    scottiex
    scottiex is offline
    Forum Expert
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 365
    Posts
    1,343

    Re: Comparison Formula Help

    In column AL just put the sheet name in front of each of the ranges like this

    Please Login or Register  to view this content.
    That isn't eliminating the usage of sheet 2 but i don't think you need to do that.

    However if you really want to eliminate the use of the list in sheet 2 you'd have to explain exactly what it does.
    Last edited by scottiex; 07-10-2019 at 12:46 AM.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I'm looking for a formula for a comparison
    By Benjic in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-26-2018, 08:19 AM
  2. Comparison Formula
    By MoodoHarajli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2018, 02:45 AM
  3. Comparison Formula
    By MoodoHarajli in forum Excel General
    Replies: 2
    Last Post: 02-03-2018, 01:52 AM
  4. Tables comparison along with rows comparison and mismatch rectified with color notificatio
    By harman83 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-14-2015, 11:58 AM
  5. [SOLVED] Comparison formula using OR instead of AND
    By SMITH.CRYSTAL in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-05-2015, 10:30 AM
  6. [SOLVED] Comparison formula
    By cwallace70 in forum Excel General
    Replies: 2
    Last Post: 10-04-2012, 09:19 AM
  7. formula for comparison
    By sweetsue516 in forum Excel General
    Replies: 2
    Last Post: 08-31-2005, 01:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1