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

i need to budget my income and don't know exactly how. My income is small and I have a lot of bills!? help please

Need help using array formula such as index, match or small to fill in cells that match certain criterias on rows and columns.

Please i am having an excel sheet which is linked together. Am having the Headings as follows 'Stack, Version, Category, Crop Season etc.' but i do the entry on another sheets (let say sheet 1) and it appears on the other sheet automatically( sheet2 ). I want, when i update my version number the Category and Crop season should update automatically (and the Category we have light crop, small beans and Type 4 with a crop season as 2017/18,2015/16,2014/15 respectively). i want if i manually enter the stack ,version , category, crop season on one sheet (sheet1) it should automatically update in sheet 2 , relating to the version number and stack

Hi before I reset my computer I used to be able to enter =NPV( and then a small box would appear below and would say the components of the formula that need to be entered, such as rate and value. Now when I enter =NPV( no box is included. How do I get this box back. Im using a Mac and it should be the newest version of excel

DESCRIPTION: =IF(ROWS(A$7:A7)<=$E$3,INDEX('ENTER DATA - PRODUCTION'!A$2:A$16732,SMALL(IF('ENTER DATA - PRODUCTION'!$B$2:$B$16732='DO NOT TOUCH - ARRAY FUNCTION'!$B$1,IF('ENTER DATA - PRODUCTION'!$J$2:$J$16732="B2",ROW('ENTER DATA - PRODUCTION'!$J$2:$J$16732)-ROW('ENTER DATA - PRODUCTION'!$J$1)+1)),ROWS(A$7:A7))),"") What is wrong with this formula. I'm using this for duplicate Vlookup function. I get #NUM! error.

I'm trying to add a ActiveX check box that will allow me to make small check box in excell file but not able to find ActiveX controls in developer ribon. What do you recommend? MOTE: I have check boxes on the form and they are too big.

I have created a form but everything is so small that it won't give enough writing room and keep format. Is there a way to fix this?

Hello, I have the following issue I want to be able to get an automatic description in B if i have a special code in C i have a small table with the description in G and H, G containing the code to be compared while H containing the description i need copyed

Looking to calculate data in a excel spreadsheet such as averages and a small chart

Trying to make a small adjustment to an existing Vlookup formula