Re: $$Excel-Macros$$ Re: Urgent Help.

2013-10-05 Thread Seraj Alam
ou received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscr...@googlegroups.com. > To post to this group, send email to excel-m

Re: $$Excel-Macros$$ subtitute function infirmation required

2012-09-18 Thread Seraj Alam
confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegr

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012

2012-09-02 Thread Seraj Alam
s://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 not get quick attention or may

Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member July 2012

2012-08-04 Thread Seraj Alam
ed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, s

Re: $$Excel-Macros$$ Some Help

2012-08-01 Thread Seraj Alam
ver post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$

2012-07-30 Thread Seraj Alam
d 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 thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypa

Re: $$Excel-Macros$$

2012-07-25 Thread Seraj Alam
signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To

Re: $$Excel-Macros$$ Unique list

2012-07-11 Thread Seraj Alam
- > To post to this group, send email to excel-macros@googlegroups.com > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com -- Thanks & Regards Seraj Alam *+91 989 130

$$Excel-Macros$$ Test

2012-06-19 Thread Seraj Alam
-- Thanks & Regards Seraj Alam *+91 989 130 1776* -- 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

Re: $$Excel-Macros$$ delete my id from mailing list

2012-06-06 Thread Seraj Alam
res are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -- > To post to this group

Re: $$Excel-Macros$$ Re: extract data from table

2012-06-05 Thread Seraj Alam
ormula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, foru

Re: $$Excel-Macros$$ doubt

2012-05-27 Thread Seraj Alam
e > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums com

Re: $$Excel-Macros$$ unable to use advance vlookup

2012-05-20 Thread Seraj Alam
mula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the respo

Re: $$Excel-Macros$$ Dynamic List range for Data validation

2012-05-16 Thread Seraj Alam
ve to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > -

Re: $$Excel-Macros$$ How to get sheet name with formula

2012-05-16 Thread Seraj Alam
Hi U can try below code also... Sub Rename_sheet() Sheets(2).Activate ActiveSheet.Name = "Sheet ka name Change hua" End Sub On Mon, May 14, 2012 at 11:56 AM, hilary lomotey wrote: > tnks boss > > > On Mon, May 14, 2012 at 5:44 PM, Seraj Alam wrote: > >> H

$$Excel-Macros$$ Require total timing

2012-05-14 Thread Seraj Alam
Hi Expert, I have attached sheet in which I need total time taken in column C, I have applied formula but its not working properly. So please help me on this one. -- Thanks & Regards Seraj Alam *+91 989 130 1776* -- FORUM RULES (986+ members already BANNED for violation) 1) Use con

Re: $$Excel-Macros$$ How to get sheet name with formula

2012-05-14 Thread Seraj Alam
n't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> >> >> ------ >> To post to this group, send email to excel-macros@googlegroups.co

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

2012-05-02 Thread Seraj Alam
hread 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 thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowled

Re: $$Excel-Macros$$ format cell

2012-04-04 Thread Seraj Alam
----- > To post to this group, send email to excel-macros@googlegroups.com > -- Thanks & Regards Seraj Alam 9891301776 -- FORUM RULES (986+ members already BANNED for violation) 1) Use conc

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

2012-03-22 Thread Seraj Alam
superb noorain bhai. 2012/3/22 NOORAIN ANSARI > जहाँ Excel के दीवानों की, है बहूत घनी आबादी. > जहाँ Question,Answer करने की,है खूब आज़ादी. > जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. > दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गया. > चाहे

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

2012-03-14 Thread Seraj Alam
Congrats noorain bhai. [?][?][?][?][?] On Wed, Mar 14, 2012 at 3:49 PM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has be

Re: $$Excel-Macros$$ Help...

2012-03-11 Thread Seraj Alam
Hi, Please find below link to hide formula in spreadsheets... http://www.techonthenet.com/excel/cells/hide_formulas.php Thanks Seraj On Sun, Mar 11, 2012 at 4:57 PM, ashjain2...@yahoo.co.in < ashjain2...@yahoo.co.in> wrote: > Dear Team > > I use many formulas in the excel sheet and i want th

Re: $$Excel-Macros$$ Pivot multisheet how to use? for what purpose?

2012-03-11 Thread Seraj Alam
Please find below link for how to creat pivot table on multiple sheet... http://www.youtube.com/watch?v=ZBn1-r0I5oE On Sat, Mar 10, 2012 at 10:40 AM, Mohammed Muneer wrote: > Dear Group Plz, tell me how I can use it? And for what purpose? > > ** ** > > ** ** > > Regards, > > Muneer,***

Re: $$Excel-Macros$$ ORDERS SHEET 2012.xlsm

2012-03-08 Thread Seraj Alam
Hi, See attached...is that what u want..? Suggest... On Thu, Mar 8, 2012 at 2:05 AM, Gulam Hameed wrote: > Dear All Experts…..!! > > ** ** > > WISH U ALL EXPERTS HAPPY HOLI……!!! > > ** ** > > Can some help me out please find attach example sheet > > ** ** > > Thanks & Best Rega

Re: $$Excel-Macros$$ ORDERS SHEET 2012.xlsm

2012-03-08 Thread Seraj Alam
Hi, See attached...is that what u want..? Suggest... On Thu, Mar 8, 2012 at 2:05 AM, Gulam Hameed wrote: > Dear All Experts…..!! > > ** ** > > WISH U ALL EXPERTS HAPPY HOLI……!!! > > ** ** > > Can some help me out please find attach example sheet > > ** ** > > Thanks & Best Regard

