Re: $$Excel-Macros$$ Extract desired data

Hi, Try below array formula, =MAX(IFERROR(RIGHT(C2,{1,2,3,4,5,6,7,8,9,10})*1,"")) Apply with Ctrl + Shift + Enter. Regards, MARIES On Wed, Apr 4, 2012 at 10:21 AM, Waseem Saifi wrote: > please check attached file. > > > On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote: > >> Dear Group, >

Re: $$Excel-Macros$$ Extract desired data

please check attached file. On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote: > Dear Group, > > How to extract 6 digit numbers from right if its number & convert this to > numbers by formula. See the attached file. > > Regards, > > Aamir Shahzad > > -- > FORUM RULES (986+ members already BAN

Re: $$Excel-Macros$$ Re: Exact names Find

*Dear Expert Can you please explain me the following :- *=INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,3,4,5,6,7,8,9,10})&"*",SUBSTITUTE(C$6:C$47," ",""),0),""))) There i find -C$6:C$47, i mean $ symbol is there . can you please tell me how the $ symbol arise. Thank

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

Dear Pawel, yes, this is what i m looking for, thanks for your help~[?] 2012/4/3 pawel lupinski > I realy don't know what are you looking for so check if this is what you > are looking for. > > Regards, > > Pawel > > *From:* Darwin Chan > *To:* excel-macros@googlegroups.com > *Sent:* Tuesd

Re: $$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates.

Hi, PFA. Use below Array formula, =IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4),0)),"") Regards, MARIES. On Wed, Apr 4, 2012 at 7:16 AM, rekha siri wrote: > Hi I need assistance in finding the right formula to substitute the value > to dates in > [image: Ale

$$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates.

Hi I need assistance in finding the right formula to substitute the value to dates in [image: Alexei De Guzman][image: Just Joined] *Alexei De Guzman * Apr 3, 2012 9:03 PM Hi, I am trying to come up with the formula to pull up dates from a trac

Re: $$Excel-Macros$$ Need Power point code help

Hi Ashish, Thanks alot i Just referenced the Sheet name and decreased the size. i am able to get the desired result. Thanks for your help. Regards, Rekha On Mon, Apr 2, 2012 at 9:15 PM, ashish koul wrote: > check this make change as per your requirement > > > > On Mon, Apr 2, 2012 at 10:27 A

$$Excel-Macros$$ VBA Classes

HI Team, Gnanainfo will conducting Weekend VBA Classes at Hyderabad on 07-04-2012 & 08-04-2012 ,14-04-2012 & 15-04-2012. For more details you can reach : gnanainfo@gmail.com 09703091552. Thanks and Regards Simha -- FORUM RULES (986+ members already BANNED for violation) 1) Use concis

$$Excel-Macros$$ Prefix a pic in the userform caption

Hi Group, I want to prefix a picture in the userform caption in excel. Would request to help me with that. -- Regards Santosh santoshkumar.subu...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Re: Exact names Find

Great job Haseeb !!! thank you chilexcel 2012/4/3 Aamir Shahzad > Haseeb, > > Can you breif your formula if I want to understand the logic. > > Regards, > > Aamir Shahzad > > On Tue, Apr 3, 2012 at 11:44 PM, Haseeb A wrote: > >> Hello Deba, >> >> Try this in E6 with *CTRL+SHIFT+ENTER*, rath

Re: $$Excel-Macros$$ Extract desired data

Hi Aaamir, Please find the attached data. please check and let me know is this your requirement. Regards, Jaysheel Bhasme On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote: > Dear Group, > > How to extract 6 digit numbers from right if its number & convert this to > numbers by formula. See th

$$Excel-Macros$$ Extract desired data

Dear Group, How to extract 6 digit numbers from right if its number & convert this to numbers by formula. See the attached file. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urg

Re: $$Excel-Macros$$ Re: Exact names Find

Haseeb, Can you breif your formula if I want to understand the logic. Regards, Aamir Shahzad On Tue, Apr 3, 2012 at 11:44 PM, Haseeb A wrote: > Hello Deba, > > Try this in E6 with *CTRL+SHIFT+ENTER*, rather than just ENTER > > =INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,

$$Excel-Macros$$ Re: Exact names Find

