![]() However, notice that if you want to pull this formula down, all three cells display the same result as cell D8. This is an optional argument which we can leave blank since we only have one column. – How many columns to the right it should move.In this case, the first occurrence is going to be unique since there is nothing on the list yet, and therefore we set it as 1. row_num – How many rows going down it should move.array – The area where the result can be found.To start: Cell D8 = INDEX(array,row_num,) One approach is to use the INDEX() function, where you can specify how many rows to go down for the formula to get to the next value that hasn’t occurred in the list yet. ![]() Create a list that summarizes the unique Division values in the data table.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |