Dear Paul,
hope you have got change to go through the attached files.
---Emam
On Monday, February 6, 2017 at 10:01:43 AM UTC+5:30, Emamuddin Shah wrote:
>
> Hi Paul,
>
> Hope you have received my email.
>
> Regards
> Emam
>
> On Wednesday, February 1, 2017 at 12:5
Hi Paul,
Hope you have received my email.
Regards
Emam
On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah
wrote:
>
> Dear Paul,
>
> i will share my both excel sheets, so that you can check where iam wrong
> and correct it, since the document is confidenti
of cells(1,3)
> You're less likely to confuse the row/column.
>
> Of course, this doesn't apply when you're referring to the array index.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you ca
on.
>
> *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 can,To all the people
> you can,As long as ever you can.”
ITS NOT UPDATED ALL 50 STRINGS ROW DETAILS.
IT IS UPDATING ONLY FIRST MATCHED STRING ROW.
On Tuesday, October 18, 2016 at 6:13:56 PM UTC+5:30, Emamuddin Shah wrote:
>
> Hello
>
> Iam trying to Loop so that it matched a string and then fills cells in
> that row.
> say
ster Tracker.xlsx").Close savechanges:=True
Application.ScreenUpdating = True
End Sub
On Tuesday, October 18, 2016 at 6:13:56 PM UTC+5:30, Emamuddin Shah wrote:
>
> Hello
>
> Iam trying to Loop so that it matched a string and then fills cells in
> that row.
> say i have 50 strings
Hello
Iam trying to Loop so that it matched a string and then fills cells in that
row.
say i have 50 strings to be matched and then update date on that row, data
i have stored in ARRAY
here is my part of code where I am struck
++=
cm = 1
For i = 2 To lri
If Cells(i, 7) =
ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>
> On Thursday, August 4, 2016 5:45 AM, Emamuddin Shah <emt...@gmail.com
> > wrote:
>
>
&g
t;gb_70").Click
> End With
> End Sub
>
> On Thu, Aug 25, 2016 at 7:28 AM, Emamuddin Shah <emt...@gmail.com
> > wrote:
>
>> Thanks Gaurav, but I don't want to navigate I want it to click that
>> button.
>> On Aug 25, 2016 6:40 PM, "Gaurav De
viceLogin?hl=en=
> true=https://www.google.co.in/%3Fgfe_rd%3Dcr%
> 26ei%3Dvuy-V726B9GL8Qf9qYW4CQ%26gws_rd%3Dssl"
>End With
> End Sub
>
> On Thu, Aug 25, 2016 at 6:48 AM, Emamuddin Shah <emt...@gmail.com> wrote:
>
>> Please suggest solutions... I just started vb
Please suggest solutions... I just started vba crawling
On Aug 25, 2016 6:17 PM, "Gaurav Devrani" <gauravdev1...@gmail.com> wrote:
> Please disregard my email.
>
> On Thu, Aug 25, 2016 at 6:05 AM, Emamuddin Shah <emt...@gmail.com> wrote:
>
>>
>&
Dear Friends,
iam trying to click an button on url, please help my error
CODE-
Sub click1()
Dim ie As InternetExplorerMedium
Dim url As String
Set ie = New InternetExplorerMedium
'### BUILD THE FULL URL
url = "www.google.com"
Hello All,
iam an intermediate user of VBA i love to automate,
iam struck in on of my code when iam using to fetch data from my excel
sheet based on todays date and same thing copied after last rows.
it is working but in last all copied cells goes empty..
here is my code please suggest.
HI
All genius,
In one sheet I have put purchases and in second sheet there is sales
against purchase.
In both sheets *RG* is unique id.
In need sales data against Purchases.
How to execute this function.?
Please guide me in this
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
if i tick then wanna Yes and no tick then No
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Mon, Apr 13, 2015 at 12:07 PM, Dhaval Shah todhavals...@gmail.com
wrote:
pls go through the attechment
i put a checkbox in my file but i cant
Thanks Dear :)
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Mon, Apr 13, 2015 at 1:49 PM, TAWHID tawhid.ha...@gmail.com wrote:
Hi Dhaval Shah,
See the attached file. I Have put few of them . You can copy paste and
rename as you
PFA
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@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 Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
ANY OTHER WAY TO USE OPTION OF PIVOT TABLE ??
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Mon, Mar 2, 2015 at 3:52 PM, Dhaval Shah todhavals...@gmail.com wrote:
THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I
THANKS DEAR FOR U R EFFORTS BUT ITS NOT USE FULL TO ME BECAUSE WHILE I
UPDATE ITS PASTE WRONGLY
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Mon, Mar 2, 2015 at 12:24 AM, michael vinoth michaelvino...@gmail.com
wrote:
Hi Dhaval Shah
,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@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 Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise
Dear Expert
I have forget the passowrd of my old excel file .is there anyway to recover
the password.
?
Please help it is urgent
--
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 vaibhav :)
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Tue, Jul 15, 2014 at 7:43 PM, Vaibhav Joshi v...@vabs.in wrote:
check this too...
http://www.marketcalls.in/spreadsheet/how-to-extract-data-from-nseinda-com-using
fyi
Warm Regards,
Dhaval Shah
M) 98240 35253
*E-mail : todhavals...@gmail.com todhavals...@gmail.com*
On Tue, Jun 17, 2014 at 12:51 PM, Rakesh kumar rakesh.apt...@gmail.com
wrote:
Hi Guys,
I want to use formula on pivot table data.
Kindly help me.
--
Thanks £ Regards
Rakesh Kumar
i have found a macro from the internet to add missing date in the data.
its not working in excel 2010. it is giving type mismatch error.
would appreciate if i get guided.
Option Explicit
Sub AddMissingDates()
'JBeaucaire (12/13/2009)
Dim LR As Long, i As Long
Application.ScreenUpdating =
Dear Paul,
thanks for your response.
the line which is giving the error is If Cells(i, A) Cells(i + 1, A)
- 1 Then
the date format is 01/01/2001
i tried to run the macro as you suggested.
it is giving me the same error.
i think the date format is a problem then.
appreciate your help
shah
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ wanna halp in conditional icon set
PFA
On Fri, Jan 17, 2014 at 10:04 PM, Dhaval Shah ( Ahd )
todhavals...@gmail.com wrote:
Hello friends
I want help in conditional icon set … pls refer attached sheet
formatting merging.
See the file where size is half now. Thanks.
On Tue, Jan 14, 2014 at 7:44 AM, Dhaval Shah todhavals...@gmail.com wrote:
Friends
i have a file with v limited data in file automatic my file size rise to
7.3 mb from 689 kb
any suggestions ??
--
Are you =EXP(E:RT
Thanks Waseem :)
On Mon, Jan 6, 2014 at 8:33 PM, Waseem Saifi waseemsa...@gmail.com wrote:
Perhaps you are looking for this.
see attachment.
regards,
Waseem Saifi
On 1/6/14, Dhaval Shah ( Ahd ) todhavals...@gmail.com wrote:
Guys I need chart help
Pls refer attached sheet
,
Cartik
On Tue, Dec 24, 2013 at 10:57 AM, Dhaval Shah todhavals...@gmail.com
wrote:
hello,
i want a formula help for my here with attached file
pls refer my sheet
thanks
Dhaval Shah
--
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
Want to choss Day only from date pls refer attachment
Thanks
Dhaval Shah
--
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
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dhaval Shah ( Ahd )
Sent: Thursday, November 28, 2013 5:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need formula help
Want to choss Day only from date pls refer attachment
Thanks
Dhaval Shah
On Wed, Oct 16, 2013 at 8:29 PM, Secret Shot secrets...@gmail.com wrote:
Dear Exterts,
I am stuck in my project and need your expert advice that ho can i prevent
duplicate data entry in any colom, but i have to use list validation too at
the same time
So for example my source range is
I have 3 sheets in my excel book.
First sheet is Menu sheet.
I want that, Menu sheet is to be open every time when I open excel file.
--
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 @
Hi Priti,
it is not working
On Thu, Aug 1, 2013 at 3:05 PM, priti verma pritiverma1...@gmail.comwrote:
you can use workbook open event to active worksheet
Private Sub Workbook_Open()
Worksheets(Menu).Activate
End Sub
On Thu, Aug 1, 2013 at 2:23 AM, hemal shah hemali...@gmail.com
Thanks.
On Thursday, 1 August 2013 16:04:01 UTC+5:30, suman kumar wrote:
Hi
You should use below code in ThisWorkbook in OPEN event. Please find the
attached file now its working as well.
*Suman Kumar*
On Thu, Aug 1, 2013 at 3:53 PM, hemal shah hema
how to create custom list
On Friday, 2 August 2013 11:03:32 UTC+5:30, vijay wrote:
Respected Hemal,
Create a custom List and sort moths according to that custom list.
Regards,
Vijaykumar
On Fri, Aug 2, 2013 at 10:33 AM, hemal shah hema...@gmail.comjavascript:
wrote:
in this file
Thanks Ravinder :)
On Mon, Jul 22, 2013 at 4:05 PM, ravinder negi ravi_colw...@yahoo.comwrote:
PFA..
--
*From:* Dhaval Shah todhavals...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Monday, July 22, 2013 3:46 PM
*Subject:* $$Excel-Macros$$ Need
Thanks..
Nikhil
On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar kumar.ashish...@gmail.comwrote:
Dear Frndz,
Use full link to learn Excel. please find attached link!!!
http://www.excel-pratique.com/en/index.php
Thanks
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
1. Need to Speed up Excel Tasks at Job?
2. Hard time remembering Excel Shortcuts?
3. Spending extra hours learning it?
Now, Learn Excel MS Shortcuts while you work at -
http://www.excelgoodies.com/exceltools/excelshortcuttutor/
Happy Excelling :)
- Team Excelgoodies
--
Are
Hi
all expert
see my attached file.
I want to make excel sheet for time wages calculation.
..i want stored a time,when a check box is clicked in front respective date.
as it is clicked,it should be locked.
i used now function but it is updated continous basis...
plz help
--
Are you
Lalit Sir
didt work can u send me the sample file
Thanks
Dhaval Shah
079 - 40055253
On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey
mohan.pande...@gmail.com wrote:
Hi Dhaval,
Copy below formula at cell address C11 and confirm it with CSE
*=MAX(($B$2:$B$68=$S$10)*($A$2:$A$68 = FUTSTK
workbook and
its working.
On Wednesday, 3 April 2013 12:39:39 UTC+5:30, Dhaval Shah wrote:
Lalit Sir
didt work can u send me the sample file
Thanks
Dhaval Shah
079 - 40055253
On Wed, Apr 3, 2013 at 12:25 PM, Lalit Mohan Pandey mohan.p...@gmail.com
wrote:
Hi Dhaval,
Copy below formula
Dear Thanks for u r prompt reply but out put is not as per my requirement
pls check the reference sheet
On Tue, Apr 2, 2013 at 10:49 AM, xlstime xlst...@gmail.com wrote:
Hi Dhaval,
dhaval shah
(1).xlsxhttps://docs.google.com/file/d/0B4LBSzxr1QTiVjZoYkRneFFUY1k/edit?usp=drive_web
PFA
Hello all experts
any solution for my query
On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah todhavals...@gmail.com wrote:
Dear Experts
I want to make out multipul selection for my project pls refer my sheet
Thanks
Dhaval Shah
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
cmp is current market price ( CLOSE PRICE )
On Tue, Apr 2, 2013 at 10:18 AM, xlstime xlst...@gmail.com wrote:
what is CMP ?...
you can use sumifs or sumproduct
.
Enjoy
Team XLS
On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah todhavals...@gmail.comwrote:
Hello
Dear Friends
me downlaod daily file from my back office pls refer NEt.xls
i m not able to do sum at the end of the amount
--
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 @
.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this e-mail unless
you really need to.*
On Mon, Mar 18, 2013 at 5:41 PM, Dhaval Shah todhavals...@gmail.comwrote:
Dear Friends
me downlaod daily file from
can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
*-
--
*From:* Dhaval Shah todhavals...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Mon, March 18, 2013 8:12:24
dear friends
i want to merge two text cell in one
pls refer the sheet
thanks
dhaval
--
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
pls chk
On Fri, Feb 15, 2013 at 3:03 PM, vatspoojav...@gmail.com wrote:
Hi All,
I seek your guidance in the attached sheet, wherein, currently I am
updating manually the column: I Correct Cost Centre Contracts.I am
updating this from the data available in corresponding columns: D,E,F G.
Thanks Dear
On Tue, Feb 12, 2013 at 10:04 PM, Excel Beginner
excelbegin...@gmail.com wrote:
Hi Dhaval,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah todhavals...@gmail.comwrote:
Dear Friends
pls refer my sheet
find attached Sheet for Your REf. is i sOK?
Warm Regards,
Gawli Anil
On Thu, Jan 31, 2013 at 3:12 AM, Alpesh Shah alpes...@gmail.com wrote:
Dear Excel Masters,
I have raw data that is in the following form:
1 name abc
2 address 234 john lane
3 company inc, co
4 website http
Dear Excel Masters,
I have raw data that is in the following form:
1 name abc
2 address 234 john lane
3 company inc, co
4 website http://website.com
5 description company abc is abc
What I would like to do is have this information look like this, where the
data is taken from rows and
Dear friends
i am lookking for solution 4 Lock work sheet if i am lock work sheet then i
m not able to use filter
actually i want to hide my formula's only is it any way to hide formula ???
Thanks
Dhaval Shah
--
Join official Facebook page of this forum @
https
Kenil
pls click the below mention link to download data of any eq series stocks
www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012
*TCS*EQN.csv
www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCE
**EQN.csv
just u have to change the
Thanks Dear
For LOW ( Min ) ??
On Mon, Dec 24, 2012 at 5:17 PM, The Viper viper@gmail.com wrote:
=INDEX($C$2:$C$3000,MATCH(F2MAX(IF($A$2:$A$3000=F2,$B$2:$B$3000,0)),$A$2:$A$3000$B$2:$B$3000,0))
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
Suppos i m change the data in Sintex manual then formula works
On Mon, Dec 24, 2012 at 10:41 AM, Dhaval Shah todhavals...@gmail.comwrote:
Hello Prince ,
Wish u merry Christmas
i m facing some problem to find out High Low value Date in u r Formula
pls see the attech file there is two
Me Also Facing the same problem i m view below mention link in any browser
but while i m try to import table in excel is not working
http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=N
is it any other way to import Table in Excel Sheet
On Wed, Dec 19,
Need Data Range upto 99000 in this sheet data Range upto only 2000
me try to change Data Range but its dosent work
Pls do need full
Thanks
Dhaval Shah
98240 35253
On Wed, Dec 12, 2012 at 10:43 PM, Prince prince141...@gmail.com wrote:
Hi Dhaval ,
Pls find Attached.
Regards
Prince
Already change data range but not working
On Wed, Dec 12, 2012 at 6:24 PM, Satendra kumar
satendrakuma...@gmail.comwrote:
Hi,
change data range than apply i hope this is working...
thankx
satendra
On Wed, Dec 12, 2012 at 6:19 PM, Dhaval Shah todhavals...@gmail.comwrote:
FRIENDS
, Dhaval Shah todhav...@gmail.comjavascript:
wrote:
Friends,
pls go through the attached excel sheet
in main sheet there is raw data of differenet date for different product
now suppose product x trade for 5 days and 5 days close value is also
different need to know the which date
I M TRYIN TO IMPORT BELOW MENTION LINK
http://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm?cat=N
ACTUALLY RECENTLY NSE INDIA DONE SOME MODIFICATION WITH WEB SITE AFTER
UPDATATION I M ENALBE TO IMPORT DATA FROM ABOVE LINK IS IT ANY OTHER WAY TO
IMPORT TO EXCEL
--
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, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be
, Dec 10, 2012 at 10:28 AM, Anoop K Sharma
aks.sharm...@gmail.comwrote:
Hi Dhaval,
PFA...
Regards,
Anoop
Sr. Developer
On Mon, Dec 10, 2012 at 9:12 AM, Dhaval Shah todhavals...@gmail.comwrote:
--
Join official Facebook page of this forum @
https://www.facebook.com
, Dhaval Shah wrote:
Friends,
pls go through the attached excel sheet
in main sheet there is raw data of differenet date for different product
now suppose product x trade for 5 days and 5 days close value is also
different need to know the which date product x close on highest and lowest
Thanks a Lot Brother
On Wed, Dec 5, 2012 at 11:14 PM, Excel Beginner excelbegin...@gmail.com
wrote:
Hi Dhaval,
Please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Dec 5, 2012 at 12:26 PM, Dhaval Shah todhavals...@gmail.comwrote:
Friends
Hi
Thanks for sending excellent file,
(1). Prince Formula Bible (Updated Version)
(2). Updated Lets Learn Together ( Macro Bible )
Can you send all files in excel 2003..
Nikhil
On Sat, Oct 13, 2012 at 10:02 PM, Prince Sethi prince.seth...@gmail.comwrote:
--
Regards
[image:
Dear Members,
Congratulations Rajan
Nikhil
On Sat, Oct 13, 2012 at 8:55 PM, Lalit Mohan Pandey
mohan.pande...@gmail.com wrote:
Many Congratulations RajanOnce Again...bhai
On Tuesday, 2 October 2012 21:04:33 UTC+5:30, Ayush Jain wrote:
Dear members,
Rajan Verma has been selected
Dear Experts,
I haven't yet received solution for my query below.
Please help.
Regards,
-- Forwarded message --
From: hemant shah hemanthin...@gmail.com
Date: Sun, Aug 19, 2012 at 12:56 PM
Subject: Need help on a formula
To: excel-macros excel-macros@googlegroups.com
Dear
Dear Experts,
I am stuck up which my work in an excel. I need a help on a formula in the
attached sheet.
I have given a complete details explanation in the attached sheet.
Need your help to come out of this situation.
For any question or details please revert back.
Thanks in advance.
Dear Excel Experts,
I am working with a string as follows:
| ABC:2013| ABCD| EFGH|2IJK | 3243| 9s9s| afjkdf|
There are a total of 8 pipes | .
My issue is that I am trying to Split this based on the pipes, and output
the words in between into cells.
I have been trying to solve this for a long
Dear Excel Experts,
I have attached a spreadsheet with dummy data. The first tab shows the
dummy information and the second tab shows what I would like it to look
like.
As I have over 100 of rows of data to do this for, I am looking to develop
some vba code to help accelerate the work.
Each row
Hi Noorain ,
Thanks for sending excellent Chart File..
Nikhil
On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Please find attached Clock Chart.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
--
Congratulation Rajan
Nikhil Shah
On Mon, Jun 4, 2012 at 11:02 AM, Maries talk2mar...@gmail.com wrote:
*Congrats Brother.*
On Sun, Jun 3, 2012 at 9:36 PM, Anil Gawli gawlianil8...@gmail.comwrote:
congrats Mr Rajan.
Gawli Anil
On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI
I have attached a sample file to show what i mean. I have managed to copy
the grouped objects from a single slide.
However the complication arrises when I have to copy and collate the
objects when they are on different slides.
i.e. if i want to copy object 1 and 2 from slide 1 and 9 and 10
Hi Haseeb,
Nice Formula..
Thanks
Nikhil
On Mon, Apr 16, 2012 at 11:36 AM, Haseeb A haseeb.avarak...@gmail.comwrote:
Nikhil, One way:
Assume date is in A2. So
In B2 for the Curr Quarter.
=TEXT(LOOKUP(MONTH(A2),{1,4,7,10})*29,)
Then in C2
=TEXT((1B2)+99,)
Copy across to E2.
Hi Haseeb,
Sorry , answer is wrong.
i.e. Dt.01/05/2010 ( DD/MM/ ) ,then Next Quarter should be July , here
it's display april..
Nikhil
On Sun, Apr 15, 2012 at 2:57 PM, Haseeb A haseeb.avarak...@gmail.comwrote:
Hello Nikhil,
This will give the current quarter.
Hi sam,
super Idea
Nikhil Shah
On Sun, Apr 15, 2012 at 7:01 PM, Sam Mathai Chacko samde...@gmail.comwrote:
A shorter one
=CHOOSE(CEILING(MONTH(A1)/3,1),April,July,October,January)
Regards,
Sam
On Sat, Apr 14, 2012 at 6:19 PM, Nikhil Shah nikhil201...@gmail.comwrote:
Hi Maries
Hi Hasseb,
Now answer is right ,
i.e. Date 01/05/2010 ( DD/MM/ ) Format ,
Currently it's showing Curr.Qtr = April ; Next Qtr = July ..it is ok
After July , Now I want Next Qtr = October ; Next Qtr = January
Nikhil
On Sun, Apr 15, 2012 at 11:07 PM, Haseeb A
) Quarter will be - October and
the print will be January, April,July and october
I am using Excel 2003. I do want any Macro , I want Only Formula
Awaiting Reply
Nikhil Shah
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
Hi Maries,
Thanks for solving my problem.
Nikhil
On Sat, Apr 14, 2012 at 6:15 PM, dguillett1 dguille...@gmail.com wrote:
You need to provide a file.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Nikhil Shah nikhil201...@gmail.com
*Sent:* Saturday
Dear Maries,
Thanks for sending excel links , it will very useful to me..
Nikhil Shah
On Sat, Apr 7, 2012 at 3:09 AM, Maries talk2mar...@gmail.com wrote:
Dear Friends,
I have accumulate the my collection for Excel. Please update, If you
anything more.
I hope these links are very useful
HI
following link will solve your issue
http://ubitmenu.en.softonic.com/
Take care self and other
Regards
Hemal
--
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
Hi Maries,
Thanks..Excellent Tools..
Regards
Nikhil Shah
On Tue, Feb 7, 2012 at 4:08 PM, Maries talk2mar...@gmail.com wrote:
*Find the attached Excel File
*
On Tue, Feb 7, 2012 at 11:43 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
PFA
On Tue, Feb 7, 2012 at 12:42 PM, Amit
https://lh6.googleusercontent.com/-GIfFnIL63cw/TyujJI-qg1I/AaI/4g3EdOBK34Q/s1600/Photo-0433.jpg
Thanks for your kind support and solutions.
flower to you all,, made by me
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
=VLOOKUP(MAX('*EN8 BRIGHT DIA 28*
'!$D$2:$D$11),Indirect(A2,!$D$1:$G$11),4,0)
I dont want to EN8 Bright DIA 28.
I just want to use cell reference instead .
Thanks for your reply
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
#N/A ERROR...
--
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 answered.
2) Don't post
KINDLY USE MY ATTACHED FILE AND HELP ME OUT THIS...
THANKS
--
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
# ref error...
--
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 answered.
2) Don't post a
thanks it is working..
--
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 answered.
2)
hi
all masters
I have work on fifo in very simple way in excel.
now in summary sheet i require , while i type GRN, i should get latest
balance .
I have attached file for your reference.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor
Hi
Sam
Thanks for the solution
but I want something different.
Please see my attached file, which give you more idea regarding my query
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Hi sam,
Can you post in Excel 2003 ? ..I am using excel 2003
Regards
Nikhil Shah
On Sat, Jan 21, 2012 at 10:56 PM, Sam Mathai Chacko samde...@gmail.comwrote:
=IFERROR(ROUND(F5*(1+((F6/100)/C9))^(C9*IF(E7=Months,(F7/12),IF(E7=Years,F7,F7/365))),2),)
Regards,
Sam Mathai Chacko
On Sat
Dear Noorain
Excellent Tips..
Thanks
Nikhil Shah
On Tue, Jan 17, 2012 at 6:45 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Updated Sheet
On Tue, Jan 17, 2012 at 6:06 PM, PrIyAnKa p.dhamsa...@gmail.com wrote:
Dear Noorain
It converts with Rupees and i want only for words
E.g. I
Hi Kris,
you right..it is very complex with formula..I have to use Pivot
table.itwill very easy..
Thanks
Nikhil Shah
On Fri, Dec 30, 2011 at 1:18 PM, Kris krishnak...@gmail.com wrote:
Hi,
With the help of a helper column, a Pivot table would do the trick.
PFA.
Kris
--
FORUM RULES
-macros@googlegroups.com] *On Behalf Of *Maries
*Sent:* Dec/Thu/2011 12:14
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
** **
Find the attachment
On Wed, Dec 28, 2011 at 9:23 PM, Nikhil Shah nikhil201...@gmail.com
wrote:
Dear Friend
] *On Behalf Of *Nikhil Shah
*Sent:* Dec/Fri/2011 12:37
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Help
** **
Dear Rajan
** **
Opps..Sorry..Answer is wrong..
** **
Again I am sending fresh excel sheet..
** **
Pl help
** **
Nikhil
Dear Friend,
I want to find out Consecutive Negative Return (%) in Times Number Years :
Answer is : 2 Times 2 Years
Now i want EXCEL Formula..Pl help me ..
*Year*
*Return*
*Year*
*Return*
1980
28.86%
1996
4.24%
1981
49.56%
1997
13.31%
1982
3.56%
1998
-17.17%
1983
7.20%
Dear Friend,
I want to find out Consecutive Negative Return (%) in Times Number Years :
Answer is : 2 Times 2 Years
Now i want EXCEL Formula..I am using EXCEL 2003 ..No VBA Code...Pl help me
..
*Year*
*Return*
*Year*
*Return*
1980
28.86%
1996
4.24%
1981
49.56%
1997
13.31%
:
What if three Consecutive year have negative % then what output you want..?
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Nikhil Shah
*Sent:* Dec/Wed/2011 10:14
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Help
1 - 100 of 221 matches
Mail list logo