Hi I’d like to create a spreadsheet but am not very knowledgeable on the various functions excel has.
I’ve tried to create an example of what I’d like to do.
I’d like to automate the following:
extract information from the following table. Eg pull all the ‘Apples’ information
Input Table
Input Table.png
Then create a new table on ‘Apples’ and show the information in sequential order.
Output Table 1.png
And then in the row below, calculate the difference between the apple selected and the time the next sequential apple picked.
Output Table 2.png
And then in the bottom row, calculate the difference between the apple selected and its next substitute apple.
Output Table 3.png
I've done all this with individual formulas but really the data set could up to 1000 entries so figuring out how to automatically do the above would
be great. I hope this is enough info but please let me know if I need to provide more.
Bookmarks