I have a requirement where i am showing multiple values in a sheet.
For example i have table 1, table 2, table 3, table 4
Now table 1 has a max date of 29th jun
Table2 has a max date of 28th june
Similarly table 3 has 29th June
Table 4 --> 28th June
So the sheet should display the variable that max from each table. But i am not able to do the same as its showing only 29th Jun data and leaving out 28th.
Presently:
Want it to be as :
Any ideas. The list box is selected from common columns across while the individua date times are unique columns across.