The methods we have described can capture changes in the existing dataset. However, when you add new entries after the last row of the dataset, they are not included in the formula output. This method will use theTablefeature to overcome that issue. Follow the steps to accomplish the task....
To save time, I am using Power Query since I will receive the same excel sheet every month (same format). After I load the excel sheet into Power Query and start transforming the data, I want to sort the data/time values in Ascending Order (Earliest to ...
this is really awesome, thank you so much for your help! It looks like time is not in ascending order: do you have a clue how to order the time 'smallest to largest'? Do I have to go to Sort&Filter or is there an additional input? You're of great help. Thank you! Paolo...
It also includes commands to insert and delete columns and to sort data by column, with or without a header row, and respecting numeric order and lexicographical order as appropriate. An entire column may be block selected (Select column), which enables complex operations like quickly reordering,...
{=IFERROR(INDEX(Data, SMALL(IF($DE$2=Data[DATE], ROW(Data[TIME])-ROW(Data[[#Headers],[TIME]])), ROW(1:1)),4),"" )} entered as array pressing Ctrl+Shift+Enter. Cheers, View solution in original post DQ39 Report.xlsx 54 KB 1 Like Reply undefined...
{=IFERROR(INDEX(Data, SMALL(IF($DE$2=Data[DATE], ROW(Data[TIME])-ROW(Data[[#Headers],[TIME]])), ROW(1:1)),4),"" )} entered as array pressing Ctrl+Shift+Enter. Cheers, View solution in original post DQ39 Report.xlsx 54 KB 1 Like Reply undefined...
Hi , this is really awesome, thank you so much for your help! It looks like time is not in ascending order: do you have a clue how to order the time
{=IFERROR(INDEX(Data, SMALL(IF($DE$2=Data[DATE], ROW(Data[TIME])-ROW(Data[[#Headers],[TIME]])), ROW(1:1)),4),"" )} entered as array pressing Ctrl+Shift+Enter. Cheers, View solution in original post DQ39 Report.xlsx 54 KB 1 Like Reply undefined...
It looks like time is not in ascending order: do you have a clue how to order the time 'smallest to largest'? Do I have to go to Sort&Filter or is there an additional input? You're of great help. Thank you! Paolo 0 Likes Reply wumolad replied to paoloambro May...
{=IFERROR(INDEX(Data, SMALL(IF($DE$2=Data[DATE], ROW(Data[TIME])-ROW(Data[[#Headers],[TIME]])), ROW(1:1)),4),"" )} entered as array pressing Ctrl+Shift+Enter. Cheers, View solution in original post DQ39 Report.xlsx 54 KB 1 Like Reply undefined...