Dear Friends,
Please tell what are the skills required for MIS executive.
--
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.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate
Ok, here you go..
Also do you need to change no. format to match with your native currency?
+
*I did not do this for you. God is here working through me for you.*
On Sun, Nov 9, 2014 at 11:49 PM, ivavok
wrote:
> Hi,
>
> that´s perfect! Thanks. Just the comma is decimal not between thousand
you need to add sort on first column at the end...rest all is ok...
You can do it manually let me know if you need help...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sun, Nov 9, 2014 at 11:33 PM, prkhan56 wrote:
> Hi Vaibhav,
> Please find the attac
Hi,
that´s perfect! Thanks. Just the comma is decimal not between thousands. So
the first figure should be 15 750,00 and not 1 575 000,00...How should I
change the macro so that it works this way?
Thank you in advance!
Dne neděle, 9. listopadu 2014 15:20:35 UTC+1 Vabz napsal(a):
>
> Hi
>
> Try
Hi Pramod
The data can be in many columns
See sheet 'tan'
On Sunday, November 9, 2014 6:46:10 PM UTC+4, pramodb35 wrote:
>
> Can u send us with a big dummy data.
>
> Then we can change on this.
>
> Pramod
> On 9 Nov 2014 19:11, "prkhan56" > wrote:
>
>> Thanks
>> Works great
>> A small problem
>
Hi Vaibhav,
Please find the attached file
Your macro does not give output as per my requirement.
See Sheet1 for desired results... I have shown results only for two
employees data
Regards
Rashid
On Sunday, November 9, 2014 8:11:30 PM UTC+4, Vabz wrote:
>
> Hi Rashid,
>
>
> PFA, i have made it t
Check this if it helps...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 8, 2014 at 6:10 PM, Ajay AJ wrote:
>
> Hey,
>
> So the basic concept is that he dates are for PPM Schedule so which means
> whenever it was left off, it has to be done
Check this...
You need to select Pvt Tbl Tools, Options, Formulas & then Calculated
Item...
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 8, 2014 at 1:26 PM, Tarun Verma wrote:
> Hi Team,
>
> Today i am tucked in a problem related to pivot. I
Hi Rashid,
PFA, i have made it to select any range as Input with specific cell as
destination.
On prompting first select entire range Range A1:E3 in this case,
then on prompt select destination cell i.e.cell H1 or any cell you want...
Cheers!!
+
*I did not do this for you. God is here wor
Your welcome Ivaana
Regards
Pramod
Www.facebook.com/Pramodbish
Pramod
On 9 Nov 2014 18:45, "ivavok" wrote:
> Hi,
>
> thank you, that´s perfect!
>
> Dne neděle, 9. listopadu 2014 5:08:16 UTC+1 pramodb35 napsal(a):
>>
>> Hi Dear,
>>
>>
>> Please find the attached file. Hope this will be fine for
Can u send us with a big dummy data.
Then we can change on this.
Pramod
On 9 Nov 2014 19:11, "prkhan56" wrote:
> Thanks
> Works great
> A small problem
> The date comes as serial no. in transposed data
> Can you fix this please
>
> Regards
>
> On Sunday, November 9, 2014 4:18:10 PM UTC+4, pram
Hi
Try this, Run macro by clicking blue button, select range containing number
when prompted!!
You will get output as desired without help of any helper sheet.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Nov 8, 2014 at 1:46 PM, ivavok
wrote:
>
Thanks
Works great
A small problem
The date comes as serial no. in transposed data
Can you fix this please
Regards
On Sunday, November 9, 2014 4:18:10 PM UTC+4, pramodb35 wrote:
>
> Hi Prkhan,
>
>
> PFA...
>
> On Sun, Nov 9, 2014 at 1:48 PM, prkhan56 >
Namaste Vaibhav Joshi
I'm still learner like you..
And the is only one way to learn..
Participate even though you know it or not!
This will invoke a keen learning habit n openes up new avenues.
Cheers buddy!!
On Nov 9, 2014 10:42 AM, "Vaibhav Joshi" wrote:
> Hi I am vaibhav joshi from Mumb
Hey Paul R
Cheers n nice to see you!
On Nov 9, 2014 6:17 AM, "Paul Reader" wrote:
>
>> Hi all,
>>
> I'm Paul from Australia.
> A former corporate IT trainer and small solution developer interested in
> bringing my knowledge up to date.
> My other interests include photography, web development,
Hi,
thank you, that´s perfect!
Dne neděle, 9. listopadu 2014 5:08:16 UTC+1 pramodb35 napsal(a):
>
> Hi Dear,
>
>
> Please find the attached file. Hope this will be fine for you.
>
> Regards
> Pramod
>
> On Sun, Nov 9, 2014 at 1:05 AM, ivavok > wrote:
> > Hi PramodSingh ,
> >
> > T
Hi Prkhan,
PFA...
On Sun, Nov 9, 2014 at 1:48 PM, prkhan56 wrote:
> Hello All,
> I am using Excel 2010
> I need a macro to transpose several Rows into respective Columns
>
> Please see attached sample file for 'Before' and 'After'
>
> TIA
>
> Rashid
>
> -
Hello All,
I am using Excel 2010
I need a macro to transpose several Rows into respective Columns
Please see attached sample file for 'Before' and 'After'
TIA
Rashid
--
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
18 matches
Mail list logo
