choose function

I'm doing a leaderboard and there are over 29 entrants. I am trying to show what place each person is in and there is also ties. I was using the Choose function when the entrants were smaller, I didn't know about the 29 limit. There are 35 entries. This is the formula I'm using (in this...

Hello My first post here, and I am hoping someone can help me! I am using the following CHOOSE Function: =CHOOSE(($D$2<=2)+($D$2=3)+($D$2=4)+($D$2=5)+($D$2>5),5,4,3,1,0) If cell D2 has a 1 or a 2, I need the CHOOSE function to return 5. If cell D2 has a 3, I need the CHOOSE function to...

Hi! So I want to make a Dynamic array with Choose, where one column will be the unique clients and in the second column I want the SUMPRODUCT of Quantity and Price for each product. As you can see the result is 0 for each row. This is just an example of my real problem with a report of 200K...

I want to choose a figure from a table which has two levels of points (row-level and column-level). Now I want to a choose a figure (Here it is 60300) like row level 2 and column level 3. How can I choose it using choose function? The table is as follows: Level Level Level 1 2 3...

I found the right formula I need on a site (that didn't explain it :crash:). Between this and other examples, I can't piece enough together to wrap my head around it. Two hours of googling and I'm done! This gives me the first Monday (obviously you probably already know that) and I'm wanting...

with the data below <colgroup><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody> A B C D E F G H I J Reported Amt Balance Reported Amt On Acct Cust Balance (calculated col D - Col E ) Invoice Amt Due from transactions Fwd Aged Curr 31-60 61-90 91-120 121+ $...

Hello guys, I have a difficulty finding the right formula for my problem. I started my vlookup with many if's but didn't work. Choose function didn't work eather. I have to search for the correct owner based on multiple conditions: 1. If the ProductBrandCode is AB_N00, AB1_N00 or AB2_N00 (or...

Hi, my first time posting. Would really appreciate any help :). I have a file showing products in one column and the volume of each product in another. I am trying to create a list of products groupings (CONCATENATE) based on the cumulative volume of the products. Within my source data each...

Hi, I am working on a dashboard where I am creating drop down dependent charts. For this I have used camera tool to display the picture of graphs (created in separate sheets) selected in the drop down and I am using CHOOSE function to decide the order. The problem is all my graphs are not...

The current formula: B2 is a given number. I enter C2 and the below formula calculates D2 based on the following: For every 2 units higher that C2 is than B2, D2 will go up 1. For every 3 units below that C2 is than B2, D2 will go down 1. Below is that formula that is entered into cell D2...

<TBODY> 10.2013</SPAN> 1</SPAN> 01.10.2013 </SPAN> 201310</SPAN> 001</SPAN> Oct 13</SPAN> 11.2013</SPAN> 2</SPAN> 01.11.2013</SPAN> 201311</SPAN> 002</SPAN> Nov 13</SPAN> 12.2013</SPAN> 3</SPAN> 01.12.2013</SPAN> 201312</SPAN> 003</SPAN> Dez 13</SPAN> 01.2014</SPAN>...

I know it's possible to do a left lookup, I am currently using this formula on the worksheet: =VLOOKUP($B4,CHOOSE({1,2},Sheet1!$C$2:$C$65536,Sheet1!$B$2:$B$65536),2,FALSE) Unfortunately, I cannot use this. This spreadsheet has several userforms to populate my spreadsheet with data. When using...

Dear Members, I want to use choose or any other excel function in the following table to distribute 10 K among four members whose priority may change: <tbody> Priority 1 2 3 4 Ram Shyam Mohan...

I used the formula below to get the last monthly price of an item ={LOOKUP(9.9999999E+307,CHOOSE({1,2},0,LOOKUP(2,1/((Market!$I$2:$I$9998<>"")*(TEXT(Market!$A$2:$A$9998,"mmm-yyyy")=B11&"-"&A11)),Market!$I$2:$I$9998)))} In fact, I have 2 separate columns for year and month (referenced by B11 and...