Dear Mr. Dilip
How about similar name. file attached.
Thanks
Pada Senin, 09 November 2009 15:11:07 UTC+8, DILIPandey menulis:
>
> Dear Umesh,
>
> I have skipped this one. My appologies.
>
> IF(ISNUMBER(MATCH("*"&MID(C4,1,FIND(" ",C4)-1)&"*",$A:$A,0)),"Mapped","Not
> Found
>
> MATCH funct
Dear Umesh,
I have skipped this one. My appologies.
IF(ISNUMBER(MATCH("*"&MID(C4,1,FIND(" ",C4)-1)&"*",$A:$A,0)),"Mapped","Not
Found
MATCH function will match the name in the list which is there in Column A.
* sign is used to match it with some additional characters in the start and
end of the
Hi Dilip,
Thanks for the help. I was trying to learn myself but could not. I need your
help from the scratch for eg:-
IF(ISNUMBER(MATCH("*"&MID(C4,1,FIND(" ",C4)-1)&"*",$A:$A,0)),"Mapped","Not
Found
Pls explain me from the root as to why you have used Isnumber, match and "*"
etc
Happy belated Di
;
> Thanks ---
>
> regards,
> Michael
>
>
> --
> *From:* Dilip Pandey [mailto:dilipan...@gmail.com]
> *Sent:* 13 October 2009 16:10
> *To:* excel-macros@googlegroups.com
> *Cc:* Drayton, Michael E [ICG-GTS]
> *Subject:* Re: $$Excel-Macros
Hi Umesh,
I have used "OFFSET" function to get the name to which the target names are
matching. It picks the name which has got matched and takes that as a row
to get down in the list of the names, starting from first name in the list.
Let me know if you need any other help.
Best Regards,
--
DI
Hi Dilip,
Can you explain the logic pls.
Regards
Umesh
On Tue, Oct 13, 2009 at 8:39 PM, Dilip Pandey wrote:
> Thanks Michael,
>
> The enhancement is done in the attached file as per your requirements.
> Thanks
>
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
>
Thanks Sir!
YOU ARE THE KING!!!
Thanks ---
regards,
Michael
From: Dilip Pandey [mailto:dilipan...@gmail.com]
Sent: 13 October 2009 16:10
To: excel-macros@googlegroups.com
Cc: Drayton, Michael E [ICG-GTS]
Subject: Re: $$Excel-Macros$$ Re: Name Matching In
Thanks Michael,
The enhancement is done in the attached file as per your requirements.
Thanks
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Oct 13, 2009 at 7:00 PM, Drayton, Michael E <
michael.e.dray
Dilip,
You are king!
Is there a way we can make Column F reflect the value from Sheet 1 if E4 =
"mapped" instead of reflecting what's on Sheet 2?
Here is my logic. When using this formula in action, I won't be able to check
what the formula matches on Sheet 1 because Sheet 1 may have 5,000 n
Hi Michael,
Actually, if the name of sheet 2 is matching in the list in Sheet 1, then I
am saying as "Found". Further to this, I have fetched those names which are
matched considering full name and only the first name. Please look at the
attached file for further understanding.
Best Regards,
--
Hi Sonal,
The query attached by you has been solved per your expectations and attached
herewith. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 9/21/09, Sonal Gadgil wrote:
>
> Hi...
>
> I am new
Hi dear Sonal,
You can refer to Help on VLOOKUP (or COUNTIF whichever is easy!)
function in excel (excel as I feel has got excellent help file)
I would put the required formula in your attachment and upload it back
but I do not see the "Attach" option here!
I had asked for help but no one seems
12 matches
Mail list logo
