Dear all
Can you please help me to find out Boys girls Rank (Regarding Marks) If
they failed then can not count their rank.Can I got this formula
Thank you very much for the support you all have been providing.
Amar
On Wed, Jul 18, 2012 at 6:56 PM, dguillett1 dguille...@gmail.com wrote:
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date: Thu, Jul 19, 2012 at 1:47 PM
Subject: Rank Formula
To: noorain.ans...@gmail.com
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
--
--
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 question in the
On Thu, Jul 19, 2012 at 5:35 PM, dguillett1 dguille...@gmail.com wrote:
Your file did NOT show any pass/fail or grades so how can we help?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* amar takale amartak...@gmail.com
*Sent:* Thursday, July 19
...@gmail.com
*From:* amar takale amartak...@gmail.com
*Sent:* Thursday, July 19, 2012 5:54 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Company Name in front of Show its sector
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread
Sir
But if student fail Then who is second highest will calculate first Rank
automatically.
Thanks
On Thu, Jul 19, 2012 at 6:28 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Am
Dear Amar,
see attached sheet, Hope it help to you.
On Thu, Jul 19, 2012 at 1:48 PM, amar takale
dguille...@gmail.com
*From:* amar takale amartak...@gmail.com
*Sent:* Thursday, July 19, 2012 7:59 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Company Name in front of Show its sector
Code is not work.I will Sent file You will work with below code.I use
Hi all
How to update stock prices from website in excel.In my excel 50 stock I
want to update prices that stock when I open excel open nseindia website
then update prices.I think in excel it is from Data-Import External
Data-New web query.
Daily basis I open include 50 stock excel from
Dear all Excel experts
I think create master sheet then in index I will show name with power point
effect means diffrent type of effect come (left,Right,Up,Down) anyway.I I
click any name (which click) then that name will come with power point
effect (Dashing effect) also amazing idea if
result
Regards
CA Kantilal K Badale
Chartered Accountant
E Hall, First Floor,
B. J. Market,
Jalgaon (Maharashtra)
9822250393
On Mon, Aug 6, 2012 at 10:33 AM, amar takale amartak...@gmail.com wrote:
I will try this but output is not give properly exact numbers.I will send
again file
All Experts
Can anybody give me index sheet example where index sheet is fantastic
presentation view In spreadsheets Example like Company name, stock
price,worksheet name, Other information.
If any look that index sheet they will say O this is Fantastic Presentation
Thanks everyone
Amar
--
Hi All,
I want to Portable Excel 2007.I had already portable Excel 2007 but one
time it is delete by me.when I have XSLM file then cant open it its
formula.In my PC I used excel 2003 but when I required excel 2007 I also
open it to see file But now it is so hard to look XSLM file .So Pls Send me
Dear sir,
I have One Chart File with Data,I want to if I changed Date from... to.
(In particular two cell start End date) Then automatically changed chart
Range Update Chart that within Date range.
Pls send me Example file Then I will use that in my excel
Thank Sir
Amar
--
Join official
...@gmail.com
*From:* amar takale amartak...@gmail.com
*Sent:* Monday, August 13, 2012 1:58 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Chart Update Within Date Data Range
I will Attached file Pls solved me problem
On Fri, Aug 10, 2012 at 3:35 PM, NOORAIN ANSARI
Dear dguillett dguille...@gmail.com Sir,
How to do it which stock price show?
And also VBA code create passwords So I cant see code.
Pls Explain it It is very useful for me to update comparative valuation.
Thanks
Amar
On Sat, Aug 4, 2012 at 6:23 PM, dguillett1 dguille...@gmail.com wrote:
Don
This is Great Noorain Sir
Thanks Noorain for your effort.
Also, thanks to all the people in the group for help.
On Mon, Aug 6, 2012 at 5:56 PM, Venkat CV venkat1@gmail.com wrote:
Congrats Noorain.
--
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Fri, Aug 3, 2012 at 11:10 PM,
...@gmail.com
*From:* amar takale amartak...@gmail.com
*Sent:* Tuesday, August 14, 2012 2:23 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ pls help me solve my query.
Dear dguillett dguille...@gmail.com Sir,
How to do it which stock price show?
And also VBA code create
Hi Amresh,
Can you give example file.I also not understand what is different between.
Thanks for help
On Thu, Aug 16, 2012 at 12:52 PM, Amresh Maurya amreshkushw...@gmail.comwrote:
Hi ,
it works like sumif and sumifs..
we used it for find average value with criteria
[image: Inline image
...@gmail.comwrote:
Dear Amar,
In case of 2003 Version
You can also use..
=IF(ISERROR(VLOOKUP(F5,$B$4:$D$9,3,0)),,VLOOKUP(F5,$B$4:$D$9,3,0))
Or
=IF(ISNA(VLOOKUP(F5,$B$4:$D$9,3,0)),,VLOOKUP(F5,$B$4:$D$9,3,0))
On Thu, Aug 16, 2012 at 3:39 PM, amar takale amartak...@gmail.comwrote:
--
Join
Hi Pravin,
Formula is not work I will try
On Thu, Aug 16, 2012 at 6:50 PM, Pravin Gunjal isk1...@gmail.com wrote:
Dear Amar
You may use the same formula
=IFERROR(INDEX(INDIRECT($D$2),C10),)
*With regards,
**Pravin Gunjal**
*
On Thu, Aug 16, 2012 at 5:18 PM, amar takale amartak
Hi Vijayendra,
I am using Excel 2003.So i ask you what is _xlfn.IFERROR(_xlfn. I never use
in excel.If I delete this ctrl+Z then output fig not show again it show
#name?.How to use all if ifs funtion without _xlfn.IFERROR(_xlfn.
Pls explain me Guide also.
Thanks very much
Amar
On Thu, Aug 16,
NOORAIN Sir,
Thanks very much Sir
On Fri, Aug 17, 2012 at 12:01 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear Amar,
Please try it.
*=IF(ISERR(INDEX(INDIRECT($D$2),C4)),,INDEX(INDIRECT($D$2),C4))*
see attached sheet.
On Thu, Aug 16, 2012 at 5:18 PM, amar takale amartak
Hi Indrajit,
I know it is Conditional formatting but if I search name then highlight
that cell but if there are 1000 name I search name then I scroll bar up
down which cell highlight. I want to jump that cell directly with
highlight.Is it possible?
Thanks
Amar
On Fri, Aug 17, 2012 at 5:02 PM,
Hi experts,
I know it is Conditional formatting but if I search name then highlight
that cell but if there are 1000 name I search name then I scroll bar up
down which cell highlight. I want to jump that cell directly with
highlight.Is it possible?
Thanks
Amar
--
Join official facebook page of
:
Please see the attachment
regards
prince
On Thursday, August 16, 2012 3:39:08 PM UTC+5:30, amar takale wrote:
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate
.
Regards,
Vijayendra
2012/8/16 Amresh Maurya amreshkushw...@gmail.com
check below link. i hope it will help you.
http://www.xlninja.com/2012/08/15/average-averageif-and-averageifs-functions-in-excel/
Reagrds
Amresh
On Thu, Aug 16, 2012 at 1:03 PM, amar takale amartak...@gmail.comwrote
in search the data.
Regards
Amresh
On Tue, Aug 21, 2012 at 2:22 PM, amar takale amartak...@gmail.com wrote:
Hi experts,
I know it is Conditional formatting but if I search name then highlight
that cell but if there are 1000 name I search name then I scroll bar up
down which cell
Hi Vijayendra
It is not excel 2003 version formula
On Tue, Aug 21, 2012 at 4:06 PM, Vijayendra Rao vijayendrar...@gmail.comwrote:
2012/8/21 amar takale amartak...@gmail.com
Hi Vijayendra Rao
Can you send same sheet (If Ifs) Bocs I used Excel 2003 so it is
difficult to understand. So Pls
Hi all Experts,
How to all worksheets protect to unprotect at one time,Is there any VBA
code to unprotect sheet at one time.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate
AM, amar takale amartak...@gmail.comwrote:
Hi all Experts,
How to all worksheets protect to unprotect at one time,Is there any VBA
code to unprotect sheet at one time.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already
--
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 Problem, Code Problem, and Need Advice will
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
*From:* amar takale amartak...@gmail.com
*Sent:* Wednesday, August 22, 2012 1:37 AM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Search Highlight name in list (1000
name list)
Hi all Experts,
Pls
Hi All Experts
Pls find solution Milk data sheet for formula.I think it is use sum product
formula.
Pls help me
Warm Regards
Amar
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date: Wed, Aug 22, 2012 at 2:54 PM
Subject: Required Challenging formula
To: excel
($A$2,$AI$3,0))*($B$3:$B$50=AK$7)*($C$2:$N$2=$AJ8)*($C$3:$N$50))
On Wed, Aug 22, 2012 at 2:54 PM, amar takale amartak...@gmail.com wrote:
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
Can anybody solve my problem
Pls suggest me foe formula
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date: Wed, Aug 22, 2012 at 6:35 PM
Subject: Fwd: Required Challenging formula
To: excel-macros@googlegroups.com
Hi All Experts
Pls find solution Milk data sheet
://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Fri, Aug 24, 2012 at 11:12 AM, amar takale amartak...@gmail.comwrote:
Hi All
I found Data validation sheet in group,It is ok if click main
Thanks Karan
But middle column is necessary? I think not.Y can see Arun reply it is
correct,select all cell Then Press Ctr+Enter.
On Fri, Aug 24, 2012 at 11:28 AM, Karan Singh karan1...@gmail.com wrote:
Hi Amar,
See attached sheet..
Karan Singh
On Fri, Aug 24, 2012 at 11:12 AM, amar
=INDEX(August!$C$4:$O$51,MATCH(1,((August!$A$4:$A$51=Main!$I7)*(August!$B$4:$B$51=Main!$I$3)),0),MATCH(Main!J$5,August!$C$3:$O$3,0))
I will used this formula where criteria is not match give #NA So How to use
ISERR funtion in this formula then cell show blank only instead of #NA but
formula are
(1,((august!$A$4:$A$51=main!$I7)*(august!$B$4:$B$51=main!$I$3)),0),MATCH(main!J$5,august!$C$3:$O$3,0)))
On Fri, Aug 24, 2012 at 12:26 PM, amar takale amartak...@gmail.comwrote:
=INDEX(August!$C$4:$O$51,MATCH(1,((August!$A$4:$A$51=Main!$I7)*(August!$B$4:$B$51=Main!$I$3)),0),MATCH(Main!J$5
On Fri, Aug 24, 2012 at 12:01 PM, amar takale amartak...@gmail.comwrote:
Thanks Karan
But middle column is necessary? I think not.Y can see Arun reply it is
correct,select all cell Then Press Ctr+Enter.
On Fri, Aug 24, 2012 at 11:28 AM, Karan Singh karan1...@gmail.comwrote:
Hi Amar,
See
this..
Pravin.
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date: Fri, Aug 24, 2012 at 10:50 AM
Subject: $$Excel-Macros$$ Fwd: Delivery Status Notification (Failure)
To: excel-macros@googlegroups.com
-- Forwarded message --
From: amar
ok pravin
On Fri, Aug 24, 2012 at 4:09 PM, Pravin Gunjal isk1...@gmail.com wrote:
You cant, but you can change the photo whatever you would like.
On Fri, Aug 24, 2012 at 4:05 PM, amar takale amartak...@gmail.com wrote:
Dear Pravin
Can I copy that background photo.
On Fri, Aug 24, 2012
Hi Hilary
I used Excel 2003 Then how to see it
On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey resp...@gmail.com wrote:
Hi Guys,
i just completed an upgrade of my stock market dashboard, pls use as you
will. cheers
--
Join official facebook page of this forum @
Hi All VBA Experts,
This is very Challenging work for me also you Our other Excel users in
group.I required VBA code when our research report published on outlook
(Outlook 2003) then that report automatic save on give folder Path
(H:\Published Reports\India Reports).
So anyone put this
® smartphone from Airtel Ghana
--
*From: * amar takale amartak...@gmail.com
*Sender: * excel-macros@googlegroups.com
*Date: *Sat, 25 Aug 2012 10:43:25 +0530
*To: *excel-macros@googlegroups.com
*ReplyTo: * excel-macros@googlegroups.com
*Subject: *Re: $$Excel-Macros$$ UPGRADE
Noorin sir
Can y send me this file in excel 2003
On Mon, Aug 27, 2012 at 4:03 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Neeraj,
See attached sheet, Hope it will help to you.
On Mon, Aug 27, 2012 at 3:23 PM, Neeraj neerajchauhan...@gmail.comwrote:
** **
** **
*From:*
Can Anybody help me
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date: Sat, Aug 25, 2012 at 12:47 PM
Subject: $$Excel-Macros$$ VBA code for automatic published (Outlook) report
save to Given Folder Path
To: excel-macros@googlegroups.com
Hi All VBA Experts
Hi Noorin
what is logic of last number 4 in formula if I change it nothing change in
output
={INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),),ROW(B1))-4)}
I used excel 2003 so I changed formula like this Pl tell me logic of number
4 in last
On Tue, Aug 28, 2012 at 10:16 PM, maksood
Dear Noorin
All VBA Experts,
This is very Challenging work for me also you Our other Excel users in
group.I required VBA code when our research report published on outlook
(Outlook 2003) then that report automatic save on give folder Path
(H:\Published Reports\India Reports).
So anyone put this
://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com
On Fri, Aug 31, 2012 at 5:18 PM, amar takale amartak...@gmail.com wrote:
--
Join official facebook page of this forum @
https://www.facebook.com
One more question ask you what changes if 3D shading box clock remove
click
On Sat, Sep 1, 2012 at 10:36 AM, amar takale amartak...@gmail.com wrote:
Dear Noorin,
Thanks very much but i will ask you there are cell D6 E6 depend on B6
C6.Can there direct option to D6 E6 in percentage bcos
Congratulation Noorain Sir.
Regards
Amar
On Mon, Sep 3, 2012 at 3:38 PM, Deba Ranjan drdeva...@gmail.com wrote:
Heartiest Congratulations brother.
Thanks Regards,
*Deba Ranjan *
On Mon, Sep 3, 2012 at 3:04 PM, Indrajit $nai talk2indra...@gmail.comwrote:
*Congrats
--
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 Problem, Code Problem, and Need Advice will
+5:30, amar takale wrote:
--
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 Problem, Code
the attached solved excel sheet also.
Regards
Amresh
Regards
Amresh Maurya
On Tue, Sep 4, 2012 at 2:01 PM, amar takale amartak...@gmail.com wrote:
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
--
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 Problem, Code Problem, and Need Advice will
Dear Guillett Sir
That amazing formula,I never thought sum product formula useable
Thanks very very much
If you have time one another problem I faced ,This is confusing formula
bcos more than three criteria for passing Can you help me?
Pls Pls .
Appreciate the help
On Tue, Sep 4,
Hi All Experts,
Pl solved challenging formula for passing.
Appreciate the help very much
--
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,
tell what is passing marks...
Regard
Manoj
On Wed, Sep 5, 2012 at 1:06 PM, amar takale amartak...@gmail.com wrote:
Hi All Experts,
Pl solved challenging formula for passing.
Appreciate the help very much
--
Join official facebook page of this forum @
https://www.facebook.com
you in advance for your help!
Pls
Amar
On Wed, Sep 5, 2012 at 1:20 PM, amar takale amartak...@gmail.com wrote:
Hi manoj,
If failed minmum one subject then show failed (required output in yellow)
(looking Minmum marks on Row numbers 10) F10:L10.
If anyone got marks less than minimum
Hi Manoj,
Now I attached sheet.See it
On Wed, Sep 5, 2012 at 1:42 PM, amar takale amartak...@gmail.com wrote:
Hi Manoj,
This is valuable formula for me,Thanks for it.But I think it is also show
in short formula but now I forget it how to use it.I attached sheet with
your formula. Can you
:43 PM, amar takale amartak...@gmail.com wrote:
Hi Manoj,
Now I attached sheet.See it
On Wed, Sep 5, 2012 at 1:42 PM, amar takale amartak...@gmail.com wrote:
Hi Manoj,
This is valuable formula for me,Thanks for it.But I think it is also
show in short formula but now I forget it how to use
...@gmail.com
wrote:
Dear amar,
Please tell what is passing marks...
Regard
Manoj
On Wed, Sep 5, 2012 at 1:06 PM, amar takale amartak...@gmail.comwrote:
Hi All Experts,
Pl solved challenging formula for passing.
Appreciate the help very much
--
Join official facebook page of this forum
*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amar takale
*Sent:* 05 September 2012 1:03
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Rank Formula
** **
Dear
]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amar takale
*Sent:* 06 September 2012 10:26
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Rank Formula
** **
Rajan I think this is not working,I used
--
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 Problem, Code Problem, and Need Advice will
Hi All Experts
Pls suggestion for required formula
On Fri, Sep 7, 2012 at 7:18 PM, amar takale amartak...@gmail.com wrote:
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise
@googlegroups.com] *On Behalf Of *amar takale
*Sent:* 06 September 2012 10:45
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need VBA code for Formatting chart
** **
** **
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
In this example (Lookup photo) used VBA Also.Pls see VBA code .I attached
link where from I download Example file. See below
*http://www.mcgimpsey.com/excel/lookuppics.html*
On Thu, Sep 13, 2012 at 1:20 PM, amar takale amartak...@gmail.com wrote:
Hi All,
I found above file on web. But I cant
, September 13, 2012 1:23:52 PM UTC+5:30, amar takale wrote:
In this example (Lookup photo) used VBA Also.Pls see VBA code .I attached
link where from I download Example file. See below
*http://www.mcgimpsey.com/excel/lookuppics.html*
On Thu, Sep 13, 2012 at 1:20 PM, amar takale amart
in cell - F1
Please revert for any further clarification.
Regards
Rajender Soni
On Thursday, September 13, 2012 1:20:43 PM UTC+5:30, amar takale wrote:
Hi All,
I found above file on web. But I cant understand this file. I understand
all but i would to understand where is all photo.how
@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amar takale
*Sent:* 14 September 2012 11:25
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Re: How to create this file? Explain
anyone
** **
Hi Rajan Prince,
Thanks for Guides about visibility (In VBA
(if not visible)*
***3) Align them at a place same height width*
***4) Try again to run the code*
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amar takale
*Sent
-Gtalk]*
* *
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amar takale
*Sent:* 15 September 2012 1:00
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Pull out VBA code from sheet
** **
Hi All VBA Experts
Can Anybody pull
result data in given example in separate sheet.
Rgds//Vabs
On Thursday, September 20, 2012 12:19:01 PM UTC+5:30, amar takale wrote:
Dear Vabs
I already use auto filter to get data.With auto filter I will get only
One Year Data But I want all Data in one shot
On Thu, Sep 20, 2012 at 12:06 PM
Wow.Vabs. This will be grt.Now I know my mistek
Thanks a lot very much
Best Regards,
Amar
On Sat, Sep 22, 2012 at 11:15 AM, Vabz v...@vabs.in wrote:
Hi
There was error in formula..
Pl check..
Rgds//Vabs
On Saturday, September 22, 2012 10:58:59 AM UTC+5:30, amar takale wrote
--
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 Problem, Code Problem, and Need Advice will
*-
--
*From:* amar takale amartak...@gmail.com
*To:* excel-macros@googlegroups.com
*Sent:* Mon, September 24, 2012 7:51:28 AM
*Subject:* $$Excel-Macros$$ Vlookup Required
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
Dear Group Members,
Please Solution Need!
I need to apply Vlookup+Match formula to get value in sheet1 (C5 to F5)
cell But it show same Output below.
Sheet1 (C5 to F5) cell Below cell is the result cell where I want to use
the formula to get the output from sheet2.
Best Regards,
Pls find attached below file
See Attached file.
On Mon, Sep 24, 2012 at 6:43 PM, amar takale amartak...@gmail.com wrote:
Dear Group Members,
Please Solution Need!
I need to apply Vlookup+Match formula to get value in sheet1 (C5 to F5)
cell But it show same Output below.
Sheet1
, September 24, 2012 7:01:25 PM UTC+5:30, amar takale wrote:
Pls find attached below file
See Attached file.
On Mon, Sep 24, 2012 at 6:43 PM, amar takale amart...@gmail.com wrote:
Dear Group Members,
Please Solution Need!
I need to apply Vlookup+Match formula to get value in sheet1 (C5
Need help.
On Tue, Sep 25, 2012 at 2:38 PM, amar takale amartak...@gmail.com wrote:
Hi Vabz
I will try it but how to range criteria.Bcos after giving formula I used
data validation for name.If I click Name Then all other criteria show inone
shot.
On Tue, Sep 25, 2012 at 12:00 PM, Vabz v
show NA.
Regards
Amar
On Wed, Sep 26, 2012 at 12:12 PM, Vabz v...@vabs.in wrote:
Hi
Sorry for Late reply, I have defined some logic based on your crieterion,
see it works or not..
Rgds//vabs
On Tuesday, September 25, 2012 5:43:07 PM UTC+5:30, amar takale wrote:
Need help.
On Tue, Sep 25
Hi All Experts
I need VBA code for Excel table paste in word on one click.If I Select
Table or range for one or more table Then click Button then automatically
Table paste in word with format which format in excel.
Regards
Amar
--
Join official facebook page of this forum @
Hi All Experts,
Can anybody give me VBA code for Excel table copy paste in word as it
adjust column.If I change formatting ,Add row column also add in word.
Pls
Appreciate the help.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
Congratulations Rajan
Regards,
Amar
On Wed, Oct 3, 2012 at 12:17 PM, Indrajit $nai talk2indra...@gmail.comwrote:
*Congrats bro. :)*
*
*
On Wed, Oct 3, 2012 at 11:35 AM, SAGAR KASANGOTTUWAR
sagarkasangottu...@gmail.com wrote:
Congrats Rajan
On Wed, Oct 3, 2012 at 10:36 AM,
Hi Mangesh
Can you send file as Excel 2003.Then I will try to solved your problem.
On 10/3/12, Mangesh Vimay mangesh.da...@gmail.com wrote:
Hi Rajan,
Its sample data I have provided but the data range would remain same.
Please provide solution.
Thanks !!!
On Wed, Oct 3, 2012 at 6:43 PM,
Hi
In cell what input = removeSpecial(Cell) like this?
On 10/5/12, jeet singh jeetexcelt...@gmail.com wrote:
Function removeSpecial(sInput As String) As String
Dim sSpecialChars As String
Dim i As Long
sSpecialChars = \/:*? {}[](),!`~\:;'._-=+^%$|
For i = 1 To
Hi all,
Can Anybody help me for create Sparklines in excel 2003.Any formula or any
VBA code.Pls Suggest me
Thanks in Advance
Amar
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise,
Pls Give me Idea about Sparklines
-- Forwarded message --
From: amar takale amartak...@gmail.com
Date: Mon, Oct 8, 2012 at 10:22 AM
Subject: $$Excel-Macros$$ Spark lines in Excel 2003
To: excel-macros@googlegroups.com
Hi all,
Can Anybody help me for create Sparklines in excel
Hi all Experts,
Can anybody tell me how to export worksheet with VBA code from one sheet to
another sheet.Suppose In my sheet if there are 5 tab three VBA code
include.If I want to export one tab with VBA code to other new sheet it is
possible? I will try but not possible.
Pls suggest helpful
*Hi All Champs*
Can anybody tell me how to copy paste excel table in word as it with
formatting.So I want to VBA code for that then I will create button only
click it So table automatically copy paste in word.For other sheet in code
I will change only range of table as per data size table click
Pls help me for this solution
On Tue, Oct 16, 2012 at 5:26 PM, amar takale amartak...@gmail.com wrote:
*Hi All Champs*
Can anybody tell me how to copy paste excel table in word as it with
formatting.So I want to VBA code for that then I will create button only
click it So table
-and-column-number-of.html
http://www.excelvbamacros.com/2011/10/copy-range-from-excel-and-paste-as.html
On Wed, Oct 17, 2012 at 10:07 AM, amar takale amartak...@gmail.comwrote:
Pls help me for this solution
On Tue, Oct 16, 2012 at 5:26 PM, amar takale amartak...@gmail.comwrote:
*Hi All Champs
might not have to copy any VBA stuff at all after add-in installation.
** **
Asa
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amar takale
*Sent:* Wednesday, October 17, 2012 10:15 PM
*To:* excel-macros@googlegroups.com
://www.rimlinger.eu/sparklines/
** **
At least I think that the above pages are for the same open source add-in,
Sparklines for Excel, that you shared with us.
** **
Asa
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *amar takale
Pls help me on below topic
On Thu, Oct 18, 2012 at 6:31 PM, amar takale amartak...@gmail.com wrote:
Dear Hilary
Your code not working it show out of range I will attached file as per you
suggest link below It also not working Pl see file
On Wed, Oct 17, 2012 at 10:33 PM, Hilary Lomotey
Hi Experts,
Pls Solved Problem in Attached Excel
Regards
Amar
--
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,
hi satendra
can you solve in excel then i will better clarification
On Tue, Oct 23, 2012 at 3:59 PM, Satendra kumar
satendrakuma...@gmail.comwrote:
Hi Amar,
*go to conditional formatting and set icons*
On Tue, Oct 23, 2012 at 3:51 PM, amar takale amartak...@gmail.com wrote:
Hi Experts
Pls can anybody guide me
On Tue, Oct 23, 2012 at 3:51 PM, amar takale amartak...@gmail.com wrote:
Hi Experts,
Pls Solved Problem in Attached Excel
Regards
Amar
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
1 - 100 of 440 matches
Mail list logo