I have data which has prices for all the months. I want to divide the price of each month by the price of a particular month. Is this possible?
I'm attaching the sample data i use below.
Archana, thanks for posting the sample data, makes my work easier. I'm pretty sure this is what you're looking for:
SUM([Price])/LOOKUP(SUM([Price]), FIRST()+[Divide by Which Month?]-1)
See attached workbook.
Thanks a lot Shawn. That worked!
Retrieving data ...