Arrays

%3CLINGO-SUB%20id%3D%22lingo-sub-1801940%22%20slang%3D%22en-US%22%3EArrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1801940%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20OLD%3B%20my%20experience%20is%20OLD%20but%20Microsoft%20has%20been%20classic%20in%20respecting%20the%20OLD%20philosophies%3B%20the%20forever%20working%20solutions%20EXCEPT%20arrays.%20I%20really%20feel%20like%20I%20am%20missing%20something%20because%20of%20that%20maintenance%20of%20old%20time%3B%20forever%20time%20philosophy.%20The%20perfect%20example%20of%20array%20usage%20should%20be%20calculating%20skins%20for%20a%20golf%20game.%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3ERows%20%3D%20players%20and%20scores%3C%2FLI%3E%3CLI%3EColumns%20%3D%20hole%20%23's%3C%2FLI%3E%3CLI%3ESkin%20%3D%20Unique%20score%20by%20Hole%20intersection%3C%2FLI%3E%3CLI%3EPlayer%20%3D%20Index%20of%20the%20intersection%3C%2FLI%3E%3C%2FUL%3E%3CP%3EWithout%20question%2C%20the%20answer%20will%20be%20using%20%22offset%2Fmatch%22%2C%20%22offset%2Fxmatch%22%2C%20%22index%2Fmatch%22%2C%20etc.%2C%20etc.%2C%20etc.%20But%20the%20solution%20should%20be%20simple.%20I%20know%20the%20row%23%2C%20column%20%23%20but%20a%20formula%20that%20returns%20that%20answer%20takes%20how%20many%20steps%3F%20I%20do%20not%20want%20to%20use%20VBA%3B%20am%20I%20missing%20something%3F%20I%20should%20be%20able%20to%20do%20a%20%22Lookup%22%20type%20that%20uses%20an%20array%20of%20true%20values%20back%20to%20an%20array%20of%20who%20had%20the%20winning%20scores.%20In%20other%20words%3B%20the%20whole%20array%20would%20be%20Players%3AScores.%20Winning%20Scores%20would%20index%20ONLY%20the%20Player%20%2F%20Hole%20%23%20index.%20Once%20upon%20a%20time%2C%20this%20function%20existed%3B%20maybe%20not%20in%20excel%2C%20access%2C%20etc.%2C%20but%20quick%20%2F%20easy%20array%20functions%20made%20coding%20much%20easier%20and%20straight%20forward.%20I%20really%2C%20really%20hope%20I%20am%20simply%20missing%20a%20function%20that%20will%20accomplish%20the%20end%20result.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20reading%20and%20pointing%20me%20in%20the%20right%20direction.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1801940%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1802208%22%20slang%3D%22en-US%22%3ERe%3A%20Arrays%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1802208%22%20slang%3D%22en-US%22%3ECould%20you%20please%20share%20some%20sample%20data%20along%20with%20expected%20output%20or%20better%20share%20the%20workbook%2C%2C%20help%20us%20to%20fix%20the%20issue%20!!%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I am OLD; my experience is OLD but Microsoft has been classic in respecting the OLD philosophies; the forever working solutions EXCEPT arrays. I really feel like I am missing something because of that maintenance of old time; forever time philosophy. The perfect example of array usage should be calculating skins for a golf game. 

  • Rows = players and scores
  • Columns = hole #'s
  • Skin = Unique score by Hole intersection
  • Player = Index of the intersection

Without question, the answer will be using "offset/match", "offset/xmatch", "index/match", etc., etc., etc. But the solution should be simple. I know the row#, column # but a formula that returns that answer takes how many steps? I do not want to use VBA; am I missing something? I should be able to do a "Lookup" type that uses an array of true values back to an array of who had the winning scores. In other words; the whole array would be Players:Scores. Winning Scores would index ONLY the Player / Hole # index. Once upon a time, this function existed; maybe not in excel, access, etc., but quick / easy array functions made coding much easier and straight forward. I really, really hope I am simply missing a function that will accomplish the end result. 

 

Thanks for reading and pointing me in the right direction. 

1 Reply
Highlighted
Could you please share some sample data along with expected output or better share the workbook,, help us to fix the issue !!