Get instant live Excel expert help to learn how to use Small function in Excel

working on an income sheet for a small care home. so i need to calculate monthly income. i have start date, then a column for next payment date (28 days) but i also have an end date (if resident moves out) so if the end date falls before the due date, then i need the due date to be accurate and calculate the correct number of days

I have an inventory items page, receiving page, sales page, and stock page for my small manufacturing business. I got everything set up except my sales page. I have items that go into receiving page and then they are assembled into an audio electronic device. I am looking for a formula that will subtract all the items used for making the device and update the stock page automatically.

I have a value in B2. I want it to find the value in the first column of a named range and return all the data from the same row of columns 2,3,4,5 and 6 of the same named range for as many rows the match value is found. I am currently using:- =IF(ISERROR(INDEX(WeekProtests,SMALL(IF(WeekProtests=$B$2,ROW(WeekProtests)),ROW(1:1)),2)),"",INDEX(WeekProtests,SMALL(IF(WeekProtests=$B$2,ROW(WeekProtests)),ROW(1:1)),2)) But I am returning duplicate records for some reason

Using appropriate Lookup, match and/or Index functions in Excel (without using VBA) create a worksheet that identifies: a) Which students in the English class are NOT studying science b) Which students in the science class are NOT studying English the formula i used was: =IF(ROWS(D$8:D19)<=SUMPRODUCT((--ISNA(MATCH($A$8:$A$307&$B$8:$B$307,$H$8:$H$307&$I$8:$I$307,0)))),INDEX($A$8:$A$307&" "&$B$8:$B$307,SMALL(IF(ISNA(MATCH($A$8:$A$307&$B$8:$B$307,$H$8:$H$307&$I$8:$I$307,0)),ROW($B$8:$B$307)-ROW($B$8)+1),ROWS($D$8:D19))),"")

multiple Vlookups to display baseball stats from a small dataset. Set up the workbook so that you can type in a batter’s name in the cell next to “Player:” and his seasonal stat line will show up underneath for the stats listed. Please display each stat as it would normally be presented – Games/PA as whole numbers, K/BB Rate as percentages, etc.

In Excel, what formula can I use to assign and calculate total numerical values for three columns of words? For example, Column A is "yes" or "no". Column B is "small", "medium", or "large". Column C is "yes" or "no". For Column A, yes contains a value of 5 while "no" contains no value. For Column B, small contains a value of 20, medium is 40, and large is 50. For Column C, "yes" is 10 and no is 0. See attached picture for an example. Column D is where the result should calculate, combining the three columns numerical values. Thank you for your help!

Hello, I am tasked with creating a small chart containing 2 vertical axes as follows: 1) X-Axis: Months from January to May 2) Y-Axis left: Total cost of a project 3) Y-axis right: For labeling. Each month we will perform one task of the project which will add to the total cost. I want to show that each data point (month, total cost) corresponds to specific task in the project.

My Small brother jokingly Locked my Excel Sheet (protected workbook < encrypt with a password) & Has no idea of what the Password was. The Excel was my 3 Years of Work & i am trying every possible thing to open it but it inst opening. Is there anyway i can Open it or disable the password?

If column F = Small column J will be date from column H minus 60 days If Column F = Medium Column J will be date from column H minus 120 days If Column F = Large column J will be date from Column H minus 180 days

My page keeps printing with a second page with a small bar on the left hadn side. I've deleted all cells, clear contents, made them "normal" nothing I've tried has worked. Please help anyone?!