Flagging first order on transaction table

[Jlhoffner]

I am trying to identify and flag in a calculated column a customer's first order on a transaction table that contains:

Order Num
Cust Num
Order Date
Order Amt

So if the same Cust Num appears twice associated with two different orders on two different dates, how could I flag the earliest order as the first order and all other orders as NOT the first order?

Any ideas?

Jude

 

[alansidman]

http://blog.contextures.com/archives/2011/07/27/finding-min-if-or-max-if-in-excel/

Look at this link. this may be a possibility