Hello Deba, Try this in E6 with *CTRL+SHIFT+ENTER*, rather than just ENTER =INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,3,4,5,6,7,8,9,10})&"*",SUBSTITUTE(C$6:C$47," ",""),0),""))) Then drag down ___ HTH, Haseeb -- FORUM RULES (986+ members already BANNED for vi

Re: $$Excel-Macros$$ Add-in creation in excel 2007

thanks sam links are very helpful can i use the same ribbon in all excel files.. Thanks Rajesh Mahapatra On Tue, Apr 3, 2012 at 1:21 AM, Sam Mathai Chacko wrote: > This link will tell you how to add a tab in Excel > > > http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/?hi

$$Excel-Macros$$ Test Mail

-- 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 thr

RE: $$Excel-Macros$$ Re: Exact names Find

You can try this : =VLOOKUP("*" &D6 &"*",$C$6:$C$47,1,0) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of CoRe Sent: Apr/Tue/2012 02:41 To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: $$Excel-Macros$$ Re: Exact names Find

$$Excel-Macros$$ Last Visit Invoice Details with formula

Dear All, Could you please help me with a formula? Attached is a sample file where in I need in column (W, X & Y) Invoice date, Invoice Number & Inv. Amount for each cab's previous last visit. Similarly I need in column (Z, AA & AB) Invoice date, Invoice Number & Inv. Amount for each cab's pre

Re: $$Excel-Macros$$ Looking for Excel/Access vba job with 6 years of experience

Kavita, I am looking for such a person. I'm sure you remember me from good old days. Regards, Sam On Tue, Apr 3, 2012 at 6:35 PM, kavita ahuja wrote: > Hi Friends, > > I am looking for a job in excel/Access vba with 6 years experience in > gurgaon. > Please contact me if you know about any openi

Re: $$Excel-Macros$$ Exact names Find

Hi expert, Please it is not working. will you please do it in the excel itself. Regards deba On Tue, Apr 3, 2012 at 1:29 PM, Deba Ranjan wrote: > Dear Expert, > > Please find the attached file. i just want the exact and match name to > find in another columns. please help me in urgent b

$$Excel-Macros$$ Count formula

Dear Shrinivas Try the below mentioned formulae also: *=COUNTIFS(D7:D955,">=05/01/2012",D7:D955,"<07/01/2012")* Regards, Rajender Soni | +91 750 322 55 50 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

$$Excel-Macros$$ Looking for Excel/Access vba job with 6 years of experience

Hi Friends, I am looking for a job in excel/Access vba with 6 years experience in gurgaon. Please contact me if you know about any opening in gurgaon. Would appreciate your help. Many thanks , Kavita -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

I realy don't know what are you looking for so check if this is what you are looking for.   Regards,   Pawel From: Darwin Chan To: excel-macros@googlegroups.com Sent: Tuesday, April 3, 2012 12:02 PM Subject: $$Excel-Macros$$ To calculate the maximum and minimum

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

Dear Darwin, Please find the attached file. {I am not understant exact wt you want in from time & please revert me with sample like count or sum total working hours ) Thanks & Regards Anil Kumar 113784 On Tue, Apr 3, 2012 at 4:32 PM, Darwin Chan wrote: > Dear all, > > I have a roster

$$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

Dear all, I have a roster with staff allocated on different roster plan, i.e. different working hours. I have a task to analyse the maximum and minimum of staff who would appear at concurrent period. However, volume of data is huge and formula is needed for assistance in analysis. I have atta

Re: $$Excel-Macros$$ Re: Exact names Find

*Hi All, Thank you very much experts. Once again thanks. * Thanks & Regards,* * On Tue, Apr 3, 2012 at 2:41 PM, CoRe wrote: > > Hello Bhaity, > > PFA. > > I used Trim in first instance to loose all the spaces, 2nd thing ID > collumn has been sort as ascending for a better match. (descend

$$Excel-Macros$$ Re: Exact names Find

Hello Bhaity, PFA. I used Trim in first instance to loose all the spaces, 2nd thing ID collumn has been sort as ascending for a better match. (descending problem , haven't figured out). good luck & hope it helps On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote: > > Dear Expert, >

Re: $$Excel-Macros$$ Re: Count formula

Dear Haseeb Very Very thanks Regards Shrinivas On Tue, Apr 3, 2012 at 5:44 AM, Haseeb A wrote: > Hello Shrini, > > =COUNTIF(D:D,">="&StartDate)-COUNTIF(D:D,">="&EndDate+1) > > Or, > > =SUMPRODUCT(COUNTIF(D:D,">="&IF({1,0},StartDate,EndDate+1))*{1,-1}) > > this way able to use whole column refe

Re: $$Excel-Macros$$ Count formula

Dear Laxmanand Dear Marie Very Very thanks for the solution Regards Shrinivas On Tue, Apr 3, 2012 at 3:08 AM, Maries wrote: > Hi, > > Try, below shown Array formula. (Apply with CSE) > > =SUM((--INT(D7:D955)>=H13)*--(INT(D7:D955)<=H14)) > > Conditions, H13-Start Date & H14-End Date > > Regard

Re: $$Excel-Macros$$ Exact names Find

use after trim       VLOOKUP(D6,C6:C47,1,FALSE)       From: Deba Ranjan To: excel-macros@googlegroups.com; NOORAIN ANSARI Sent: Tuesday, April 3, 2012 1:29 PM Subject: $$Excel-Macros$$ Exact names Find Dear Expert,   Please find the attached file. i just wa

$$Excel-Macros$$ Exact names Find

Dear Expert, Please find the attached file. i just want the exact and match name to find in another columns. please help me in urgent basis dear experts. Thanks & Regards,* * *Deba Ranjan P*** -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titl