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
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: ╚►♥ѕαη∂єєρ♥◄╝
--~--~
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. E
*
*MIS Analyst*
*Greater Kailash-1, New Delhi*
*Email *
*p ankaj123...@gmail.com *
*Skype** pankaj.sharma_pj*
-- Forwarded message --
From: SUDHIR VERMA
Date: Sat, Dec 26, 2015 at 4:20 PM
Subject: $$Excel-Macros$$ plz help
To: excel-macros
Sir,
I am attache
nkaj.sharma_pj*
>
>
>
>
> -- Forwarded message --
> From: SUDHIR VERMA >
> Date: Sat, Dec 26, 2015 at 4:20 PM
> Subject: $$Excel-Macros$$ plz help
> To: excel-macros >
>
>
> Sir,
>
> I am attached excel report for required help dat
w Delhi*
>>
>> *Email *
>> *pankaj123...@gmail.com**Skype** pankaj.sharma_pj*
>>
>>
>>
>>
>> -- Forwarded message --
>> From: SUDHIR VERMA
>> Date: Sat, Dec 26, 2015 at 4:20 PM
>> Subject: $$Excel-Macros$$
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 mm/dd/,Wheneve
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
--
--
Some
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, an
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 f
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. choos
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 wrote:
> Hi Vishal
>
> follow below mention steps
>
>1. Select your column A:A
>2. Go to Data Validation
>3. Click on s
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 the
Please find the data in required format.
Regards
Chethan Kumar BN
On Wed, Dec 14, 2011 at 12:46 PM, Anil Saxena wrote:
> 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)
>
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 Proble
hi excel gurus
plz help in opening the attached file
it does not show full sheet, it had hide all the formulas, i want to break this
formula is measureitem
i dont know how to unlock the structured window, plz tell me in brief
Have A Nice Time & Enjoy Life
Regards:
CMA Ankur Pandey
(Someon
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:
check it if this helps u
On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:
>
>
> 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 wr
Thanks to Lot Abhishek Ji
about help me thanks
On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote:
> 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 y
Dear Mr. Saxena,
Please find Attached file.
Thanks,
Chandrabhan Singh
9911255330
On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:
>
>
> 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
>>
>>
>>
>>
>> Regar
You're welcome Anil.
On Tue, Apr 6, 2010 at 2:09 PM, Anil Saxena wrote:
> Thanks to Lot Abhishek Ji
> about help me thanks
>
>
> On Tue, Apr 6, 2010 at 1:55 PM, Abhishek Jain wrote:
>
>> Dear Anil,
>>
>> Please see the attached file. I've used an array formula. Press
>> Ctrl+Shift+Enter while app
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 wrote:
> 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
>
>
>
>
> Re
Thanks Lot Chandrabhan Singh Ji
On Tue, Apr 6, 2010 at 2:24 PM, Born to Win wrote:
> Dear Mr. Saxena,
>
> Please find Attached file.
>
> Thanks,
> Chandrabhan Singh
> 9911255330
>
>
>
> On Tue, Apr 6, 2010 at 1:20 PM, Anil Saxena wrote:
>
>>
>>
>> Hi Dilip
>>> plz do the needful it is urgent
>>
your welcome.
Thanks,
Chandrabhan Singh
9911255330
On Tue, Apr 6, 2010 at 3:57 PM, Anil Saxena wrote:
> Thanks Lot Chandrabhan Singh Ji
>
>
>
> On Tue, Apr 6, 2010 at 2:24 PM, Born to Win wrote:
>
>> Dear Mr. Saxena,
>>
>> Please find Attached file.
>>
>> Thanks,
>> Chandrabhan Singh
>> 991125
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 wrote:
> your welcome.
>
>
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 wrote:
> 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 colu
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 @ http://www.facebo
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 :
http://twi
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,
Abdu
Hi Anil,
Please find attached excel for solution.
Regards,
Swapnil.
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote:
> Hi Sir,
> plz help me and Show the Formula
>
> --
>
> --
> Some important links for excel us
Hello dear
Please find the attached solution.
Chandra Gupta Maurya
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote:
> Hi Sir,
> plz help me and Show the Formula
>
> --
>
> --
> Some important links for excel user
On Fri, Apr 9, 2010 at 11:41 AM, Anil Saxena wrote:
> 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://twit
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
> Dear Sir / Mam,
>
>
> Do the create the excel pivot table in to MS world without copy past and
> show the example ?
>
> --
>
> --
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
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 wrote:
> Hi All,
> Plz find the attached file and solved this query.
> H
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 this
You could also use a data>filter>filterby 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,
Mune
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 want
quot;. 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
gt; ** **
>
> 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.c
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 at
hameem
> *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
l-macros@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
y 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
> *Subjec
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 or close other applications
On Thu, Jun 27, 2013 at 9:42 AM, Amit Desai (MERU)
mailto:amit.de...@me
e 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: $$Exce
gt;> ** **
>>
>> *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 to sol
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 two
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 tw
PM
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,MAT
52 matches
Mail list logo