IF ,MATCH,COUNT

[Sreehari]

I have a work book with datas in different sheets , in one sheet i have a filed with header name as"File Name" which contains differnt names like "raw\KER01B711220141012081539.DAT.dump" i need to check "IF " the file name MATCH(contain) "KER01" then COUNT of values in filed with name "routing_category" needs to be captured in next sheet.

A sample file is uploaded ,kinldy help in res.

 

[prasaddn]

Hi,

See the file

This can be done with sumproduct() formula along with Mid() and left() formulas.

Regards,
Prasad DN

 

[Sreehari]

Thanks a lot prasad,

two more cases..

in the column "IMSI" in the attachment of output sheet if i need to take the count of digits start with 40419,40446,40495.. then how can i take .

Also instead o digits if its a word /characters then how the fomula can be modified say instead of 40419 the column contains some names like "Shari","HariS","HARISS","vishnu","partha"..and i need name contains only "hari"..

 

[Sreehari]

is ther any way we can take the count of matching range of digts

 

[prasaddn]

hi,

Pls post some more examples in file and upload with expected out put like you did in the original file.

Regards,
Prasad DN

 

[Sreehari]

Dear Prasad,

i had uploaded one file as required by you.

 

[Sreehari]

i had tried with some formula in the attached sample file,but not working.

kinldy help with correcting the same.

formula result and expected output are mentioned in the OUTPUT sheet.