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 @
https://www.facebook.com
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
IN-1035632,IN-1035940,IN-1035968,IN-1075463
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 t
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 @
ht
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
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 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 close
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 titl
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 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 then
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 RULES
,
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) or
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 t
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 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'
Sub
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 @
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
wrote:
Dear experts,
Kindly find the attached sheet there are alarm sheet and I want to know dg
running dat
/
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
wrote:
Dear expert,
I want to convert from PDF to Excel we have some more attachment
Kindly provide any softerware
[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 em
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 page
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 Modifi
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
T
5:44
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:O
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) !
thanks sir,
its working thanks again
On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI wrote:
> 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 > wrote
On Sat, Dec 29, 2012 at 9:49 PM, >>Excel Beginner<< wrote:
> Hi Neeraj,
>
> Pls check attachment.
>
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> On Sat, Dec 29, 2012 at 3:46 PM, neeraj chauhan <
> neerajchauha
cros@googlegroups.com [mailto:
> excel-macros@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,
>
> ** **
>
> se
han 24 Hours ?*
>
> * *
>
> * *
>
> * *
>
> *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-mac
DEAR Experts,
i am waiting for the revert
-- Forwarded message --
From: neeraj chauhan
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 to make the ageing some
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 Plea
Thanks sir
On Wed, Dec 12, 2012 at 1:49 PM, Sayed Abdul Azeem (QFD) wrote:
> Dear neeraj chauhan
>
> ** **
>
> ** **
>
> ** **
>
> I hope this will help you.
>
> ** **
>
> ** **
>
> ** **
>
> ** **
>
>
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,
Urgen
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
FORUM
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 Ple
congratulation Rajan sir.
On Tue, Nov 6, 2012 at 5:36 PM, Govind Mori wrote:
> Congrats Rajan
>
> On Mon, Nov 5, 2012 at 10:57 PM, Ayush Jain wrote:
>
>>
>> Dear members,
>>
>> Rajan Verma has been selected as 'Most Helpful Member' for the month of
>> Oct'12. He has posted 66 posts in last mo
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, Formula
thanks kuldeep
On Wed, Oct 31, 2012 at 12:00 PM, Kuldeep Singh wrote:
>
> 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 wrote:
>
>> Dear Experts,**
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 Help,
: 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 wrote:
Dear experts,.
Kindly find the attached sheet
Thanks jeet!!
On Thu, Oct 4, 2012 at 3:27 PM, jeet singh wrote:
> Dear Friend,
>
> Plz find the attached file.
>
>
>
> On Thu, Oct 4, 2012 at 2:40 PM, Neeraj wrote:
>
>> Dear Experts
>>
>> ** **
>>
>> Kindly see the
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 Pleas
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 [
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 :
=IF
oblem
Dear Neeraj,
See attached sheet, Hope it will help to you.
On Mon, Aug 27, 2012 at 3:23 PM, Neeraj 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@googlegroups.com
Su
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 be
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 atten
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, an
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 :
http://twitter.
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 Cell
52 matches
Mail list logo