Then this would give me the second smallest value and so on. So in my case, I want the first smallest value, which is the smallest row number for each country. So my array would be the second helper column and I will lock the reference by pressing F4. And I will give K as 1 because I want the first smallest value. And when I press Enter and drag this down, it gives me the row numbers stacked up without any gaps. So now I have all the row numbers that I need to extract the data. Now in the cell below the first record, which is cell B10, I will use the Index formula to extract the product name. So the Index formula takes three arguments: the array, the row number, and the column number. So my array would be the data set, and I will lock this reference by pressing F4. The row number would be the first row number that I want to extract, which is in cell E9, and the column number would be 2 because I want to extract the product name, which is in column B. And when I press Enter and drag this down, it extracts all the product names based on the row numbers. Now in the cell next to it, which is cell C10, I will use the Index formula again to extract the sales rep name. So my array would be the data set, and I will lock this reference. The row number would be the first row number, which is in cell E9, and the column number would be 3 because the sales rep name is in column C. And when I press Enter and drag this down, it extracts all the sales rep names based on the...
Award-winning PDF software
Video instructions and help with filling out and completing Where Form 2220 Select
