PFA
On Wed, Mar 7, 2018 at 5:08 PM, vikas khen wrote:
> Hi All,
>
> Request all of you to kindly help me on the attached sheet.
>
>
> I need conditional formatting for based on following two conditions
>
> 1) If the Actual date is less than or equal to Projected date it should
> highlighted in G
Hi Amar are you there?
On Fri, Feb 23, 2018 at 4:57 PM, amar takale wrote:
> ??
>
> On Thu, Feb 22, 2018 at 10:07 AM, amar takale
> wrote:
>
>> Thank for reply sir
>>
>> I explain my issue in excel sheet
>>
>> On Thu, Feb 22, 2018 at 6:10 AM, who wrote:
>>
>>> Hello,
>>>
>>> I do not see anoth
You can use this.
Application.WorksheetFunction.RoundUp(VarArray(LngR, 1), 2)
On Sun, Feb 25, 2018 at 5:51 AM, who wrote:
> I typed your numbers into a sheet and it automatically formatted as you
> have displayed. I checked the format, right clicked into cell and picked
> "Format Cells", then "
Hey Champs Please see my data validation query.
and please let me know when you solved it.
--
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 co
Hi guys i have a password protected workbook but i lost my workbook
password can anybody tell me how to unlock mu password protected workbook.
also i'm sharing my password protected workbook.
Regards
Sourav Devrani
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Need Help.
On Mon, Mar 27, 2017 at 3:40 PM, sourav devrani wrote:
> Hey Folks,
>
> Please assist me how to create organization chart in excel using VBA.
> Need help.
>
> Also i'm attaching one Snapshot with this mail.
>
> Regards
> Sourav Devrani
>
> --
Hey Folks,
Please assist me how to create organization chart in excel using VBA.
Need help.
Also i'm attaching one Snapshot with this mail.
Regards
Sourav Devrani
--
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 pa
Hi Guys,
I'm creating Org Graphs using Excel VBA but I don't know how to do it.
Need your help.
Regards
Sourav Devrani
--
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.fa
Thanks Devendra dada :)
On Mon, Jan 30, 2017 at 6:18 PM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Hi Saurav,
>
> Please check this tutorial.
> https://www.youtube.com/watch?v=_PqnDYMO3lw
>
> On Mon, Jan 30, 2017 at 12:12 PM, sourav devrani <
> sour
Hi Guys,
I want to create " Bell Curve Chart " in excel but i don't know how to
create this chart and logic behind this.
Can you please suggest me how to create.
Regards
Sourav Devrani
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:
Hey Guys,
How to hide close button in excel userform using VBA code.
please see the attached snapshot and give me the solution.
Thanks & Regards
Sourav Devrani
--
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 pag
you can also use this file
On Thu, Dec 29, 2016 at 11:48 AM, Izhar wrote:
> When i run this macro it does not create 27 sheets instead only 7 or 8 and
> also shows a message box, can anyone please make the the changes where
> required
> Thanks in advance
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP
Sorry sir didn't get your Query
On Sat, Dec 3, 2016 at 11:41 AM, jitendra kumar
wrote:
> Hi Team,
>
> Please help in this attached file format.
>
>
>
>
> *Regards,*
>
> *Jitendra Yadav + 91 9650449202*
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,
Hi Nikkipram
Please share some dummy data.
On Tue, Nov 22, 2016 at 12:34 AM, Nikkipram wrote:
> Hi all,
> I have a mis containing the payment details of the invoices
>
> Column a multiple lines with pro duct details
> Column b with invoice value(same value against each products..bcoz invoice
>
Yo man.hehe
On Sat, Nov 26, 2016 at 11:27 AM, amar takale wrote:
> Dear Sourav Sir
>
> Done!
>
> You are Rock Sir,Excellent Work.
>
> Many Many Thanks Again.
>
> Regards
> Amar
>
> On Sat, Nov 26, 2016 at 11:08 AM, sourav devrani <
> souravdevrani1...@
ate & save .xml file on desktop.I use excel 2003.Then
> where I create & how it possible.
>
> Regards
> Amar
>
> On Fri, Nov 25, 2016 at 4:03 PM, sourav devrani <
> souravdevrani1...@gmail.com> wrote:
>
>> keep one Xml file [image: Inline image 2] like
5, 2016 at 11:15 AM, sourav devrani <
> souravdevrani1...@gmail.com> wrote:
>
>> Hi Amar any Progress
>>
>> On Fri, Nov 25, 2016 at 10:13 AM, amar takale
>> wrote:
>>
>>> ok
>>>
>>>
>>> On Fri, Nov 25, 2016 at 10:00 AM
Hi Amar any Progress
On Fri, Nov 25, 2016 at 10:13 AM, amar takale wrote:
> ok
>
>
> On Fri, Nov 25, 2016 at 10:00 AM, sourav devrani <
> souravdevrani1...@gmail.com> wrote:
>
>> i'll create one macro for you.
>>
>> On Thu, Nov 24, 2016 at 11:41 PM
i'll create one macro for you.
On Thu, Nov 24, 2016 at 11:41 PM, Kush Shama
wrote:
> Bhai I have that excel sheet .will mail you as I get time. I create it
> whenever i lose it.
> On 24 Nov 2016 18:18, "amar takale" wrote:
>
>> how to it?
>>
>> On
Do one thing bro Scrap the data from Web.
On Thu, Nov 24, 2016 at 6:09 PM, amar takale wrote:
> See screen shot.If possible you also try why it show like that.
>
> On Thu, Nov 24, 2016 at 12:47 PM, sourav devrani <
> souravdevrani1...@gmail.com> wrote:
>
>> i think w
; Amar
>
> On Wed, Nov 23, 2016 at 11:37 AM, sourav devrani <
> souravdevrani1...@gmail.com> wrote:
>
>> in this case if you want to update data on every click you will have to
>> use web scrapping and fetch data from web into excel and every Click of
>> Button your d
in this case if you want to update data on every click you will have to use
web scrapping and fetch data from web into excel and every Click of Button
your data will be refreshed accordingly your web data.
On Wed, Nov 23, 2016 at 11:26 AM, Kush Shama
wrote:
> Use import wizard. Select web query
Please have a look
On Thu, Oct 27, 2016 at 4:41 AM, Kal xcel wrote:
> 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
> =TIM
On Wed, Oct 26, 2016 at 9:57 AM, Izhar wrote:
> in the attach macro i need the name in column A of CONSOLIDATION sheet,
> when i run this macro it takes the figures and cosolidate it but the names
> are not shown in front of the figures in the CONSOLIDATION sheet, can
> anyone please change this
can you give one sample
On Thu, Oct 13, 2016 at 5:28 AM, Brajesh Shrivastava
wrote:
> Hello Experts,
>
> I need a VBA coding for some data in my excel sheet column A i.e. hospital
> names for which i have to search address and contact detail and to get
> update in my excel column B and C respec
Use this Man
Sub SplitTest()
Dim VarArrayAs Variant
Dim LngRAs Long
Dim LngCAs Long
Dim LngIndexAs Long
Dim VaresultAs Variant
LngIndex = 1
VarArray = Intersect(Sheet2.Range("A1").CurrentRegion,
Sheet2.Range("A1").CurrentRegion.Offset(1))
use this
=SUM(VALUE(U18:U71))
On Thu, Sep 29, 2016 at 10:07 PM, N. Madhan wrote:
>
> HI
>
> can you see the sheet1 see the convert to number then =sum()
>
>
>
>
> On Thursday, September 1, 2016 at 11:21:24 PM UTC+5:30, khagesh khera
> wrote:
>>
>> Hi,
>>
>> Required enclosed RAW data in new
Hi guys please help
Regards
Sourav Devrani
--
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 thread titles. Poor thread
Thanks for reply sir but if i'm not using any helping column then.
On Fri, Aug 12, 2016 at 2:02 AM, Murali Nagarajan
wrote:
> Dear Sourav,
>
> I hope you are doing great.
>
> Regards
> N.Murali
>
> On Thu, Aug 11, 2016 at 6:41 PM, sourav devrani <
> souravdev
Hey guys,
I need your help.
Please see the attached file.
Regards
Sourav Devrani
--
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
8, 2016 at 7:03:25 PM UTC+5:30, sourav devrani wrote:
>>
>> A
>>
>> B
>>
>> C
>>
>> D
>>
>> How to small these values using Small Formula.
>>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>
(IF($A$1:$A$20<>"",ROW($A$1:$A$20)-1,""),ROW(A1)),0)
> Press Ctrl+Shift+Enter
>
> See attachment for more clarity...
>
>
>
>
> On Tue, Aug 9, 2016 at 5:48 PM, sourav devrani <
> souravdevrani1...@gmail.com> wrote:
>
>> Hi Abhishek
Hi Abhishek,
[image: Inline image 1]
On Mon, Aug 8, 2016 at 12:50 PM, Abhishek Jain
wrote:
> =lower(a1)
>
> A1 is your first value, then you can drag.
>
> On Monday, August 8, 2016, sourav devrani
> wrote:
>
>> A
>>
>> B
>>
>> C
>>
Please see the attached file.
Regards
Sourav Devrani
On Tue, Jul 19, 2016 at 11:43 PM, सचिन शर्मा
wrote:
> Please check
>
> Cash paid to L986529 - RAMESH KUMAR K
> EMP ID
> L986529
>
>
>- =MID(B2,FIND("L",B2),7)
>
>
>-
> *" 7
Hi Sachin you can also use this one.
Regards
Sourav Devrani
On Mon, Aug 8, 2016 at 12:24 AM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:
> Hi Sachin,
>
> You can also try this one- =SUMPRODUCT(EXACT($F$4,$B$5:$B$11) *
> ($C$5:$C$11))
>
> Please change the ref.
A
B
C
D
How to small these values using Small Formula.
--
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 thread titles. P
please use this file.
i have change some little formula here you can use this file.
Regards
Sourav Devrani
On Wed, Aug 3, 2016 at 7:10 AM, sourav devrani
wrote:
> please see the attached file.
>
> On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman
> wrote:
>
>> Is there any o
please see the attached file.
On Wed, Aug 3, 2016 at 3:29 AM, Jayanta Barman
wrote:
> Is there any one who can solve this, please ?
>
> On Aug 2, 2016 23:38, "Jayanta Barman" wrote:
>
>> Hello Excel experts,
>>
>> I have a small problem in excel. Please help me in resolving this.
>>
>> Problem:
Here you go.
On Fri, Jul 22, 2016 at 12:47 AM, Mustapha LMIDMANI <
lmidmani.musta...@gmail.com> wrote:
> Hello,
>
> Please check this ? is what do you want?
>
> 2016-07-22 8:42 GMT+01:00 Neeraj Pal :
>
>> Hi All,
>>
>> Please solve my if condition
>>
>> --
>> Are you =EXP(E:RT) or
[?][?][?][?][?][?][?][?]
[?][?][?][?][?][?][?][?]
Merry Christmas
On Wed, Dec 24, 2014 at 7:41 PM, Vaibhav Joshi wrote:
> Merry X'Mas to All..Happy holidayz
>
> [image: Inline image 1]
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Wed, D
40 matches
Mail list logo
