Dear Sudhir/Pankaj,
First thing you should not is this showing Error because of regional
Setting, because both of you're using different Date format,As I check this
file it shows me the same error
because My System format is "dd/mm/" While the answer in sheet is in
format
*
>>
>> *MIS Analyst*
>>
>> *Greater Kailash-1, New Delhi*
>>
>> *Email *
>> *pankaj123...@gmail.com**Skype** pankaj.sharma_pj*
>>
>>
>>
>>
>> -- Forwarded message
7B%7D,'cvml','sharmapankaj...@yahoo.com');>ankaj123...@gmail.com
> <javascript:_e(%7B%7D,'cvml','ankaj123...@gmail.com');>**Skype**
> pankaj.sharma_pj*
>
>
>
>
> -- Forwarded message ------
> From: SUDHIR VERMA <newinex...@gmail.com
> <javascr
Sir,
I am attached excel report for required help date difference.
Thanking You
Regards
Sudhir
--
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
*
*MIS Analyst*
*Greater Kailash-1, New Delhi*
*Email *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype** pankaj.sharma_pj*
-- Forwarded message --
From: SUDHIR VERMA <newinex...@gmail.com>
Date: Sat, Dec
Workbook”. This file type will compress the data
in lowest possible size.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *thameem
*Sent:* 27 June 2013 11:15
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Plz help me
[mailto:
excel-macros@googlegroups.com] *On Behalf Of *thameem
*Sent:* 27 June 2013 11:15
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Plz help me to solve this prob
** **
getting error as excel cannot complete this task with available
resources. choose less data
Dear all,
Am getting below message, when ever I delete row or column, and my system
is getting hanged, am unable to do any editing. plz help me out.
the operation you are about to perform affects a large number of cells and
may take a significant amount of time to complete. are you sure you
will not see that message..
Do similar steps for columnar data deletion.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of thameem
Sent: 27 June 2013 10:22
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Plz help me to solve this prob
Dear all,
Am
similar steps for columnar data deletion.
** **
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *thameem
*Sent:* 27 June 2013 10:22
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Plz help me to solve this prob
Sent: 27 June 2013 10:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob
Thank you, i will follow your step, but is any other solution for this? plz
tell me, y this prob occurs, so i can take precautions in any other files.
On Thu, Jun 27, 2013
:* 27 June 2013 10:49
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Plz help me to solve this prob
** **
Thank you, i will follow your step, but is any other solution for this?
plz tell me, y this prob occurs, so i can take precautions in any other
files
@googlegroups.com
Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob
Is any possibility to delete unused cells in row and column, so i can reduce
load, present am using 3000 rows and 40 columns rest all rows and coloumns are
empty, thank you for ur support.
On Thu, Jun 27, 2013 at 9:33 AM, Amit
columns can be removed by shift + Control + Right Arrow Delete.
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *thameem
*Sent:* 27 June 2013 11:07
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Plz help me to solve
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Plz help me to solve this prob
getting error as excel cannot complete this task with available resources.
choose less data or close other applications
On Thu, Jun 27, 2013 at 9:42 AM, Amit Desai (MERU)
amit.de
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Anil Saxena
Sent: Friday, August 03, 2012 6:28 AM
To: Dilip Pandey
Cc: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Plz Help Me
Hi Dilip Sir,
Plz find the attached file,
I want the Summary Sheet do
You could also use a datafilterfilterby 14 copy/paste values
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Mohammed Muneer
Sent: Thursday, February 16, 2012 7:12 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ plz, help on this to solve..
Regards,
Muneer,
CC
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ plz, help me to drive out this sort of
problem!
Try this.
B8
=IF(INDEX($H$1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8)=chik,INDEX($H
$1:$H$1794,MATCH(chik,$H$1:$H$1794,0)+ROW()+8),)
C8
=IF(INDEX($H$1:$H$1794,MATCH(chik,$H$1:$H$1794,0
Make a pivot - Right click - Value Field settings - Show values as -
Select % of grand total.
Thanks,
Rohan.
--
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
Plz let me know that how can possible to % in pivot table. base of Caller.
Plz show the snap short also.
--
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,
Please find the data in required format.
Regards
Chethan Kumar BN
On Wed, Dec 14, 2011 at 12:46 PM, Anil Saxena anilsaxena170...@gmail.comwrote:
Plz let me know that how can possible to % in pivot table. base of Caller.
Plz show the snap short also.
--
FORUM RULES (934+ members already
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anil Saxena
Sent: Thursday, August 04, 2011 10:16 AM
To: excel-macros@googlegroups.com
Cc: Dilip Pandey
Subject: $$Excel-Macros$$ Plz help me how can posible
Hi All,
Plz find the attached file and solved
Hi,
I just replied to this post, but wonder where that gone.
Anil, please wait for some time and search that again. Let me know if
you do not find the same, I'll send another one.
Regards,
DILIPandey
On 8/4/11, Anil Saxena anilsaxena170...@gmail.com wrote:
Hi All,
Plz find the attached file
hi Guys
plz help me to automate diet chart
Regards,
Lucky
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
hi Guys
plz help me to automate diet chart
Regards,
Lucky
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
Dear Sir / Mam,
Do the create the excel pivot table in to MS world without copy past and
show the example ?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Dear Anil,
MS word did not have pivot table function , but you can use them by
insert excel object and use pivot table same as Excel.
2010/6/23 Anil Saxena anilsaxena170...@gmail.com
Dear Sir / Mam,
Do the create the excel pivot table in to MS world without copy past and
show the
Dear Mr. Parab,
Thanks for the help.
Actully you have solved a big problem of mine.
Thanks again
Regards
Vishal Gupta
On Sun, Jun 6, 2010 at 10:58 PM, Mahesh parab mahes...@gmail.com wrote:
Hi Vishal
follow below mention steps
1. Select your column A:A
2. Go to Data Validation
Hello All,
I need a command or code in excell.
I want names written in a coloumn sholud not be repeated, error msg
shouldbe generated when someone writes a duplicate entry.
Plz help me
regards
Vishal Gupta
--
--
Hi Vishal
follow below mention steps
1. Select your column A:A
2. Go to Data Validation
3. Click on settings
4. Choose custom from drop down list
5. Enter the formula as =IF(COUNTIF(A:A,A1)1,FALSE,TRUE)
6. Click Error Alert tab , check or select show error alert box
7.
Hi Sir,
plz help me and Show the Formula
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @
Hello dear
Please find the attached solution.
Chandra Gupta Maurya
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena anilsaxena170...@gmail.comwrote:
Hi Sir,
plz help me and Show the Formula
--
--
Some important
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena anilsaxena170...@gmail.comwrote:
Hi Sir,
plz help me and Show the Formula
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
Hello Dear,
I have check it and find great.It's working nice
great work.
On Wed, Apr 7, 2010 at 4:56 AM, Harmeet Singh harmeet.hew...@gmail.com wrote:
Good one guyz nice to see such creative formulas, here is my share of
knowledge.
Kindly check out the index match function without
Hi Dilip
plz do the needful it is urgent
I want the same ans match with ID and Questions ?
Plz Sir show the Formula also
Regards
Anil Saxena
--
--
Some important links for excel users:
1. Follow us on TWITTER
Hi Dilip
plz do the needful it is urgent
I want the same ans match with ID and Questions ?
Plz Sir show the Formula also
Regards
Anil Saxena
--
--
Some important links for excel users:
1. Follow us
check it if this helps u
On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote:
Hi Dilip
plz do the needful it is urgent
I want the same ans match with ID and Questions ?
Plz Sir show the Formula also
Regards
Anil Saxena
--
Dear Anil,
Please see the attached file. I've used an array formula. Press
Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined
the range names.
Let me know if you need any further help on this.
Dilip's friend... :)
Abhishek
On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena
Thanks to Lot Abhishek Ji
about help me thanks
On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain abhishek@gmail.comwrote:
Dear Anil,
Please see the attached file. I've used an array formula. Press
Ctrl+Shift+Enter while applying it. Also to ease the formula, I've defined
the range names.
Dear Mr. Saxena,
Please find Attached file.
Thanks,
Chandrabhan Singh
9911255330
On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote:
Hi Dilip
plz do the needful it is urgent
I want the same ans match with ID and Questions ?
Plz Sir show the Formula also
You're welcome Anil.
On Tue, Apr 6, 2010 at 2:09 PM, Anil Saxena anilsaxena170...@gmail.comwrote:
Thanks to Lot Abhishek Ji
about help me thanks
On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain abhishek@gmail.comwrote:
Dear Anil,
Please see the attached file. I've used an array
Dear Anil Saxena
Find attached solution to your problem. Hope this suffies
Regards
Sivakumar ES
On Tue, Apr 6, 2010 at 12:40 PM, Anil Saxena anilsaxena170...@gmail.comwrote:
Hi Dilip
plz do the needful it is urgent
I want the same ans match with ID and Questions ?
Plz Sir show the
Thanks Lot Chandrabhan Singh Ji
On Tue, Apr 6, 2010 at 2:24 PM, Born to Win cs4...@gmail.com wrote:
Dear Mr. Saxena,
Please find Attached file.
Thanks,
Chandrabhan Singh
9911255330
On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena anilsaxena170...@gmail.comwrote:
Hi Dilip
plz do the
your welcome.
Thanks,
Chandrabhan Singh
9911255330
On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena anilsaxena170...@gmail.comwrote:
Thanks Lot Chandrabhan Singh Ji
On Tue, Apr 6, 2010 at 2:24 PM, Born to Win cs4...@gmail.com wrote:
Dear Mr. Saxena,
Please find Attached file.
Thanks,
Good one guyz nice to see such creative formulas, here is my share of
knowledge.
Kindly check out the index match function without adding additional column.
Thanks Regards,
Harmeet Singh
Sent via BlackBerry Wireless
On Tue, Apr 6, 2010 at 4:59 PM, Born to Win cs4...@gmail.com wrote:
can any body help me in excel if i insert such data in cell as :
My
Input 120 121 122 123 124 125 126 127 128 129 130
i want output in this way by using round formula
output 120 120 120 125 125 125 125 125 130 130 130
plz send solution of this problem
Thanx in advance
Regards,
Plz help here i attached a problem file with required ans. plz help me
--
Warm Regard
Prashant Bhawar
( CA Final )
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1.
Hello fnds I m sandeep. i m new member of excel maros group. i m from
delhi.
can some budy help me to learn maros functions. i will realley
appricate, if u send me any matarial which is helpfull to learn macro or
function's plzz send me ..
--
Regards: ╚►♥ѕαη∂єєρ♥◄╝
Hi members,
Hope you all are doing well.
Please help me with a solution which, I am sure, will benefit others too.
Problem:It is very difficult to remember tones of figures
Solution: It is easier to remember nearest lower/higher figures
Formula/function required: If last
49 matches
Mail list logo