MinIF calculated column

[cajste]

Hi,

I'm sure this is a very simple problem, but I can't get it right for some reason. In the Min_ActualTime column I want to find the lowest ActualTIme value for each of the two PathIdent2 categories, and in the same way find the highest ActualTime value in the Max_ActualTime. How do I do that?

I entered the Min and Max values manually to give you an idea of what I want it to look like.

Brgds,
Caj


[TABLE="width: 764"]
<tbody>[TR]
[TD]PathIdent2
[/TD]
[TD]ActualTime
[/TD]
[TD]Min_ActualTime
[/TD]
[TD]Max_ActualTime
[/TD]
[/TR]
[TR]
[TD]17058 2012-05-14 07:23:00
[/TD]
[TD]2012-05-14 08:03
[/TD]
[TD]2012-05-14 08:03
[/TD]
[TD]2012-05-14 08:23
[/TD]
[/TR]
[TR]
[TD]17058 2012-05-14 07:23:00
[/TD]
[TD]2012-05-14 08:10
[/TD]
[TD]2012-05-14 08:03
[/TD]
[TD]2012-05-14 08:23
[/TD]
[/TR]
[TR]
[TD]17058 2012-05-14 07:23:00
[/TD]
[TD]2012-05-14 08:14
[/TD]
[TD]2012-05-14 08:03
[/TD]
[TD]2012-05-14 08:23
[/TD]
[/TR]
[TR]
[TD]17058 2012-05-14 07:23:00
[/TD]
[TD]2012-05-14 08:16
[/TD]
[TD]2012-05-14 08:03
[/TD]
[TD]2012-05-14 08:23
[/TD]
[/TR]
[TR]
[TD]17058 2012-05-14 07:23:00
[/TD]
[TD]2012-05-14 08:21
[/TD]
[TD]2012-05-14 08:03
[/TD]
[TD]2012-05-14 08:23
[/TD]
[/TR]
[TR]
[TD]17058 2012-05-14 07:23:00
[/TD]
[TD]2012-05-14 08:23
[/TD]
[TD]2012-05-14 08:03
[/TD]
[TD]2012-05-14 08:23
[/TD]
[/TR]
[TR]
[TD]15183 2013-01-29 22:02:00
[/TD]
[TD]2013-01-29 22:59
[/TD]
[TD]2013-01-29 22:59
[/TD]
[TD]2013-01-29 23:25
[/TD]
[/TR]
[TR]
[TD]15183 2013-01-29 22:02:00
[/TD]
[TD]2013-01-29 23:25
[/TD]
[TD]2013-01-29 22:59
[/TD]
[TD]2013-01-29 23:25
[/TD]
[/TR]
</tbody>[/TABLE]

 

[miguel.escobar]

Hey,


Note sure if it's just me but, it's hard to understand what you're really looking for so I'm just gonna take a guess here :


What if you use the MINX with the EARLIEST? (calculated column)


do you have a workbook that you could share to see the data model and maybe come up with a solution?


best!

 

[cajste]

Another simple question, how do I attach a file?

//Caj

 

[miguel.escobar]

send it here:

or if you have dropbox or any other that would be awesome too!

 

[cajste]

The file is on its way, let me know if you haven't received it!

 

[miguel.escobar]

Caj,

Check out the file https://dl.dropbox.com/u/54063091/Suggestion.xlsx

It's only a suggestion as I don't know if you need a measure or a calculated column. I did the calculated column as I'm assuming that you want to use those MIN and MAX against the records of your table to determine a variance and some sort of range.

So basically I did this:
1. Create a helper dates table
2. Create 2 formulas (column MIN and Column MAX)

check them out and let me know what you think. If you want the measure approach we could do that as well but it depends on how you're gonna be analyzing the data.

best!

Edit: you know what? I forgot to take in consideration the other columns :S, question, do you need a calculated column or a measure?