Select the column, right click then select “Format Cells”. In that category
select as Date and in Type select as per your required format.
Hope this is helpful.
On Tuesday, November 27, 2018, Neeraj Gmail
wrote:
> Dear Expert,
>
>
>
> I want to change the date format as per given below
>
>
>
>
On Sun, 7/16/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help required in excel
To: excel-macros@googlegroups.com
Date: Sunday, July 16, 2017, 1:32 PM
--
On Sat, 7/15/17, Manoj Garg wrote:
Subject: Re: $$Excel-Macros$$ Help required in excel
To: excel-macros@googlegroups.com, srinu88...@gmail.com
Date: Saturday, July 15, 2017, 7:19 PM
You can
use Exact(text1, text2)
On Sat, Jul 15, 2017 at
You can use Exact(text1, text2)
On Sat, Jul 15, 2017 at 8:01 PM, Srinivas G wrote:
> Hi Friends,
>
> I want to help in Excel
>
> ramu Ramu False
> Raju Raju True
> mohan Mohan False
> Venu VenuTrue
> SAISai False
>
> I first cell and se
On Sun, 1/22/17, julienneschindler via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com
Date: Sunday, January 22, 2017, 6:29 PM
On Sat
On Sat, 1/21/17, sriram ji wrote:
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com
Date: Saturday, January 21, 2017, 12:24 PM
Thank you so much
Saleem Ansari.
File working fine and also i need same format
Thank you so much Saleem Ansari.
File working fine and also i need same format splitup in master file. i
attached the file. Kindly help me..
Thank in advance.
Thanks & Regards,
Sriram G
On Thu, Jan 12, 2017 at 6:35 PM, Saleem Ansari
wrote:
> Dear Friend,
>
> Please check & Confirm
>
> if any
On Thu, 1/12/17, storeythomas725 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com
Date: Thursday, January 12, 2017, 10:55 PM
On Thu
On Thu, 1/12/17, julienneschindler via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com
Date: Thursday, January 12, 2017, 10:45 PM
On
On Thu, 1/12/17, georgemartin812 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com
Date: Thursday, January 12, 2017, 8:43 PM
On Thu
On Thu, 1/12/17, spainy via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com
Date: Thursday, January 12, 2017, 8:00 PM
On Thu, 1/12/17
On Thu, 1/12/17, martinez.david533 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com
Date: Thursday, January 12, 2017, 7:47 PM
On
On Thu, 1/12/17, Saleem Ansari wrote:
Subject: Re: $$Excel-Macros$$ Help Required
To: excel-macros@googlegroups.com
Date: Thursday, January 12, 2017, 3:06 PM
Dear Friend,
Please check &
Confirm
if any query plz revert
Regards,
Sa
First of all, take a look at the Forum "rules".some of them are just simple
good ideas, like: 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 answered.
The f
Dear Friend,
Please check & Confirm
if any query plz revert
Regards,
Saleem Ansari
On Thu, Jan 12, 2017 at 6:35 PM, Saleem Ansari
wrote:
> Dear Friend,
>
> Please check & Confirm
>
> if any query plz revert
>
> Regards,
> Saleem Ansari
>
> On Thu, Jan 12, 2017 at 2:13 PM, sriram ji wrote:
>
Dear Friend,
Please check & Confirm
if any query plz revert
Regards,
Saleem Ansari
On Thu, Jan 12, 2017 at 2:13 PM, sriram ji wrote:
> Hi Excel Guru,
>
> Kindly help me the below attached file,
>
> Thanks in advance.
>
> Thanks & Regards,
> Sriram G
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:
>
> http://tutorialway.com/conditional-cell-format-in-excel/
help ful wbsite
--
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, accu
use this:
={IFERROR(VLOOKUP($A3&C$1,CHOOSE({1,2},$M$13:$M$22&$O$13:$O$22,$N$13:$N$22),2,0),0)}
*PJ *
*MIS Analyst*
*Greater Kailash-1, New Delhi.*
*Instagram* *pj_sharma_*
*Tweeter*
*dude_sharma_pj**Facebook** www.facebook
Dear Abhisek
I want to reconile the data and show the hanging in both the accounts as we
normally do in bank reconciliation.
If iam doing vlookup chances of overlooking same amount exist in both the
accounts as you have seen same cost amount exists
in both vendor & ledg which should be matched sh
>From your data, please give me an example of what exactly you want
On Wed, May 25, 2016 at 7:53 PM, Cute Awesome wrote:
> Dear Abhishek,
>
> But the dates won't be the similar with my ledger and vendor since vendor
> would be giving the amount details line wise for the amount which needs to
>
Dear Abhishek,
But the dates won't be the similar with my ledger and vendor since vendor
would be giving the amount details line wise for the amount which needs to
be reconciled with my ledger account ensuring amount received for all lines
which mentioned. awaiting your help.
I would be having on
Welcome!glad you could join us.
As a GROUP, we offer our assistance free of charge.However, sometimes the
project requires a great deal of time and effort.
SOME of our members do this type of work for a living and may ask for
compensation for large projects.If that were to happen, that is worked
Please see attached.
It gets the result from an UDF so be sure to copy the function as well if
you intend to use it in another file.
HTH
On Tue, Apr 26, 2016 at 4:22 PM, Neeraj Chauhan
wrote:
> Dear sir,
>
>
>
> I want all Indus id in one row with Comma
>
>
>
> *INDUS ID*
>
> *INDUS ID*
>
> I
Here, give this a try.It was a simple matter to have it select the text box
after completing.
The other problem was because basically, there are 16,384 columns in each
row.When you add or delete the row, you're "changing" 16,384 cells.
so, the macro is running 16,384 times!
I added a line in whic
Respected Mr. Paul
your idea of creating text box is really very nice .. But when i started
using this i found two issues
1] When ever i change any cell -- crusor should automatically goes to that
box only & not as normal
as next cell or down ...
2] If i delete any raw or insert any raw then
Thank you very much for explaining in details.
God Bless you & all members of our wonderful groups.
Excel can do so much wonders that we can not have think it before.
On 3 March 2016 at 19:10, Paul Schreiner wrote:
> I can make the changes, but you will still need to rely on others to make
> c
I can make the changes, but you will still need to rely on others to make
changes!
I'll try to explain:
Macros have "scope":That is: Macros (Subroutine or Function) are stored in VBA
"Modules"There are several types of Modules.The most common are "Sheet"
modules, "Standard" modules and "Form" mo
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
>
>
>
multiply it by 1 simply !! Regards,Mandeep
--
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 th
PFA
On Thu, Jan 14, 2016 at 3:56 PM, Neeraj Chauhan
wrote:
> 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/discussex
See if this works
On Sun, Nov 22, 2015 at 4:55 PM, Izhar wrote:
> can we use vlookup or match,index function over here to sort column A like
> column B, if possible can anyone do it for me, I tried on column E:I but
> failed
> Thanks in advance
> NOTE:
> Priority is the formula if not possible t
Noticed that the time mentioned for "seconds" part is differentiated by a
decimal while it should be a colon (like it is done for the hours-minutes
part) so as to enable excel to read it as "time". Once you correct that,
you can simply deduct the down time from up time to get the difference and
set
Assuming that your values are stored in column A from cell 1 to 50, you
could use this formula in cell B1 and drag it down -
=RANK(A1,$A$1:$A$50)
HTH
Abhishek
On Wed, Sep 9, 2015 at 2:22 PM, Nasir Saikh wrote:
> Hi Experts,
>
> I need a formula to assign number value example is given below wh
ces you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: GENIUS
To: MS EXCEL AND VBA MACROS
Cc: schreiner_p...@att.net
Sent: Saturday, August 22, 2015 1:16 AM
Subject: Re: $$Excel-Macros$
THANK YOU VERY MUCH FOR YOUR HELP
On Saturday, 22 August 2015 10:16:25 UTC+5, GENIUS wrote:
>
> The formula you have sent is working but the problem over here is the date
> when i copy 02/06/2015 from another sheet and paste the same in
> TRANSANCTION sheet, then it is over write on the previou
The formula you have sent is working but the problem over here is the date
when i copy 02/06/2015 from another sheet and paste the same in
TRANSANCTION sheet, then it is over write on the previous one. Now I'm
sending 4 days transanction to you just apply such a formula when i copy
transanction
What are the other sheet names for each day?They can't all be called
"Transaction".
Are you looking for a macro solution? or Excel formulas?
the issue here is that for each ROW of data, you have to predict what the
source transaction sheet name will be.
For example, in Cell C4, you need the value
THANK YOU VERY MUCH FOR YOUR HELP
On Monday, 17 August 2015 16:43:38 UTC+5, Paul Schreiner wrote:
>
> In the autofilter panel,
> you are selecting cells that begin with "M".
> In the next box,
> choose cells that do NOT begin with "MN"
> [image: Inline image]
>
> *Paul*
>
In the autofilter panel,you are selecting cells that begin with "M".In the next
box,choose cells that do NOT begin with "MN"
Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you c
pls check
On Wed, May 20, 2015 at 2:58 PM, Neeraj wrote:
> 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.
Dear Sir,
My company has two shifts say Ist shift working =6:00 to 14:00 ans
second shift 14:00 to 22:00
i have large data of employees (rotating shifts) and want to calculate
which employee worked in which shift
Excel is on that format
EmployeeCode Shift
Do let us know if you need any help..
Cheers!!
On Sat, Mar 7, 2015 at 3:42 PM, Mukesh Gupta wrote:
> Thanks
> On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote:
>
>> Hi
>>
>> check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
>>
>> Cheers!!
>>
>> On Fri, Mar 6, 2015 at 8:02 AM, Mukesh
Thanks
On 7 Mar 2015 14:46, "Vaibhav Joshi" wrote:
> Hi
>
> check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
>
> Cheers!!
>
> On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta
> wrote:
>
>> Dear Friedns,
>>
>> Kindly help me in creating a conditional formating calander just like
>>
Hi
check this.. www.excelzoom.com/how-to-create-a-calendar-in-excel/
Cheers!!
On Fri, Mar 6, 2015 at 8:02 AM, Mukesh Gupta wrote:
> Dear Friedns,
>
> Kindly help me in creating a conditional formating calander just like
> goole calander.
>
> My basis needs are as follows:-
>
>
> 1. Start Date
Great..Cheers!
On Sun, Feb 8, 2015 at 1:20 PM, singla.kris...@gmail.com <
singla.kris...@gmail.com> wrote:
> Hi Vabz,
>
> Thank you very much That worked like wonder...
>
> Many thanks
>
> --
> 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) ! J
Hi Vabz,
Thank you very much That worked like wonder...
Many thanks
--
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 t
Hi,
check this file..
Put formula countif in next columncopy & paste down, you can see there is
Separate set of sequential numbering for Dr & Cr.
Once it is ok, copy & paste value for formula column & sort data AtoZ ..
Cheers!!
On Tue, Feb 3, 2015 at 5:25 PM, singla.kris...@gmail.com <
singla.
Send with Excel file where you want to do this.
Pramod
On 3 Feb 2015 17:25, "singla.kris...@gmail.com"
wrote:
> Hi,
>
> Can somebody please help me in a small macro. My sheet have a column with
> some values and I want to sort them alternately.
>
> Current
> Dr.
> Cr.
> Dr.
> Dr.
> Cr.
> Cr.
> C
You can do so using macro..else you need to use dependent columns for data
validation list.
+
*I did not do this for you. God is here working through me for you.*
On Tue, Dec 30, 2014 at 2:48 PM, Rakesh kumar
wrote:
>
> Hi,
> I need help on Dependent Data validation.
> and please try to sol
Dear Sir,
Can we do it by vba.
please help.
Thanks
Ashu Kenith.
On Wed, Dec 17, 2014 at 9:21 PM, Ashish Kumar
wrote:
>
> Welcome Ashu.
>
> --
> 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
Welcome Ashu.
--
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 titles, like Please Help,
Urgent,
Dear Vaibhav/Ashish Sir,
Thanks for your help. I am looking for this only.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 9:10 PM, Ashish Kumar
wrote:
>
> Hi Ashu,
>
> Check this!!
>
>
> Regards
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(
Hi Ashu,
Check this!!
Regards
Ashish
--
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 Sir,
I want only single formula. I have some blank Cells in A and B column in
sheet 2. Query is attached please check again.
--
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.
Hi Ashu,
Use Simple Vlookup function which is suggested by Vaibhav Sir.
and Delete NA# with help of filter.
It's simple.
Regards
Ashish
--
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 Sir,
I have some Blank cells in A column and Some Blank Cells in B Column in
sheet 2.
I want to match the C column data from Sheet 1.
only single formula required. If we don't want to put any formula in A and
B column but some cells are blank in both columns.
It is possible.
Thanks
Ashu K
Dear Sir,
I have huge data, So i want only single formula. or can it done by vba help.
Thanks
Ashu Kenith
On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote:
>
> Dear Sir,
>
> Thanks for your support. I dont want to get data in A and B column, I want
> to get data in C column only. Don't want to pu
Yes, only if class no. is also unique the same way Name.
Check this cell with blue color.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 17, 2014 at 8:35 PM, Ashu k wrote:
>
> Dear Sir,
>
> Thanks for your support. I dont want to get data in A a
Dear Sir,
Thanks for your support. I dont want to get data in A and B column, I want
to get data in C column only. Don't want to put formula in A and B column.
It is possible. to get data from Sheet 1 without put any formula in A and B
column in Sheet 2.
pls help.
Thanks
Ashu Kenith
On Wed, De
Hi
Check this..cell with yellow colour has formula.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Dec 17, 2014 at 8:21 PM, Ashu k wrote:
>
> Dear Seniors,
>
> Please help. how can i get data from sheet 1
>
> Ashu Kenith
>
>
> On Wed, Dec 17, 2014 at
Dear Seniors,
Please help. how can i get data from sheet 1
Ashu Kenith
On Wed, Dec 17, 2014 at 6:30 PM, Ashu k wrote:
>
> Dear Seniors,
>
> I have data in sheet 1
>
> Name Class Roll NO. Exam Date
>
>
> and,
>
> I have data in Sheet 2
>
> Name Class Roll No. Exam Date
>
>
> But some Name
Singh Dhunna
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, November 24, 2014 11:28 AM
> *Subject:* Re: $$Excel-Macros$$ Help Required.
>
> There is no difference between Vlookup in Excel 2003 and Excel 2007 and
> above. Please elaborate what is the actual issue.
>
you can.” - John Wesley
-
>
> From: sriram ji
>To: excel-macros@googlegroups.com
>Sent: Monday, November 24, 2014 11:42 AM
>Subject: Re: $$Excel-Macros$$ Help Required.
>
>
>
>Dear Excel guru&#
24, 2014 11:28 AM
>Subject: Re: $$Excel-Macros$$ Help Required.
>
>
>
>There is no difference between Vlookup in Excel 2003 and Excel 2007 and above.
>Please elaborate what is the actual issue.
>
>
>On Mon, Nov 24, 2014 at 9:55 PM, sriram ji wrote:
>
>Dear Ex
Dear Excel guru's,
I have 4 Data in 2003 excel format. I want to vlookup in 10 data,
its 2007 excel format... Am trying to vlookup in 2003 to 2007 excel format
the below attached error is came. Please solve the error...
[image: Inline image 1]
Thanks & Regards
Sriram G
On Mon, Nov 24, 2
There is no difference between Vlookup in Excel 2003 and Excel 2007 and
above. Please elaborate what is the actual issue.
On Mon, Nov 24, 2014 at 9:55 PM, sriram ji wrote:
> Dear Excel Guru's,
>
> Is there any possible to vlookup in 2003 excel to 2007 excel or above.. If
> possible please provid
Please try these query.
Query1.
SELECT Table1.Name, Table2.NAme
FROM Table1 INNER JOIN Table2 ON cstr(Table1.Name) =
cstr(left(Table2.NAme,len(Table1.Name)));
query2.
UPDATE Table1 INNER JOIN Query1 ON Table1.Name = Query1.Table1.NAme SET
Table1.Name = [Query1].[Table2]![NAme]
WHERE ((Not (Tabl
At A7 sheet Homepage, select Office. GET FILE button to select the file and
get into
2014-08-30 22:10 GMT+07:00 Eugene Bernard :
> Mr Basole,
>
> Thanks for the attachements,
>
> I am getting an error msg as in the attachment, even after adding Ms-ado
> object library.
>
> [image: Inline image
Was precisely the error: problem with the file name. * xls.
To work well, every day change the name, for example: 31/08/2014 and rename
to (T3108.xls).
Then do the test with your file. If you have any problems, please send me
an example of your file (Tddmm.xls).
Regards,
Basole.
2014-08-30 12:
Dear Basole,
Please ignore my earlier mail,
I removed the slash in between dd/mm from the below statement from your
example
fileXLS = "T" & Replace(Format(Date, "dd/mm"), "/", "") & ".xls" like
below,
fileXLS = "T" & Replace(Format(Date, "ddmm"), "/", "") & ".xls" and example
sent by you
star
Mr Basole,
Thanks for the attachements,
I am getting an error msg as in the attachment, even after adding Ms-ado
object library.
[image: Inline image 1]
TIA.
Eugene
On Fri, Aug 29, 2014 at 11:06 PM, Ricardo® wrote:
> Ok, is attached files.
> To test, hold the 2 files in the same folder
>
Ok, is attached files.
To test, hold the 2 files in the same folder
Regards,
Basole.
2014-08-29 11:58 GMT-03:00 Eugene Bernard :
> Basole,
>
> Thanks for your solution.
>
> Can you please send me the working example along with excel file with
> sample data.
>
> I tried your code with my data,
Basole,
Thanks for your solution.
Can you please send me the working example along with excel file with
sample data.
I tried your code with my data, and i am getting an error message.
Regards
Eugene
On Saturday, August 23, 2014 7:04:59 PM UTC+5:30, Basole wrote:
>
> Hi,
>
> See this example
Hi,
See this example extracts the data from your file T2308.xls (T & date: and
change the name according to the current(or system date)), using ADO and
SQL statement.
regards.
Basole
2014-08-23 8:55 GMT-03:00 Eugene Bernard :
> Dear all,
>
> I am daily using the attached sample query file t
Jocky Beta
>To: excel-macros@googlegroups.com
>Sent: Sunday, June 29, 2014 11:41 PM
>Subject: Re: $$Excel-Macros$$ Help required on Macro
>
>
>Hi Team,
>
>Can anybody help me for converting above attached file to comfortable
>for office 2010 as this file is made in
Jun 2014 13:58:15 +0530
> Subject: Re: $$Excel-Macros$$ Help required on Macro
> To: jocky6...@gmail.com
>
> Does this work ?
>
>
> On Thu, Jun 26, 2014 at 1:46 PM, Jocky Beta wrote:
>
>> Hi all,
>>
>> Any hope regarding on the same.
>>
>
>> >
>> > But sheet provided by you is not working It's showing *"Can't exit
>> design
>> > mode because control Combobox5 can not be created" *error.
>> >
>> > could you please help me on this?
>> >
>> > Regards
.
>
> could you please help me on this?
>
> Regards
>
> -- Forwarded message --
>> From: Manoj Garg
>> Date: Wed, 25 Jun 2014 11:52:30 +0530
>> Subject: Re: $$Excel-Macros$$ Help required on Macro
>> To: excel-macros@googlegroups.com, Jo
gt; Date: Wed, 25 Jun 2014 11:52:30 +0530
> Subject: Re: $$Excel-Macros$$ Help required on Macro
> To: excel-macros@googlegroups.com, Jocky Beta
>
> pfa
>
>
> On Wed, Jun 25, 2014 at 11:05 AM, Jocky Beta wrote:
>
> > Hi Team,
> >
> > I got below attached s
Thanks Ravinder
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Wednesday, April 02, 2014 5:11 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Help Required Urgent
PFA
From: excel-macros@googlegroups.com
PFA
From: excel-macros@googlegroups.com [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.
_
Please help
Regards
On 3/29/14, Jocky Beta wrote:
> Hi pramod,
>
> Please find the attached sheet in which i had explain what i required,
> Request you to kindly go through it and help me to solve the problem.
>
> Regards
>
>
> On Sat, Mar 29, 2014 at 10:13 AM, Pramod Singh wrote:
>
>> hey what
Hi pramod,
Please find the attached sheet in which i had explain what i required,
Request you to kindly go through it and help me to solve the problem.
Regards
On Sat, Mar 29, 2014 at 10:13 AM, Pramod Singh wrote:
> hey what u want can u enplane complete...
>
>
> On Sat, Mar 29, 2014 at 8:08
hey what u want can u enplane complete...
On Sat, Mar 29, 2014 at 8:08 AM, Jocky Beta wrote:
> Hi,
> I have already assigned formula but its showing error.
>
> Please help me.
>
> Regards
>
>
> On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote:
>
>> Hi,
>>
>> Please help me on this _
>>
>>
>>
Hi,
I have already assigned formula but its showing error.
Please help me.
Regards
On Fri, Mar 28, 2014 at 1:51 PM, Jocky Beta wrote:
> Hi,
>
> Please help me on this _
>
>
> Regards
>
>
> On Fiday, March 28, 2014, Jocky Beta wrote:
> > Hi All,
> >
> > Pls fin above attached sheet in which Q
Hi,
Please help me on this _
Regards
On Fiday, March 28, 2014, Jocky Beta wrote:
> Hi All,
>
> Pls fin above attached sheet in which Query sheet when i type any word
related to Item code ELEC0001 (Kindly see the master sheet) it will search
the Item Name automatically. But when i put bulb it's
1. change date format in d/mm/
2. change text to column
3.now use date function to combined date again
Divaker
On Thu, Mar 27, 2014 at 4:04 PM, Neeraj Chauhan
wrote:
> Dear experts,
>
>
>
> We have givne below date format how to convert right format of date like
> 13-Jan-2014
>
>
>
> TT Mo
Thanks Ravinder.
On Fri, Jan 24, 2014 at 4:37 PM, Ravinder wrote:
> PFA
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Rakesh kumar
> *Sent:* Friday, January 24, 2014 4:26 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rakesh kumar
Sent: Friday, January 24, 2014 4:26 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help Required
Hi Friends,
Please find the attachment.
Help Please
--
Th
Your query is not clear. Please explain more you need to edit any pdf or
only create stamp like approved, rejected or else as pdf
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajeev
Sent: Wednesday, January 22, 2014 12:03 PM
To: excel-macros@googlegro
Hi,
I don't have password for this file is there any alternative way to
complete same.
On Thu, Oct 17, 2013 at 2:03 PM, Anil Gawli wrote:
> Dear Jocky,
>
> Kindly unlock the password and resend.
>
> Warm Regards,
> Gawli Anil
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
>
Dear Jocky,
Kindly unlock the password and resend.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Thu, Oct 17, 2013 at 1:59 PM, Jocky Beta wrote:
> Hi Team,
>
> Can anybody fix this attached error for me. i am also attachi
E2=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2)
E4=1-((1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2+(1/5)^2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: Saturday, October 12, 2013 2:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-M
This formula have 6 part
*=1-(**(B3/D2)^2**+**(B4/D2)^2**+**(B5/D2)^2**+**(B5/D2)^2**+**(B6/D2)^2**+**(B7/D2)^2**)*
And this Only 5 Part, Purple part was missing
*=1-(**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**)*
On 12-10-2013 3:52, Indrajit $nai wrote:
Hello Experts,
Kindly fi
s@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Friday, October 04, 2013 7:13 AM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help required in formula.
>
> ** **
>
> Hi Ravinder,
>
> ** **
>
> Actually it wa
d
> drag
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Indrajit $nai
> *Sent:* Thursday, October 03, 2013 1:29 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help required in formu
Actullay its fuction u have to use as Excel formulas type =sumup(b2) and
drag
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: Thursday, October 03, 2013 1:29 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help
Unable to run the macro, kindly assist.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of the individual or entity to whom they
are addressed. If you are not the intended recipient you are hereby
notified th
,*
>
> *Ravi Kumar.*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [
> mailto:excel-macros@googlegroups.com ] *On
> Behalf Of *Ravinder
> *Sent:* Wednesday, September 11, 2013 3:56 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* Soum
> *Subjec
cel-macros@googlegroups.com <mailto:excel-macros@googlegroups.com>
Cc: Soum
Subject: RE: $$Excel-Macros$$ Help Required : How i import Data in Excel
from DBF File & Get Max voucher Number
Use below formula or attached file.may be u r looking for this..
=IF(A2="",&
1 - 100 of 282 matches
Mail list logo
