Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
Please help in finding max date from a table.
Problem description is as follows
The list box here shows the date values present in my table. The highlighted date is the max date in that table
The table below shows the rows in the table corresponding to the max date
Now my requirement is something like below:
When I come to a particular sheet i will have a gauge chart wherin I have to display the sum(msc_med_v_med_count) for the max date. But I will not have the list box or any selection object in the sheet.
How I can I do this? Please help me with a solution
Thanks in advance
Praveena
See the example attached, does that help.
In your case something like this:
= num(sum(if(Date=Max(Total Date),msc_med_v_med_count)) ,'##.##','.') / 100
Maybe something like
sum( if(DATE = MAX(DATE),msc_med_v_med_count))
See the example attached, does that help.
In your case something like this:
= num(sum(if(Date=Max(Total Date),msc_med_v_med_count)) ,'##.##','.') / 100
Thanks Mark.. This worked for me