Hi sam,
super Idea
Nikhil Shah
On Sun, Apr 15, 2012 at 7:01 PM, Sam Mathai Chacko wrote:
> A shorter one
>
> =CHOOSE(CEILING(MONTH(A1)/3,1),"April","July","October","January")
>
> Regards,
> Sam
>
>
> On Sat, Apr 14, 2012 at 6:19 PM, Nikhil Shah wrote:
>
>> Hi Maries,
>>
>> Thanks for solving m
A shorter one
=CHOOSE(CEILING(MONTH(A1)/3,1),"April","July","October","January")
Regards,
Sam
On Sat, Apr 14, 2012 at 6:19 PM, Nikhil Shah wrote:
> Hi Maries,
>
> Thanks for solving my problem.
>
> Nikhil
>
> On Sat, Apr 14, 2012 at 6:15 PM, dguillett1 wrote:
>
>> You need to provide a file
Hi Maries,
Thanks for solving my problem.
Nikhil
On Sat, Apr 14, 2012 at 6:15 PM, dguillett1 wrote:
> You need to provide a file.
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Nikhil Shah
> *Sent:* Saturday, April 14, 2012 2:38 AM
> *To:* exc
You need to provide a file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Nikhil Shah
Sent: Saturday, April 14, 2012 2:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Quarter Classification
Dear Friends,
I want to make the whole year classif
Hi,
Previous one shows the next quarter.
Try below for previous quarter month,
=VLOOKUP(MONTH(TEXT(A1,"")&1),{1,"January";2,"January";3,"January";4,"April";5,"April";6,"April";7,"July";8,"July";9,"July";10,"October";11,"October";12,"October"},2,FALSE)
Regards,
MARIES.
On Sat, Apr 14, 2012
Hi,
Try it,
=VLOOKUP(MONTH(TEXT(A1,"")&1),{11,"January";12,"January";1,"January";2,"April";3,"April";4,"April";5,"July";6,"July";7,"July";8,"October";9,"October";10,"October"},2,FALSE)
Regards,
MARIES.
On Sat, Apr 14, 2012 at 11:38 AM, Nikhil Shah wrote:
> Dear Friends,
>
> I want to mak
