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 @
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 @
ds
> Sanjeev Tyagi
>
> On Mon, Sep 19, 2016 at 4:47 PM, Kal xcel <kalx...@gmail.com> wrote:
>
>> Dear Experts,
>>
>> Please help me to solve the query
>>
>> Thanks in advance
>>
>> --
>> *Kalyan Chattopadhyay*
>>
>>
>>
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 @
$G9,$B:$B,$F9,$C:$C,H$4)=1,"Y","N")
>
> On Fri, Sep 16, 2016 at 9:47 PM, Kal xcel <kalx...@gmail.com> wrote:
>
>> Dear Experts,
>>
>> Please help me to solve the attached query.
>>
>> --
>> *Kalyan Chattopadhyay*
>&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 @
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 @
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*
*Executive Corporate MIS*
*Joy Cosmetics*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
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 @
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
Congratulation ranjan.keep it up
On Sat, Oct 6, 2012 at 11:00 AM, xlstime xlst...@gmail.com wrote:
Congratulations Mr. Rajan Ji
On Wed, Oct 3, 2012 at 5:13 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
I can say only...
यूँ ही बरकरार रखो भाई अपने
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
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,
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
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
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
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 venkat1@gmail.com
Dear Noorain,
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 noorain.ans...@gmail.comwrote:
My heartly thanks to all of you.
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.comwrote:
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
:
** **
Function id(ref As Range)
Application.Volatile
id = ref.id
End Function
** **
Asa
** **
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Kal xcel
*Sent:* Friday, February 17, 2012 3:00 AM
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
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
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
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.*
--
$37,=INT(RIGHT(H9,LEN(H9)-FIND( ,H9,1
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Sep 16, 2011 at 4:11 PM, Kal xcel kalx...@gmail.com wrote
Thank you Daniel
On Fri, Sep 9, 2011 at 2:56 PM, Daniel dcolarde...@free.fr wrote:
Hi,
** **
See attached file.
** **
Regards.
** **
Daniel
** **
*De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
*De la part de* Kal xcel
*Envoyé
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 1
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
18, 2011 at 2:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
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 1:51 PM, Kal xcel kalx
@googlegroups.comhttp://mc/compose?to=excel-macros@googlegroups.com
*Cc:* Kal xcel
*Subject:* Re: $$Excel-Macros$$ Numbering
** **
kalyan babu.
Please try it..also
=IF(A2=,,COUNTA($A$2:A2))
On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel
kalx...@gmail.comhttp://mc/compose
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
--
Kalyan
On Fri, Jul 8, 2011 at 5:29 PM, ashish koul koul.ash...@gmail.com wrote:
a2= a1+1
On Fri, Jul 8, 2011 at 4:35 PM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
I want the formula for below mention query...
user will put 100 in A1, from A2 autometically numbering will start
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~~
On Wed, Jul 6, 2011 at 5:30 PM, ashish koul koul.ash...@gmail.comwrote:
On Wed, Jul 6, 2011 at 4:56 PM, Kal xcel kalx
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, 2011 at 3:49
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:
Hi L K Modi,
your query is not clear. Please elaborate.
Kalyan
On Wed, Jul 6, 2011 at 5:06 PM, ankur ankurpande...@gmail.com 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
Congratulation Ashish...You deserve it
Kalyan
On Mon, Jul 4, 2011 at 11:17 PM, Ahmed galal ahmed.ga...@live.com wrote:
[image:
http://tracking.technodesignip.com/?action=countprojectid=642contentid=6543referrer=-urlaction=r...]Congratulations
*Ashish*, you deserve it.[image:
Very useful linkThanks to ALL
Kalyan
On Tue, Jul 5, 2011 at 1:30 PM, ashish koul koul.ash...@gmail.com wrote:
try this book
http://www.recordexcelmacro.com/vebooks/RecordExcelMacrosthatWork.pdf
On Tue, Jul 5, 2011 at 1:16 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
once again congratulation ashish...keep it up
Kalyan
On Fri, Jun 3, 2011 at 3:54 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Congrate Sir ji...lage raho...
On Thu, Jun 2, 2011 at 10:29 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Ashish Koul has been
Congratulation ashish.
On Wed, Apr 6, 2011 at 5:29 PM, Jorge Marques leote.w...@gmail.com 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
Really useful link.
Thanks Ashish
Thanks a lot.
On Wed, Mar 30, 2011 at 10:59 AM, ashish koul koul.ash...@gmail.com 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
--
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
,
Manoj Kumar
On Thu, Jan 13, 2011 at 8:58 PM, Dilip Pandey dilipan...@gmail.comwrote:
Hi Kalyan,
Attached file has been solved per your requirement(s). :)
Let me know if this works.
Best Regards,
DILIPandey
On Thu, Jan 13, 2011 at 7:11 PM, Kal xcel kalx...@gmail.com wrote:
Dear
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
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 :
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 jainayus...@gmail.com wrote:
Right Paul, but your formula is counting duplicate
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 svyas0...@gmail.com wrote:
Dear Mr. Dilip
*Congratulations to you*
Regards
Sumit Vyas
On Mon, Jan 3, 2011 at 3:31 PM, Ayush jainayus...@gmail.com wrote:
Dear
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 anand...@gmail.com wrote:
Hi,
Sent the dashboard to all those who need it. I have collected these
from
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
On Sat, Oct 9, 2010 at 11:08 AM, SUMIT VYAS svyas0...@gmail.com 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 kalx...@gmail.com wrote:
Hi Worawat,
Thanks for your advice. But I can't
excel function
Worawat
2010/10/8, Kal xcel kalx...@gmail.com:
Dear Experts,
I want to extract last 3 months consolidated sale data based on current
month.
I have attached the file with my query.
Thanks in advance
Kalyan
.
Thanks.
Alpesh
On Oct 8, 4:38 am, Kal xcel kalx...@gmail.com 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.
Thanks in advance
Kalyan
How to find data of previous month.xlsx
Thanks Alpesh,
Got the file, checking.
Thanks once again
Kalyan
On Sat, Oct 9, 2010 at 10:38 AM, Kal xcel kalx...@gmail.com wrote:
Hi Alpesh,
please help me that how to get that file.
Thanks
Kalyan
On Sat, Oct 9, 2010 at 6:57 AM, pesh alpes...@gmail.com wrote:
Kalyan,
Please
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 jainayus...@gmail.com wrote:
Dear Group,
I am proud to announce that I am awarded Microsoft Most Valuable
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 svyas0...@gmail.com
Dear All R/s Friends
Dilip Pandey is great personality . That is truth. He is genius and great
knowledge of
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
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
...@gmail.com wrote:
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 kalx...@gmail.com wrote:
Dear Experts,
I need a help, I want to lookup value from selected
asking 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 kalx...@gmail.com wrote:
Hi Dilip,
Thanks a lot for your help, but I am not comfortable with VBA.
is it possible
Hi dave,
Congratulation Dave,
Keep this type of mentality for ever.
Thanks
Kalyan
On Fri, Sep 3, 2010 at 10:31 AM, Ayush jainayus...@gmail.com 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
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
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
,
Maries
On Mon, Aug 30, 2010 at 5:58 PM, Bruno Bruno brunobbr...@gmail.comwrote:
Hi Kalyan,
See if this helps.
Regards,
Bruno
On Mon, Aug 30, 2010 at 6:04 AM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
I need a help to create multiple linked dropdown lists. Please go
through
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
Dear Jay,
Problem is solved. See the attachment.
On Wed, Aug 25, 2010 at 2:26 PM, lucky singh lucky60...@gmail.com 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
--
Hi venkat,
VLOOKUP formula will solveyour problem, see the attachment.
On Wed, Aug 25, 2010 at 3:15 PM, Venkatesan c venkat1@gmail.com 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,
*
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
--
, Aug 18, 2010 at 7:53 PM, ashish koul koul.ash...@gmail.com wrote:
check the attachment
Regards
ASHISH
akoul.blogspot.com
On Wed, Aug 18, 2010 at 6:48 PM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
I am attaching a file where I have raw data of Depot, Customer group,
Month
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
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.
72 matches
Mail list logo