Dear Expert,
I want to change the date format as per given below
Date
Date Want in this format
9/26/2018
Nov-18
--
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,
As per Given detail how can I convert each Site ID in Row separate row
VehicleNo
SitesId
I Want this
UP23T1457
IN-1035632,IN-1035940,IN-1035968,IN-1075463,IN-1075466,IN-1081661,IN-1112678
,IN-1116387
IN-1000446
UP23T1457
Hi All,
Please solve my if condition
--
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
Dear Experts,
Kindly find the attached sheet I want reduce or addition amount against
particular Indus id and date wise.
Kindly give me solution
--
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 sir,
I want all Indus id in one row with Comma
INDUS ID
INDUS ID
IN-1000333
IN-1000333,IN-1034694,IN-1036098, IN-1075473, IN-1080707
IN-1034694
IN-1036098
IN-1075473
IN-1080707
IN-1107890
IN-1109310
IN-1237655
IN-1263842
IN-1276207
Dear Experts.
I want change Date Format
--
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
Dear sir,
Thanks sir !!
Kindly share the formula.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 4:50 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: Help Required
PFA !! Ticket
Thanks sir!!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Saleem Ansari
Sent: Thursday, January 14, 2016 4:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help Required
PFA
On Thu, Jan 14, 2016 at 3:56 PM, Neeraj Chauhan
with 1
On Thursday, January 14, 2016 at 5:54:19 PM UTC+5:30, neeraj chauhan wrote:
Dear sir,
Thanks sir !!
Kindly share the formula.
From: excel-...@googlegroups.com
[mailto:excel-...@googlegroups.com ] On Behalf Of Mandeep Baluja
Sent: Thursday, January 14, 2016 4:50 PM
To: MS EXCEL
Dear Experts,
I want total duration time
DATETIME_UP
DATETIME_DOWN
Total Duration Required
9/1/2015 04:06.5
9/1/2015 05:04.1
HRS:MIN:SS
--
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
Dear experts I want to change the date format
Date
I want this format
31/7/2015
31-Jul-15
--
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
Thanks Anand
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Anand Tiwari
Sent: Tuesday, August 04, 2015 4:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ RE: Help required
Hi Neeraj
Please use this,
Alt+D+E
,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/VBAEXCELSQL?ref=hl
https://www.linkedin.com/profile/view?id=312532939
On Wednesday, May 20, 2015 at 2:59:09 PM UTC+5:30, neeraj chauhan wrote:
Dear Experts,
Kindly find the sheet and do the needful formula
--
Are you =EXP(E:RT
Dear Experts,
Kindly find the sheet and do the needful 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
Thanks Ganesh!!
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ganesh N
Sent: Tuesday, February 24, 2015 12:51 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ FW: Help required
Dear neeraj,
PFA,
Regards,
Ganesh N
Dear experts,
I want to some of times as given below format
2/1/2015
2/21/2015
sum in Hours
Like
11:39:49
9:42:15
9 hrs 30 Minute
--
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,
I want to SUM of time as given below format
2/1/2015
2/21/2015
sum in Hours
Like
11:39:49
9:42:15
9 hrs 30 Minute
From: Neeraj [mailto:neerajchauhan...@gmail.com]
Sent: Tuesday, February 24, 2015 10:11 AM
To: 'excel-macros@googlegroups.com'
Subject: Help
What you want exactly?
E.G. for IN-132 on 1 May DG was run for 3 times so do you want 3 against
1st May ?
Cheers!!
On Thu, May 8, 2014 at 11:35 AM, Neeraj Chauhan neerajchauhan...@gmail.com
wrote:
Dear experts,
Kindly find the attached sheet there are alarm sheet
/
http://www.pdftoexcel.org/
http://www.pdfconverter.com/pdf-to-excel-online-free/
https://www.pdftoexcelonline.com/
On Fri, Apr 4, 2014 at 2:27 PM, Neeraj Chauhan neerajchauhan...@gmail.com
wrote:
Dear expert,
I want to convert from PDF to Excel we have some more attachment
Dear experts,
Kindly find the attached sheet.
---
This email is free from viruses and malware because avast! Antivirus protection
is active.
http://www.avast.com
--
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
[mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj Chauhan
Sent: Wednesday, April 02, 2014 4:43 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required Urgent
Dear experts,
Kindly find the attached sheet.
_
http://www.avast.com/
This email
Description: Description: image001
Neeraj Chauhan
+91-9756706350
---
This email is free from viruses and malware because avast! Antivirus protection
is active.
http://www.avast.com
--
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
From: Neeraj Chauhan [mailto:neerajchauhan...@gmail.com]
Sent: Thursday, March 27, 2014 4:04 PM
To: 'excel-macros@googlegroups.com'
Subject: help required urgently
Dear experts,
We have givne below date format how to convert right format of date like
13-Jan-2014
TT Modified
: Neeraj Chauhan [mailto:neerajchauhan...@gmail.com]
Sent: Thursday, March 27, 2014 4:04 PM
To: 'excel-macros@googlegroups.com'
Subject: help required urgently
Dear experts,
We have givne below date format how to convert right format of date like
13-Jan-2014
TT Modified Date Time
13
Dear experts,
How to subtract time in hours and minute
10:30 AM
- 10:30 PM
=
Thanks Regards
Neeraj Chauhan
+91-9756706350
neerajchauhan...@gmail.com
--
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
thanks sir,
its working thanks again
On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Neeraj,
You can use..
=EDATE(A2,6)
or
=DATE(YEAR(A2),MONTH(A2)+6,DAY(A2))
On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan neerajchauhan...@gmail.com
wrote
On Sat, Dec 29, 2012 at 9:49 PM, Excel Beginner excelbegin...@gmail.com
wrote:
Hi Neeraj,
Pls check attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Sat, Dec 29, 2012 at 3:46 PM, neeraj chauhan
neerajchauhan...@gmail.com wrote:
DEAR Experts,
i am waiting
DEAR Experts,
i am waiting for the revert
-- Forwarded message --
From: neeraj chauhan neerajchauhan...@gmail.com
Date: Sat, Dec 29, 2012 at 12:56 PM
Subject: Hepl Required
To: excel-macros@googlegroups.com
Dear Experts,
** **
Kindly find the attached sheet, and I want
?*
* *
* *
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *neeraj chauhan
*Sent:* 29 December 2012 3:46
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Fwd: Hepl Required
@googlegroups.com] *On Behalf Of *neeraj chauhan
*Sent:* 29 December 2012 5:00
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Fwd: Hepl Required
** **
Dear Sir,
** **
send the solution i am waiting
On Sat, Dec 29, 2012 at 4:27 PM, Rajan_Verma rajanverma1
Dear Experts,
** **
Kindly find the attached sheet, and I want to make the ageing some
categories wise by if formula
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Thanks sir
On Wed, Dec 12, 2012 at 1:49 PM, Sayed Abdul Azeem (QFD) sabdulaz...@ccc.ae
wrote:
Dear neeraj chauhan
** **
** **
** **
I hope this will help you.
** **
** **
** **
** **
** **
** **
Regards
** **
*Syed Azeem
Dear Experts,
kindly find the attached sheet. i want to make the conditional format, but
how to make. revert me
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Dear Experts,
i want randomly time and date like
10:43 AM 10:50 AM 10:05 AM 11:10 AM 1:07 PM
20-Nov-12 19-Nov-12 2-Nov-12 11-Nov-12 6-Nov-12 24-Nov-12 18-Nov-12
27-Nov-12 4-Nov-12 1-Nov-12
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Dear Experts,
kindly see the atached snaps, which are not showing.
kindly convert
--
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 thread titles, like
congratulation Rajan sir.
On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori mori.gov...@gmail.com wrote:
Congrats Rajan
On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
Oct'12. He
Dear Experts,
kindly find the attached sheet.
--
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 thread titles, like Please Help,
Urgent, Need Help,
Dear Experts,
Kindly find the attached sheet and resolve the problem..
--
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 thread titles, like Please
thanks kuldeep
On Wed, Oct 31, 2012 at 12:00 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Dear Neeraj,
Try this one and drage to down.
=DATE(D3,C3,B3)
Regards,
Kuldeep Singh
On Wed, Oct 31, 2012 at 11:55 AM, Neeraj neerajchauhan...@gmail.comwrote:
Dear Experts
: oct'12 disconnection data.xlsx
Hi Neeraj,
Right Click in worksheet click a ungroup sheet. see below snapshot:
Inline image 1
Inline image 2
Regards,
Kuldeep Singh
On Mon, Oct 15, 2012 at 5:26 PM, Neeraj neerajchauhan...@gmail.com wrote:
Dear experts,.
Kindly find
Dear Experts
Kindly see the attached sheet and urgently req.
--
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 thread titles, like
Thanks jeet!!
On Thu, Oct 4, 2012 at 3:27 PM, jeet singh jeetexcelt...@gmail.com wrote:
Dear Friend,
Plz find the attached file.
On Thu, Oct 4, 2012 at 2:40 PM, Neeraj neerajchauhan...@gmail.com wrote:
Dear Experts
** **
Kindly see the attached sheet
Try this
10453
=COUNTIF($A$1:A1,A1)
10453
=COUNTIF($A$1:A2,A2)
10453
=COUNTIF($A$1:A3,A3)
25623
=COUNTIF($A$1:A4,A4)
5882
=COUNTIF($A$1:A5,A5)
5856
=COUNTIF($A$1:A6,A6)
2556
=COUNTIF($A$1:A7,A7)
2556
=COUNTIF($A$1:A8,A8)
From: excel-macros@googlegroups.com
Dear Neeraj,
See attached sheet, Hope it will help to you.
On Mon, Aug 27, 2012 at 3:23 PM, Neeraj neerajchauhan...@gmail.com wrote:
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Neeraj
Sent: Saturday, August 25, 2012 11:41 AM
To: excel-macros
Thanks noorain.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOORAIN ANSARI
Sent: Monday, August 27, 2012 5:07 PM
To: excel-macros@googlegroups.com
Subject: Re: FW: $$Excel-Macros$$ resolve the problem
Dear Neeraj,
Try below formula
Dear Experts,
Kindly see the attached sheet.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not
Dear Experts
Kindly find the attached sheet. I want to name only
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick
Dear Experts,
Kindly find the attached sheet.
I want to only last date qty and stock in three sites.
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem,
I also have the same problem. Whenever I reply to any post, I don't
get option to upload a fine in post.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Sundarvelan,
Uploaded a file in http://groups.google.com/group/excel-macros/files
with Team+List_Home.xls name.
This will add new name automatically when you add name in your data.
Does any one help me? I am not getting option to upload file in post?
How From where I can upload in post directly?
Hi Nikhil,
Its done however i am not getting the option to upload a file into
discussion. I have uploaded the file in
http://groups.google.com/group/excel-macros/files with Nikhil+-+Address
+Book.xls
Have a look
Neeraj Lamba
Use Concatenate with
Char(10) ( refers to the alt+enter in cell)
or
=Designation CHAR(10) Name CHAR(10) So on
or
= A2 CHAR(10) B2 CHAR(10) C1 so on
or
= A2 A1 B2 A1 C1 so on (where A1 refers to = Char(10)
whatever applicable.
Set Word Wrap = True from Format Cells. Otherwise you
52 matches
Mail list logo