Re: $$Excel-Macros$$ Need if formula

2012-03-06 Thread Seraj Alam
Hi, In 200 version u can use only 7 if condition however in 2007 and later version u can use 64 if condition... Thanks seraj On Tue, Mar 6, 2012 at 8:14 PM, Ashish Bhalara wrote: > Dear expert, > > If function used maximum 7 time in an function, if the requirement of > condition if is more th

Re: $$Excel-Macros$$ how to subscribe?

2012-03-05 Thread Seraj Alam
Hi, Please find below link to join this group. http://groups.google.com/group/excel-macros On Mon, Mar 5, 2012 at 7:50 PM, Mohammed Muneer wrote: > Dear Friends, > > ** ** > > I want to subscribe this group with another mail id not Outlook – > munnu130134...@gmail.com > > ** ** >

Re: $$Excel-Macros$$ Urgent: Need Help (Assignment)

2012-03-01 Thread Seraj Alam
Hi, Please try this with Ctrl+shift+enter =INDEX($B$3:$B$11,MATCH(LARGE(IF($A$3:$A$11=$E$3,$C$3:$C$11,""),1),$C$3:$C$11,0)) On Wed, Feb 29, 2012 at 11:40 AM, dguillett1 wrote: > Is this “homework” for an excel class? > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* M

Re: $$Excel-Macros$$ vlook up multiple values

2012-02-28 Thread Seraj Alam
Hi, You can also try this one =SUMPRODUCT(($A$1:$A$5=A7)*($B$1:$B$5)) Thanks Seraj Alam On Tue, Feb 28, 2012 at 10:24 AM, finos wrote: > Dear groups > > ** ** > > How can take the multiple values from the database using vlookup formula > . can u guide me .

Re: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......

2012-02-27 Thread Seraj Alam
Please try this =IF(B1="Y",TODAY(),"") On Mon, Feb 27, 2012 at 7:55 PM, Mohammed Muneer wrote: > Dear Friends have a nice day, > > ** ** > > I have a small question. > > ** ** > > For example, I have two cols A and B as shown below one is for date & the > other have letter “Y”.**

Re: $$Excel-Macros$$ Highest No with Colour, Need Vba Code

2012-02-15 Thread Seraj Alam
On Wed, Feb 15, 2012 at 8:58 PM, Seraj Alam wrote: > >1. Select the whole table with data >2. Choose the command Format | Conditional Formatting >3. Choose Formula is >4. Write in following formula: =MAX($A$1:$A$13)=A4 where A4 is the >first cell with data

Re: $$Excel-Macros$$ Highest No with Colour, Need Vba Code

2012-02-15 Thread Seraj Alam
1. Select the whole table with data 2. Choose the command Format | Conditional Formatting 3. Choose Formula is 4. Write in following formula: =MAX($A$1:$A$13)=A4 where B4 is the first cell with data 5. Create the wanted format 6. Close the form On Fri, Feb 10, 2012 at 6:02 AM

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-01 Thread Seraj Alam
congrates noorain bhai On Wed, Feb 1, 2012 at 9:31 AM, chandra sekaran wrote: > Congratulation Noorain , you & *Rajan Verma, Sam, Don Guillett, Kris,*are a > player, Each & every one contribution great . > chandru > > On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain wrote: > >> Hello Everyon

Re: $$Excel-Macros$$ For Excel Beginner, please try this test...

2011-12-21 Thread seraj alam
Hi Ravinder, Please attach the sheet... On Tue, Dec 20, 2011 at 8:10 AM, Abhishek Jain wrote: > Which test? > > > On Mon, Dec 19, 2011 at 12:19 PM, Ravinder Negi wrote: > >> For Excel Beginner, please try this test...and enhance your >> skills.. >> >> -- >> FORUM RULES (934+ members already

Re: $$Excel-Macros$$ Two columns and three criteria

2011-09-16 Thread seraj alam
Hi, Just try it.. =SUMPRODUCT(--($A$1:A10=A1)--($A$1:A10=A2)*(B1:B10=B1)) On Thu, Sep 15, 2011 at 9:09 AM, ArtySin wrote: > Hi > I have two columns as below using Excel 2000 (unfortunately, corporate > no spend policy): These columns have been exported from a database and > appear as the exa

$$Excel-Macros$$ Fwd: कविता : जो मुरझाये ना कभी वो कवल है दोस्ती.(Happy Freindship Day)

2011-08-08 Thread seraj alam
जो मुरझाये ना कभी वो कवल है दोस्ती. दिल के पवित्र ख्यालों की पहल है दोस्ती. दोस्ती दोस्तों के दम से निभाई जाती है, मिले आप जैसे दोस्त तो सफल है दोस्ती. खुदगर्ज दोस्त हो तो गन्दी नाली है दोस्ती, सच्चे दोस्त के खातिर गंगाजल है दोस्ती. रिश्तों में सबसे ऊँचा दर्जा है दोस्ती का, थोड़ी शोख,थोड़ी नटखट, थोड़

Re: $$Excel-Macros$$ and the Microsoft MVP award goes to Ashish Koul :)

2011-07-04 Thread seraj alam
Hi Ashish, Many many congrats... With best wishesh, Seraj Alam On Mon, Jul 4, 2011 at 9:40 PM, Hari wrote: > Thanks for getting the award. Even though, i am very new to this group, > I proudly wishes to keep this spirit high always, > Have a nice day > > with best wishes