small

BF1OfferLow21.3031.7041.6052.4060.9070.3080.8090.20Low100.20Low111.80121.40133.00141.00Low151.30161.10Low171.90181.70Low192.00202.10212.30221.70Low231.80Low241.90Low252.50F2:F24F2=IF(B2<=MIN(B3:B$25),"Low","") When there are no value lower than a cell value, assign ("Low"), else (""). The...

Any ideas on how to get spilled results across and down for the following? I'm using SMALL function to find the 3 smallest values for each person. I can only get it to spill across or down - is there a way to get it to spill across and down?

Hello experts, I am looking for assistance with my formula. I am using an index/small formula in the following scenario: I am pasting raw data into Tab A, which includes status (example: Active, Inactive), and additional rows of data. In Tab B, is a summary table, that pulls rows of data from...

Hi All I'm running into a bit of an issue I can't work out, granted I have a horrible cold right now... I have this formula to find content in a sheet called "Test", it works perfectly until later (G94)...

Hello everyone. I'm new here and excited to share and answer. I've ran into several situations were I need to compare a list of values/text to see if they consecutively match up in a separate table/range. I thing I have finally found a solution which can be universally applied in similar...

Hi there, I have found some old posts on this topic but nothing that seems to solve my issue. I am using the below formula in order to pull a list of individuals names that have correspondence through the same email address. For example if Mr John Smith, Mrs Jane Smith and Miss Janet Smith are...

I have a table. Column A is Activity, Column B is a list of values that run from BA9 to B108 which are EXPENDITURES, and from B111 to B160 which are INCOMES I want to take the 5 largest and the 5 smallest numbers from the entire list of Expenditures and Incomes and put them in a separate table...

Hi, I have a list of numbers and want to sort it while checking for criteria. My thought was to use =SMALL(IF($A$2:$A$11>$C$1,$A$2:$A$11,99),COUNTA($B$1:B1)+1) in cell B2 and extend it down. Without the IF function it works fine, but with it it acts real strange. It show a list that is in...

Hi, I am looking to fill in the matrix on Table 1, referencing criteria in Table 2. I have only included a sample of total data. I want to INDEX column 4 in Table 2 so that the matrix in Table 1 specifies which stage (1, 2, or 3) is happening and when it is scheduled. To do this, I want to...

I need a formula to get the result I manually typed in the last row. Smallest with no ties. Not the 2nd or more smallest.

Quick back story: I need to report shipping dates to customers. I gather this information by doing a two way index match on the customers PO number and the customers PO line number against our line number. When entering items into our system the Import Team is supposed create an order number...

Hi all, I would like to use functions like LARGE, SMALL, MAX, MIN and SUM in spilled arrays and get the values PER row instead of the total. For Example: x y =MAX(A2:B2) dragged down =MAX(A2:B5) 1 2 2 8 3 4 4 5 6 6 7 8 8 The only solution I...

Hi I have been battling this one for hours! I have two formulae one that looks down Column E for specific text that is held in cell G2, the second looks down the same ColumnE for specific text held in G3. Both work well and return the value of the specific cell to cell E1. I have been trying to...

I am struggling to find any way to insert a column into the MAIN tab pulling from the INV tab. The MAIN tab is one sales order for 1 customer with 29 rows, intentionally order qty of 1 in each. The INV Tab is the list of invoices for the same sales order. Some of the invoices were for...

Having watched a MrExcel YouTube video about pulling records based on a condition, I attempted to reorganise a large question bank we have for learners. Unfortunately, the formula doesn't seem to work as it's getting caught pulling correct row numbers and always returns 0...

Hello, I'm trying to get 2 multiple results from 2 different columns under 1 column and in order. Column E = Matching Apple in column A -> returning C value {=INDEX($C$1:$C$6,SMALL(IF(ISNUMBER(MATCH($A$1:$A$6,$E$1,0)),MATCH(ROW($A$1:$A$6),ROW($A$1:$A$6)),""),ROWS($A$1:A1)))} Column F =...

Similar to this link(reference the bottom)- I am trying to return multiple corresponding values with two look up conditions, horizontally, in one row. Then I can apply it down other rows. Not sure how to go about this- I have been stuck for days. I provided a sample below: ID Name Qty A...

Hi.. I need help to develop an excel formula in referring values from different tables and ranges and add the value to basic size and place the results in respective cells. the demo file is at below link, and also one small explanation of my requirement. Kindly help... Thank you in advance...

I have a page break that is making the first page very small, I have tried everything to delete it and nothing works. Heeeellllpppp!!!

Hello,</SPAN></SPAN> I need to extract the numbers of column E:N and need to arrange them in order small to larger values in the columns P:Y</SPAN></SPAN> Example...