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

I need a formula that looks for a specific name in three columns, takes all of the rows that match to get dates from another column. Then from the dates that match the rows with the names, take the second earliest date and generate it. The below formula is giving me the second date listed for the specific person instead of giving me the second earliest date. =IFERROR(INDEX('Input Data'!$E$5:$E$150,SMALL(IF(Tracker!$B6='Input Data'!$G$5:$I$150,ROW('Input Data'!$G$5:$I$150)-ROW('Input Data'!$G$5)+1),2)), "N/A")

Hello - I have a giant spreadsheet that I regularly need to go into to find just one row, copy that data, and paste it into another small spreadsheet which I use to do the work I need to do with the data. Is there a way I could do so without having to open the giant spreadsheet and find the right row every time? I can show you the spreadsheets and the process if that helps.

I Need to turn Sheet1 of my file into Sheet2 of my file. It should be pretty self-explanatory. (this is a small example of a much larger file that I need to convert.). Can you help me turn Sheet1 into Sheet2?

I have an indexed array Where I am tracking equipment(by serial number) at various locations. Ideally I want to type the location ID and receive a list of serials that are at that location. I have the formula but the problem is that it returns results 2 rows down from the desired results and I cant figure out why. This is the formula=INDEX($B3:$B$3000,SMALL(IF($E$3:$E$3000=$I$5,ROW($E$3:$E$3000)),ROW(1:1))-2:3000)

Need help using a vlookup to add small numeric values.

HI, is there a way of making a table within a table? so what i mean by that is if i need column A to be a big column for the top part but i need column a to be a small column down below id this possible and if so how do i do it ?

Need help applying conditional formatting to entire row, highlight the entire rows for top five highest positive and top five highest negative % change values . You will need to use LARGE and SMALL functions .

I am using the map chart function on Excel and certain text wont show on one of the states as the shape size is too small. How do I make it so that I can read the full text on the state instead of "4..."

my new Excel program accidentely got configured wrong for my spread sheets so then I tried to print on the desk top new program and now they both are printing wrong with small rows and lines instead of how it should be done.

I create numerous tabs in one worksheet. Each tab represents a project. When a project is complete I hide the tab. I now have over a hundred hidden tabs. On a regular basis I need to go back and look at the project. When I click on unhide I get a very small box that lists all the hidden tabs. The hidden tabs don't appear to be in any order. Because of this I have to scroll through this very small box looking for the right hidden tab. Very laborious and ineffcient. Is there a better way?