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
use after trim
VLOOKUP(D6,C6:C47,1,FALSE)
From: Deba Ranjan drdeva...@gmail.com
To: excel-macros@googlegroups.com; NOORAIN ANSARI noorain.ans...@gmail.com
Sent: Tuesday, April 3, 2012 1:29 PM
Subject: $$Excel-Macros$$ Exact names Find
Dear Expert,
Dear Laxmanand Dear Marie
Very Very thanks for the solution
Regards
Shrinivas
On Tue, Apr 3, 2012 at 3:08 AM, Maries talk2mar...@gmail.com 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
Dear Haseeb
Very Very thanks
Regards
Shrinivas
On Tue, Apr 3, 2012 at 5:44 AM, Haseeb A haseeb.avarak...@gmail.com 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
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,
*Hi All,
Thank you very much experts. Once again thanks.
*
Thanks Regards,*
*
On Tue, Apr 3, 2012 at 2:41 PM, CoRe neculae.vale...@gmail.com 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
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
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 darwin.chankaw...@gmail.comwrote:
Dear
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 darwin.chankaw...@gmail.com
To: excel-macros@googlegroups.com
Sent: Tuesday, April 3, 2012 12:02 PM
Subject: $$Excel-Macros$$ To
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
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 drdeva...@gmail.com wrote:
Dear Expert,
Please find the attached file. i just want the exact and match name to
find in another columns. please
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,
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 kavitaahuja2...@gmail.comwrote:
Hi Friends,
I am looking for a job in excel/Access vba with 6 years experience in
gurgaon.
Please contact me if you
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
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
Hello
--
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
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 samde...@gmail.comwrote:
This link will tell you how to add a tab in Excel
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 violation)
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 haseeb.avarak...@gmail.comwrote:
Hello Deba,
Try this in E6 with *CTRL+SHIFT+ENTER*, rather than just ENTER
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,
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 aamirshahza...@gmail.comwrote:
Dear Group,
How to extract 6 digit numbers from right if its number convert this to
Great job Haseeb !!!
thank you
chilexcel
2012/4/3 Aamir Shahzad aamirshahza...@gmail.com
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 haseeb.avarak...@gmail.comwrote:
Hello Deba,
Try this
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
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
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 koul.ash...@gmail.com wrote:
check this make change as per your requirement
On Mon, Apr
Hi I need assistance in finding the right formula to substitute the value
to dates in countif
[image: Alexei De Guzman][image: Just Joined]
*Alexei De Guzman https://thehub.thomsonreuters.com/people/0143599* Apr
3, 2012 9:03 PM
Hi,
I am trying to come up with the formula to pull up dates from
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 rekha.siri2...@gmail.com wrote:
Hi I need assistance in finding the right formula to substitute the value
to
Dear Pawel,
yes, this is what i m looking for, thanks for your help~[?]
2012/4/3 pawel lupinski lupins...@yahoo.com
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 darwin.chankaw...@gmail.com
*To:*
*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.
Thanks
29 matches
Mail list logo