Dear Experts,
Please help me to solve this query.
Thanks in advance
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
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://
Dear Experts,
Please help me to solve the query.
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
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/disc
Thank you Sanjeev for solving my query.
On Mon, Sep 19, 2016 at 5:32 PM, Sanjeev Tyagi
wrote:
> Dear Kalyan,
>
> Pls see the formula below. I hope it helps.
>
> =ABS(TRIM(MID(A2,SEARCH("gX",A2,1)-3,3)))&"g"
>
> Regards
> Sanjeev Tyagi
>
Dear Experts,
Please help me to solve the query
Thanks in advance
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
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
,"Y","N")
>
> On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel wrote:
>
>> Dear Experts,
>>
>> Please help me to solve the attached query.
>>
>> --
>> *Kalyan Chattopadhyay*
>>
>>
>> *Executive Corporate MIS*
>>
>&g
Dear Experts,
Please help me to solve the attached query.
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
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
Dear Experts,
Please help. Query is in the attached sheet.
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
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.faceboo
C4:R4)),1,0))
>
> Regards,
> Mandeep Baluja
>
> On Thursday, November 13, 2014 5:12:11 PM UTC+5:30, Kal xcel wrote:
>>
>> Dear Experts,
>>
>> Please help me to solve my query.
>>
>> Thanks in advance
>>
>> --
>> *Kalyan Chattopadhyay*
&g
Dear Experts,
Please help me to solve my query.
Thanks in advance
--
*Kalyan Chattopadhyay*
*Executive Corporate MIS*
*Joy Cosmetics*
--
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
Dear Excel lerner,
use SUMPRODUCT formula to get desired result
see the attached file
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thre
Congratulation ranjan.keep it up
On Sat, Oct 6, 2012 at 11:00 AM, xlstime wrote:
> Congratulations Mr. Rajan Ji
>
>
> On Wed, Oct 3, 2012 at 5:13 PM, NOORAIN ANSARI
> wrote:
>
>> I can say only...
>>
>> यूँ ही बरकरार रखो भाई अपने Expertise के छाप को.
>> और अपनी
Brother,
I think, beside your achievement I also achieved something……….that is..
I got a really nice person called “NOORAIN ANSARI”.
Till date whenever I faced any problem in excel I got immediate answer from
you.
So I can describe it like this…..
ANSWER = ANSARI
And your ACHIEVEMENT!
Dear Experts,
Sorry I send a wrong filesending the right one.
I need your help to storing data which generating from web. Details is in
attached file.
Please help
Thanks in advance.
--
Kalyan Chattopadhyay
Executive Sales Coordinator
R. S. H. Pvt. Ltd.
On Thu, Jul 26, 2012 at 5:19 P
Dear Experts,
I need your help to storing data which generating from web. Details is in
attached file.
Please help
Thanks in advance.
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, a
Dear Rajan,
I sincerely express my gratitude to you for your kind help and support that
you have extended towards me.
Noorain ,
Your excellent guidance over MS Excel has proved to be of immense help to
me in implementing my work. All the three options that you have taught me
are working smoothl
Dear Experts,
Please help me to solve my query. Details is in attached sheet.
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please He
Dear Brother,
I am really falling short of words to describe your dexterity. Your all
poems are simply mesmerizing and exhibit your talent not only over IT, but
in Literature too.
Keep on charming all of us with your talent.
Kalyan
2012/3/23 Venkat CV
> Dear Noorain,
>
> Superb
>
> *Be
Dear Brother,
Heartily congratulation to you. Really feeling proud to be your friend.
Keep it up.
On Mon, Mar 19, 2012 at 1:45 PM, NOORAIN ANSARI wrote:
> My heartly thanks to all of you.
>
> On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote:
>
>> Hello Everyone,
>>
>> Noorain Ansari has bee
NOORAIN ROCKS ONCE AGAIN
Really helpful attachment for excel user from one of the most helpful
member of the group
Thanks a lot brother
*Kalyan Chattopadhyay*
**
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use c
tion to this UDF: There are certain symbol characters
> that the KeyValue can't contain or the UDF will malfunction. That's
> because not all characters can be stored in a cell's ID property (the ID
> property is designed for HTML export use).
>
> ** **
>
> To see how the old date and KeyVa
Dear Priyanka,
Thanks for your super fast reply.
I have some queries
1. At C2 there is today(), today it is 17th, tomorrow that will be 18
and all date under C2 will change, so what will be the solution
2. If I gap one day…..suppose there is no entry on 18th , so how it
calculat
Dear Experts,
I am trying to make a document tracker, where I want to put date
automatically. If you see the attachment, when I am giving serial no.
Document no. & date will be appeared automatically. But next day that date
changing to current date which I don’t want.
Is there any process to ke
Brother (I always called Noorain by this),
Heartiest congratulation to you.you are not only an expert in
excel...There are few nice people in this world..YOU ARE ONE OF
THEM.
I am really happy for your achievement.keep it up.
Congratulation once again.
--
*Kalyan Chattopadhy
you are real Lover of EXCEL..
2011/9/16 NOORAIN ANSARI
> Dear Group,
>
> I have written a poem on MS Excel, Please read & Injoy..
>
> कौन कहता है यारों Excel एक समस्या है.
> मेरा मानना है की, Excel एक तपस्या है.
> भूल जाओगे स्वाद, दोस्त तुम रसगुल्लों का.
> लत अगर लग जा
quot;
> ",H8,1))),$C$2:$C$37,"<="&INT(RIGHT(H9,LEN(H9)-FIND(" ",H9,1
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogs
Dear Experts,
I am facing a problem when using sumifs formula, not getting desired result.
Plase help me to rectify the problem or better solution.
Thanks in advance
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
---
Thank you Daniel
On Fri, Sep 9, 2011 at 2:56 PM, Daniel wrote:
> Hi,
>
> ** **
>
> See attached file.
>
> ** **
>
> Regards.
>
> ** **
>
> Daniel
>
> ** **
>
> *De :* excel-macros@googlegroups.com [mailto:excel-macros@goo
Dear Haseeb,
Thanks for your reply. But result is not coming with this formula.
Thanks once again.
Kalyan Chattopadhyay
On Thu, Jul 28, 2011 at 12:21 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Kalyan,
>
> If you just have two customers, you can hard coded as array & use
Thanks a lot Ashish
On Wed, Jul 27, 2011 at 1:14 PM, ashish koul wrote:
> =SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw
> data'!C:C,"Distributor")+SUMIFS('Raw data'!D:D,'Raw data'!A:A,Query!B5,'Raw
> data'
It's great news.
I would like to congratulate all group members & thanks to all MVPs & other
members for their contribution.
A special thanks to Ayush for making & continuous monitoring this group.
Frankly speaking I am getting lot of help from this group. I learned excel a
lot from
Jul 18, 2011 at 2:28 PM, NOORAIN ANSARI wrote:
> Dear Kalyan,
>
> Please find attached sheet with solution.
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Mon, Jul 18, 2011 at
gt; * *
>>>
>>> *Private Sub Worksheet_Change(ByVal Target As Range)*
>>>
>>> *On Error GoTo Err:*
>>>
>>> *If Target = Range("A1") Then*
>>>
>>> *For i = 1 To Range("A1").Value*
>>>
>>>
Kalyan
On Fri, Jul 8, 2011 at 5:29 PM, ashish koul wrote:
> a2= a1+1
>
>
> On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel wrote:
>
>> Dear Experts,
>>
>> I want the formula for below mention query...
>>
>> user will put 100 in A1, from A2 autometical
Dear Experts,
I want the formula for below mention query...
user will put 100 in A1, from A2 autometically numbering will start like
this
A21
A32
A43
.
.
.
.
till 100
What will be the formula??
Please help
Thanks in advance
Kalyan Chatterjee
--
05 PM, ankur wrote:
>
>> *hi ashish sir
>> may this help u ...
>> *Have A Nice Time & Enjoy Life
>>
>> Regards:
>> CMA Ankur Pandey
>> (Someone Different)
>>
>> I'm not the best but i'm not like the rest~~
>>
>>
>
Hi L K Modi,
your query is not clear. Please elaborate.
Kalyan
On Wed, Jul 6, 2011 at 5:06 PM, ankur wrote:
> *HI LK MODI
> USED SUM BASED ON "COLOUR OF CELL" , MAY THIS HELP YOU
> USE THIS UDF, U CAN SEE THE CODE IN MODULE
>
>
> =ColorFunction($B$30,$B$2:$B$27,TRUE)
> WHERE B30 CELL IS HAVIN
Dear Experts,
For this chart
3001-5000 = 30
5001-6000 = 40
6001-7000 = 45
7001-8000 = 50
8001-9000 = 50
9001-15000 = 110
15001-25000 = 130
25001-4 = 150
40001>= =200
I use this formula:
=IF(AND(D16>=3001,D16<=5000),30,IF(AND(D16>=5001,D16<=6000),40,IF(AND(D16>=6001,D16<=7000),45,IF
Very intelligent solution by Noorain..
Jai, I am giving another solution
=VLOOKUP(IF(FIND(B17,Sheet1!B5,1),"*"&B17&"*",0),Sheet1!$B$5:$C$10,2,0)
Try this, it will search "RAM" or "ROH" in total string and show result.
"RAM or "ROH" could be anywhere in the string.
On Wed, Jul 6, 201
Very useful linkThanks to ALL
Kalyan
On Tue, Jul 5, 2011 at 1:30 PM, ashish koul wrote:
>
> try this book
>
>
> http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf
>
>
>
>
> On Tue, Jul 5, 2011 at 1:16 PM, Rajan_Verma wrote:
>
>> * *
>>
>> http://excelpoweruse
Congratulation Ashish...You deserve it
Kalyan
On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal wrote:
> [image:
> http://tracking.technodesignip.com/?action=count&projectid=642&contentid=6543&referrer=-&urlaction=r...]Congratulations
> *Ashish*, you deserve it.[image:
> http://trackin
amp;Final!$C$4,'Sale Data-10-11'!D:D,"<="&Final!$C$5)
>
> On Thu, Jun 9, 2011 at 7:21 PM, Kal xcel wrote:
>
>> Dear Experts,
>>
>> I need a help to
once again congratulation ashish...keep it up
Kalyan
On Fri, Jun 3, 2011 at 3:54 PM, NOORAIN ANSARI wrote:
> Congrate Sir ji...lage raho...
>
>
> On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain wrote:
>
>> Hello Everyone,
>>
>> Ashish Koul has been selected as 'Most Helpful Member' for the
Congratulation ashish.
On Wed, Apr 6, 2011 at 5:29 PM, Jorge Marques wrote:
> Congratulations Ashish especially for your help and also to this forum, i
> have to say my learnings in macro are exponential since this was created, i
> was a zero at the beginning!
>
>
> 2011/4/6 Aindril De
>
>> Co
Really useful link.
Thanks Ashish
Thanks a lot.
On Wed, Mar 30, 2011 at 10:59 AM, ashish koul wrote:
> Hi all
>
> To learn advance access, excel ,word, powerpoint, outlook VBA coding
> , open the weblink given below
> http://www.mvps.org/links.html#VisualBasic
>
>
> --
> *Regards*
> * *
> *As
Dear All,
I am sharing two types of outlook of a Sales Dashboard which I am preparing
for my company. I need your honest comment that looks wise which one is
better.
Thanks in advance
Kalyan
--
--
Some important
his helps you out...
>
>
> Regards,
> Manoj Kumar
>
>
> On Thu, Jan 13, 2011 at 8:58 PM, Dilip Pandey wrote:
>
>> Hi Kalyan,
>>
>> Attached file has been solved per your requirement(s). :)
>> Let me know if this works.
>>
>> Best Regards,
>> DILI
Dear experts,
Please help me on my quary. I have date wise depot wise product wise sale
amount. I need to extract sale between two dates matching with other two
criteria(Depot & Product). I have tried sumifs & sumproduct formula, but
result is not coming properly.
Please help
Thanks in advance
exactly Ayush, I have already tried Paul's solution but I didn't get desired
result.
I am attaching the file again with expected result
Please help
Thanks in advance
Kalyan
On Thu, Jan 6, 2011 at 6:13 PM, Ayush wrote:
> Right Paul, but your formula is counting duplicate values also.This user
Dear experts,
I have attached a file with query. Please help on that
Thanks in advance
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exce
Hi Dilip,
Many many congratulation to you. This group needs you. Keep it up.
On Wed, Jan 5, 2011 at 4:45 PM, SUMIT VYAS wrote:
> Dear Mr. Dilip
>
> *Congratulations to you*
>
>
> Regards
>
> Sumit Vyas
>
>
> On Mon, Jan 3, 2011 at 3:31 PM, Ayush wrote:
>
>> Dear Group,
>>
>> I am very very ve
Hi Anand,
could you send me the same. I have invited you to chat, if you agree then
accept. we will share knowledge.
Thanks in advance.
Kalyan
On Wed, Dec 1, 2010 at 12:26 PM, anandydr wrote:
> Hi,
>
> Sent the dashboard to all those who need it. I have collected these
> from internet and non
Dear Experts,
I am facing a problem to extract characters from right of string.
Please help.
Thanks in advance.
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
a here.
Thanks
Kalyan
On Sat, Oct 9, 2010 at 11:08 AM, SUMIT VYAS wrote:
> Dear
>
> one colum set structure :- month = jan-2008 jan-2009 jan-2010
>
> then use use pivot table
>
> On Sat, Oct 9, 2010 at 10:34 AM, Kal xcel wrote:
>
>> Hi Worawat,
>>
>&g
Thanks Alpesh,
Got the file, checking.
Thanks once again
Kalyan
On Sat, Oct 9, 2010 at 10:38 AM, Kal xcel wrote:
> Hi Alpesh,
>
> please help me that how to get that file.
>
> Thanks
>
> Kalyan
>
> On Sat, Oct 9, 2010 at 6:57 AM, pesh wrote:
>
>> Kalyan
eds.
>
> Thanks.
> Alpesh
>
> On Oct 8, 4:38 am, Kal xcel wrote:
> > Dear Experts,
> >
> > I want to extract last 3 months consolidated sale data based on current
> > month.
> >
> > I have attached the file with my query.
> >
> > Tha
ny excel function
>
>
> Worawat
>
> 2010/10/8, Kal xcel :
> > Dear Experts,
> >
> > I want to extract last 3 months consolidated sale data based on current
> > month.
> >
> > I have attac
Ayush,
>From the bottom of my heart I salute you.
Congratulation to you.
Feeling proud to became member of this group.
Thanks
Kalyan
On Sun, Oct 3, 2010 at 3:47 PM, Ayush wrote:
> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on Octobe
Dilip is very helpful person with blazingly meritorious and zenithal
brilliancy in excel
Keep it up Dilip. My all wishes with you.
Kalyan
2010/9/29 SUMIT VYAS
> Dear All R/s Friends
>
> Dilip Pandey is great personality . That is truth. He is genius and great
> knowledge of excel vba. I salute
Dear Experts,
I am sending a quary related Outstanding Tracking. Details in the attached
file.
Please help me.
Thanks in advance
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
Dear expert,
I am facing a problem to create dependent dropdown list.
Please check the attached file & help.
Thanks in advance
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tr
Dear Experts,
I am facing a problem to lookup data from another sheet. Please help me.
Details is in attached file.
Thanks in advance
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Wish *VERY HAPPY EID* to all members of group
Thanks
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN gro
gt;
> C.G.Kumar
>
>
>
> On Thu, Sep 9, 2010 at 3:21 PM, Kal xcel wrote:
>
>> Hi Kumar,
>>
>> Please find the attached file.
>>
>> Thanks in advance
>>
>> Kalyan
>>
>
>
--
---
for a sheet to be
> available on password, else u can simply go ahead n use protect sheet
> option available under Tools menu.
>
> Best Regards,
> DILIPandey
>
> On 9/8/10, Kal xcel wrote:
> > Hi Dilip,
> >
> > Thanks a lot for your help, but I am not comfo
Hi Kalyan,
>
> Please find the vlookup function working properly in the attached file.
>
> Feel free to write back in case of any queries.
>
> Warmest Regards,
> DILIPandey
>
> On 9/8/10, Kal xcel wrote:
> > Dear Experts,
> >
> > I need a help, I want to l
ame.
> >>>
> >>> What I have done I have instructed Excel to hide that side while
> >>> opening (Worksheet Open Event) and given a button for a user to click
> >>> if he/she wants that hidden sheet to unhide. See protection or
> >>> unprote
Dear Experts,
I need a help, I want to lookup value from selected dates.
File is attached
Thanks in advance
Kalyan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
h
Dear experts,
I am sending a file where I need to show a series of dates after giving
start date & end date.
File is attached .
Thanks in advance.
Kalyan
--
--
Some important links for excel users:
1. Follow us on
Hi dave,
Congratulation Dave,
Keep this type of mentality for ever.
Thanks
Kalyan
On Fri, Sep 3, 2010 at 10:31 AM, Ayush wrote:
> Hi Group,
>
> I am glad to announce that Dave Bonallack has topped in posting for
> the month of Aug'10 with 67 Posts (9% of group posts). He has done it
> repeti
Dear Experts,
I need a help...How to protect & hide(Both together) a sheet?
In attached file I need to "RSM" sheet will be password protected & hide, if
anybody wants to unhide the sheet it will ask password, then it will open.
Is it possible?
Thanks in advance
Kalyan
--
Dear Experts,
I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
extract only product name (like: Skin Fruits Instant Fairness Fruit Bleach)
from that string.
File is attached.
Thanks in advance
Kal
OUNTA(INDIRECT("'PRD Range'!D:D"))*
>
> So, counting the non-blank cells in range D, we got to know our 5th element
> (in the example, *6*).
> After joining this 5 informations together, our formula is reduced to:
> *=INDIRECT(**"'PRD Range'
Hi Pankaj,
Vlookup means Vertical lookup that is find the given value in vartical
order. vlookup is the way to find the particular data from master file. It
gives the data in vertical manner from the right side of the column against
which data has to find.
Syntax
VLOOKUP(lookup_value,table_array
Dear Vebhav,
Your problem is solved, see the attachment.
Kalyan
On Thu, Aug 26, 2010 at 9:39 AM, vebhav jain wrote:
> Hi All,
>
> Please find the attachment, where i finding the difficulty to get the right
> solution.I have narrated the problem clearly in the excel file.
>
> Thankyou,
> Vebhav
Hi venkat,
VLOOKUP formula will solveyour problem, see the attachment.
On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c wrote:
> Dear Group,
>
> I have attached sample data below i want to get defined criteria Emp id's.
> Can i have any formula's or Macros
>
> Best Regards,
> *
>
> Venkat
> *
>
Dear Jay,
Problem is solved. See the attachment.
On Wed, Aug 25, 2010 at 2:26 PM, lucky singh wrote:
>
> Hi,
>
> Need help in formula...
>
> I just need the only the first name to be extracted without space or gap...
>
> Regards,
> Jay S
> 8108932708
>
> --
>
> -
Dear Experts,
I need a help. I have a list of alpha-numeric string, (Like : Skin Fruits
Instant Fairness Fruit Bleach 14gm), all strings are not equal. I want to
extract only Numeric part (like14gm) from that string.
File is attached
Thanks in advance
Kalyan
--
---
Kalyan
On Wed, Aug 18, 2010 at 7:53 PM, ashish koul wrote:
> check the attachment
>
>
>
> Regards
> ASHISH
> akoul.blogspot.com
>
>
> On Wed, Aug 18, 2010 at 6:48 PM, Kal xcel wrote:
>
>> Dear Experts,
>>
>> I am attaching a file where I have
Dear experts,
I have SAP sales data, how to get top 10 distributor frm that huge data. One
distributor billed many times. Is there any mechanism??
Thanks in advance
Kalyan
--
--
Some important links for excel users
Hi,
I have this data in a sheet
*Depot Name* *BP Name - Report*
Ahmedabad H K Sales Agency - Sanand Ahmedabad Parshwa Traders -
Gandhinagar Ahmedabad Soham Agency - Chikhli Ambala Chaman Traders - Ambala
Ambala Shiv Trading Company - Assandh Ambala Happy Traders - Barara Ambala R.
K. Gene
80 matches
Mail list logo
