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
Well Noted...
On Mon, May 26, 2014 at 7:36 PM, xlstime wrote:
> Dear Kannan,
>
> Please follow group rules
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> .
>
> Enjoy
> Team XLS
>
>
Dear Friends,
I want to know how to remove password in excel.
Please find the attached file and remove password.
--
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
*Dear Friends,*
*Please tell which is the best one, Ms Excel or Ms Access?*
--
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, accurat
Dear Ganesh & Ravinder,
I am also have this issue.
I saw your attachments, i don't know how to use this...
Kindly give a brief explanation.
On Sun, Apr 27, 2014 at 11:48 AM, Ganesh N wrote:
> Hi Yadav,
>
> you can also use this. Just put the data files in separate folder and put
> the path
;Duplicate value (you
> can create whatever format u want to show the duplicate values)
>
> Thanks & Regards,
> Ganesh N
>
>
> On Wed, Apr 30, 2014 at 11:27 AM, Kannan Excel wrote:
>
>> Dear Friends,
>>
>> Please find the attached file of excel, I have a d
Dear Friends,
Please find the attached file of excel, I have a doubt in that excel.
I checked the excel there is no formula and VBA coding but it is showing
duplicates.
How to do this in other excel... Please help me
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
Hi,
Please find the below mail and help me as soon as possible...
regards
Kannan V
-- Forwarded message --
From: Kannan Excel
Date: Wed, Mar 12, 2014 at 4:13 PM
Subject: $$Excel-Macros$$ MIS MASTER DATA FORMAT
To: Google
Hi,
Please send any MIS master data format. Because
Hi,
Please send any MIS master data format. Because i don't have any idea to
prepare master data.
We have 5 state and 150 employees, everybody send below mentioned reports.
1. Daily sale report.
2. Daily Purchase report.
3. Daily Tour and travelling expenses report.
4. Daily Stocks Transfer repo
Dear Friends,
I used below mentioned formula for INVOICE..
=INDEX('INVOICE DATA'!$A:$CD,MATCH($N$1,'INVOICE
DATA'!$C:$C,0),MATCH(L3,'INVOICE DATA'!$1:$1,0))
But i am having some problem.. Kindly check the attached file and clear the
issue as soon as possible..
Thanks & Regards
Kannan V
--
A
Hi,
Please help,
How to convert number to Indian rupees with caps letters in excel formula...
regards
Kannan V
--
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
Dear Friends,
I required attendance format for my company. Kindly give advanced
attendance template... don't give simple templates.
Kindly do the needful as soon as possible...
regards
Kannan V
--
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) !
:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 3:32 PM
>
> *To:* Google
> *Cc:* Soum
> *Subject:* Re: $$Excel-Macros$$ INDEX MATCH DOUBT
>
> ** **
>
> *HEY AWESOME, FANT
#x27;MASTER DATA'!$A$2:$AQ$65000,MATCH($F$4,'MASTER
> DATA'!$D$2:$D$65000,0),MATCH($B18&$C$17,'MASTER
> DATA'!$A$1:$AQ$1&'MASTER DATA'!$A$2:$AQ$2,0)+COLUMN()-3) ctrl+shift+enter
>
>
> ** **
>
> ** **
>
> *From:* excel-macro
x27;!$A$2:$AQ$2,0)+COLUMN()-3)
On Tue, Oct 8, 2013 at 2:53 PM, Ravinder wrote:
> I think this one help u
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kannan Excel
> *Sent:* Tuesday, October 08, 2013 2:38 P
That also i tried... :-( but no use. it too urgent, anybody help me
On Tue, Oct 8, 2013 at 2:25 PM, Ravinder wrote:
> I think u did not mentioned “BITUMEN’ in second sheet
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On
*HI,*
*
*
*PLS FIND THE ATTACHED FILE AND DO THE NEEDFUL PRIORITY BASE..*
*
*
*
*
*REGARDS*
*KANNAN V*
--
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 RULE
nice info
On Thu, Aug 1, 2013 at 7:27 PM, ashish koul wrote:
> visit this link for more intersting facts
>
> http://office.microsoft.com/en-in/excel-help/excel-specifications-and-limits-HP010073849.aspx
>
>
>
> On Thu, Aug 1, 2013 at 6:46 PM, Amit Desai (MERU) > wrote:
>
>> Dear Masters,
WELCOME EVERYBODY... :-)
Regards
Kannan.Excel
On Sun, Aug 4, 2013 at 2:23 PM, priti verma wrote:
> Most Welcome Niraj
>
>
> On Sat, Aug 3, 2013 at 11:31 PM, xlstime wrote:
>
>> Welcome Niraj
>>
>> .
>>
>> Enjoy
>> Team XLS
>>
>>
>>
>> On Sun, Aug 4, 2013 at 10:56 AM, Nir
heers
> Umar
>
>
> On Mon, Jul 29, 2013 at 12:37 PM, Kannan Excel wrote:
>
>> how to make this???
>>
>> can u send code???
>>
>> and if i type user and pswd means, permission granted or user has expired
>> message only appear...
>>
>> exce
thanks thanks a lot i am really happy.
On Mon, Jul 29, 2013 at 2:13 PM, De Premor wrote:
> sorry little mistake there, try new attached
>
>
> On 29/07/2013 15:37, Kannan Excel wrote:
>
> how to make this???
>
> can u send code???
>
> and
et
>
>
> On 29/07/2013 13:05, Mangesh Vimay wrote:
>
>> Thanks for asking this query.
>>
>> Appreciate your mind !!!
>>
>> And also thanks De Pemor for the solution.
>>
>> Have a great day all !!!
>>
>> On 7/29/13, Kannan Excel wr
n a sheet
>
>
> On 29/07/2013 13:05, Mangesh Vimay wrote:
>
>> Thanks for asking this query.
>>
>> Appreciate your mind !!!
>>
>> And also thanks De Pemor for the solution.
>>
>> Have a great day all !!!
>>
>> On 7/29/13, Kannan Exc
ot;A1") = "EXPIRED"* Then
> MsgBox "File " & ThisWorkbook.FullName & " expired"
>*if Sheet1**.Range(**"A1") <> "EXPIRED" then
> ** Sheet1.Range("A1") = "EXPIRED"**
&g
Hi,
how to make a file expire after a period of time.
regards
Kannan V
--
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 t
hi,
pls find the attached file,
2nd sheet is master data... 1st sheet is searching data...
if i enter employee id in 1st sheet 2nd sheet data want to come
automatically...
pls do the needful urgent base
regards
Kannan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
hi friends,
anybody have excel time tracking format?? i want to track my employee
details in excel.. if i enter my employee id number means his it will come
automatically pls send asap...
regards
Kannan V
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2
hi friends i want courier management data format in excel
regards
kannan
--
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
PLS HELP ME
-- Forwarded message --
From: kannan excel
Date: Tue, Feb 26, 2013 at 11:59 AM
Subject: URGENT PLS HELP ME IN EXCEL WORK
To: Google , nishant mendiratta <
nishant.mendira...@gmail.com>, amit.de...@merucabs.com
Hi,
Pls find the attachment. here i enclo
annan,
>
> Pl eaborate your query??
>
>
> Warm Regards,
> Gawli Anil
>
>
>
>
>
> On Tue, Feb 26, 2013 at 11:59 AM, kannan excel wrote:
>
>> Hi,
>>
>> Pls find the attachment. here i enclosed my sample data. i want soluti
.mendira...@gmail.com> wrote:
> Hi,
> The solution is attached.
>
> On Mon, Feb 11, 2013 at 11:00 AM, kannan excel wrote:
>
>> Hi,
>>
>> pls find the attachment file... here i enclosed my excel sheet i want
>> vlookup formula for 2 sheets. anybody
THANKS BOSS THANKS YOU VERY MUCH :)
REGARDS
KANNAN V
On Mon, Feb 11, 2013 at 11:22 AM, nishant mendiratta <
nishant.mendira...@gmail.com> wrote:
> Hi,
> The solution is attached.
>
> On Mon, Feb 11, 2013 at 11:00 AM, kannan excel wrote:
>
>> Hi,
>>
Hi,
pls find the attachment file... here i enclosed my excel sheet i want
vlookup formula for 2 sheets. anybody help me urgent...
regards
kannan v
9940110453
--
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 thi
hi friends,
i want courier management format in excel vb coding. like a MIS.
Anybody have that format???
pls send quickly..
regards
kannan
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Hi friends,
i need mis report format for hr purpose. kly help me urgent base.
regards
kannan v
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor th
Thanks:)
On Wed, Aug 31, 2011 at 10:36 PM, NOORAIN ANSARI
wrote:
> Dear Kanan,
>
> Please see attached sheet..
>
> On Tue, Aug 30, 2011 at 6:25 PM, kannan excel wrote:
>
>> Hi Excel Guru's,
>>
>> PFA
>>
>> pls help me. i want
t;
> * *
>
> *Hope it will helps you.*
>
> * *
>
> *Rajan.*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *kannan excel
> *Sent:* Tuesday, August 30, 2011 6:25 PM
> *To:* Google
> *Subject:*
Hi NOORAIN ANSARI,
Pls tell wat is this.??
if you feel free explain me.
Regards
V. Kannan
Aircel Limited
Chennai
On Mon, Aug 29, 2011 at 3:38 PM, NOORAIN ANSARI wrote:
> Dear Anil,
>
> Use Alt+A Q for Advance filter..
> Choose *Filter the list-List range-Criteria range-Unique Records only
>
> *
Hi rajan,
good work. keep it up.
fantastic
regards
Kannan V
Aircel limited
On Sat, Aug 27, 2011 at 6:48 PM, Rajan_Verma wrote:
> Hi Group,
>
> Refer the attached sheet with some Data Sorting Example. Hope you will like
> it
>
> ** **
>
> Rajan.
>
> ** **
>
> --
>
> -
Thanks Guru.
i am really happy.
Regards
Kannan V
Aircel Limited.
Chennai
On Sat, Aug 27, 2011 at 5:03 PM, Venkat CV wrote:
> Hi Kannan..
>
> Look attached...
>
> On Sat, Aug 27, 2011 at 4:37 PM, kannan excel wrote:
>
>> Pls help guru, its most urgent for me.
>
Pls help guru, its most urgent for me.
help me
On Sat, Aug 27, 2011 at 4:20 PM, kannan excel wrote:
> Sorry Guru,
>
> Not i attached valid SIM NUMBER. You can match that in sim number
>
>
> thanks & regards
> Kannan V
> Aircel Limited
> Chennai
>
>
>
>
Good Kaushik!!
I wish to invite you:
On Mon, Jun 20, 2011 at 8:58 PM, kaushik wrote:
> Hi ,
>
> I wanna join this group
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips t
Hi Guru.
My excel was corrupted, how to recovery my excel..
Kannan V
9941077703
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2.
Hi Guru
Pls help me i am waiting for your reply.
regards
Kannan V
9941077703
onechennaiproperty.com
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://
Hi Dave,
Good Morning.
Thanks .
Regards
Kannan V
9941077703
onechennaiproperty.com
On Thu, Jun 16, 2011 at 2:06 PM, Dave Bonallack
wrote:
> Hi Kannan,
> Have a look at the attached
> Regards - Dave
>
> --
> Date: Thu, 16 Jun 2011 09:03:35 +0530
> Subject
*NOORAIN ANSARI
> *Sent:* Wednesday, June 15, 2011 7:30 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ how to put password in vba coding.??
>
>
>
> Dim x As Worksheet
> Sub Protectsheet()
>
> For Each ws In Worksheets
> x.Protect Pa
Hi Guru...
how to put password in vba coding.??
how to protect that?
regards
Kannan V
9941077703
onechennaiproperty.com
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Hi Venkat
fantastic job... how u do this all...
amazing
thanks its help our company also.
thanks guru.
kannan V
On Tue, Jun 14, 2011 at 11:14 AM, Venkatesan c wrote:
> Dear Vivek,
>
> Find attached file and use get file names option...You may get it
>
>
> *Best Regards,*
> *Venkat*
>
>
Its working good. thanks..
regards
kannan V
On Fri, Jun 10, 2011 at 7:43 AM, STDEV(i) wrote:
> =OFFSET($A$1,MATCH(E2,$B$2:$B$8,0),0)
> or
> =INDEX($A$2:$B$8,MATCH(E2,$B$2:$B$8,0),1)
>
>
>
>
>
> On Fri, Jun 10, 2011 at 3:14 AM, hanumant shinde
> wrote:
>
>> Hi friends,
>>
>> this is really
Hi Excel Guru,
i don't want to enter same mobile number. so i need matching or tracing
formula.
If I entered mobile number in a column means, how do i know? i already
entered this mobile number.
pls find my attachment.
regards
kannan V
onechennaiproperty.com
--
--
If i put my executive name, his weekly and monthly perfomance will come
automatically
On Sat, May 21, 2011 at 5:31 PM, kannan excel wrote:
> Hi rajan,
>
> i am maintain our office Productivity tracker.
> my boss asked our executive weekly and monthly perfomance sheet.
>
> now i
51 matches
Mail list logo