Re: $$Excel-Macros$$ Choose Formula

2015-02-10 Thread Sunil Kumar Yadav
Nice :-) On Mon, Feb 9, 2015 at 7:43 PM, Vaibhav Joshi wrote: > FYI choose formula: > > > =CHOOSE(Month,'Attn. Sheet.xlsx'!Jan,'Attn. Sheet.xlsx'!Feb,'Attn. > Sheet.xlsx'!Mar,'Attn. Sheet.xlsx'!Apr,'Attn. Sheet.xlsx'!May,'Attn. > Sheet.xlsx'!Jun,'Attn. Sheet.xlsx'!Jul,'Attn. Sheet.xlsx'!Aug,'Att

Re: $$Excel-Macros$$ Choose Formula

2015-02-09 Thread Vaibhav Joshi
FYI choose formula: =CHOOSE(Month,'Attn. Sheet.xlsx'!Jan,'Attn. Sheet.xlsx'!Feb,'Attn. Sheet.xlsx'!Mar,'Attn. Sheet.xlsx'!Apr,'Attn. Sheet.xlsx'!May,'Attn. Sheet.xlsx'!Jun,'Attn. Sheet.xlsx'!Jul,'Attn. Sheet.xlsx'!Aug,'Attn. Sheet.xlsx'!Sep,'Attn. Sheet.xlsx'!Oct,'Attn. Sheet.xlsx'!Nov,'Attn. She

Re: $$Excel-Macros$$ Choose Formula

2015-02-09 Thread Sunil Kumar Yadav
Good sir :-) and Thank you Sunil On Mon, Feb 9, 2015 at 3:40 PM, Vaibhav Joshi wrote: > Hi > > Use this array formula instead=: > > =INDIRECT("'Attn. Sheet.xlsx'!"&TEXT(DATE($B$1,Month,1),"MMM")) > > check att.. > > > Cheers!! > > On Mon, Feb 9, 2015 at 1:52 PM, Sunil Kumar Yadav > wrote: > >>

Re: $$Excel-Macros$$ Choose Formula

2015-02-09 Thread Vaibhav Joshi
Hi Use this array formula instead=: =INDIRECT("'Attn. Sheet.xlsx'!"&TEXT(DATE($B$1,Month,1),"MMM")) check att.. Cheers!! On Mon, Feb 9, 2015 at 1:52 PM, Sunil Kumar Yadav wrote: > Dear Experts, > > I want to know, what can i use choose formula in this file for get the > date 1 2 3 etc. > >

$$Excel-Macros$$ Choose Formula

2015-02-09 Thread Sunil Kumar Yadav
Dear Experts, I want to know, what can i use choose formula in this file for get the date 1 2 3 etc. -- Thanks & Regards Sunil Kumar Yadav -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www