Hi Pooja,
Solved spreadsheet is attached with this email.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, May 26, 2009 at 11:31 AM, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a conditio
Hi Pooja,
The attatched solution may help you.
Regards,
Jayell
On May 26, 4:01 pm, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in which I have to match a column with other
> two columns and if out of those two columns any of them match with the first
> column then the res
Hi,
try this
=IF(OR(D5=B5,D5=A5),"match","mismatch")
however you've to remove the domain name from column "d" or use text formula
to remove the domain name value i.e "@gmail.com, which is not there in
column "a"
thanks
Durai
On 5/25/09, Pooja Sharma wrote:
>
> Hi All,
>
> I need a help, with
On Tue, May 26, 2009 at 11:31 AM, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in which I have to match a column with
> other two columns and if out of those two columns any of them match with the
> first column then the result will be "Match" otherwise "Mismatch"
>
> --
> Bes
Pooja,
I hope you are looking for this one..(colored in red) this was calculated as
per the length..so you can adjust the same per your convience...
Good Luck
Cheers
Surya
On Tue, May 26, 2009 at 11:31 AM, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in which I have to mat
=IF(OR(D5=B5,LEFT(D5,FIND(".",D5)-1)=LEFT(A5,FIND("
",A5)-1)),"Match","Mismatch")
Hi Pooja,
Write this formulas on E5 Cell and dreg it down. it should work.
Great Day..!!!
Ciao..!!
Jai Kishan
On May 26, 11:01 am, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in wh
Pls use this formulas...
=IF(OR(D5=B5,LEFT(D5,FIND(".",D5)-1)=LEFT(A5,FIND("
",A5)-1)),"Match","Mismatch")
on E5 Cell and Drag it down.
Ciao..!!
Jay
On May 26, 11:01 am, Pooja Sharma wrote:
> Hi All,
>
> I need a help, with a condition in which I have to match a column with other
> two c
