Recent content by premjeet

Thanks buddy, its works with awesome speed.

Please find revised sheet with mapped formull with reference. Hope it can help u to underestand. and thank for quick response.

Sorry, Forgot to attach the sheet. Please check. I was using array max along with if. But it hangs my system. So that i m looking a plain formulla instead of array.

Thanks for response, will u please give an example.

need a plain formulla for vlookup recent date without using array.

Thanks Bobhc.

Thanks Bobhc, Your array formula works very well for me. But i need last Non blank cell address.

Hi DaveT. Thank for quick response but that is not what i am looking for. As example i have a data A B C D E Result Should be 1 2 1 3 1 E1 1 1 2 C2 1 2 3 4 D3 Hope you understand..

Please provide formula to find last non blank row name.

Is that any other way to get result without using array formula ?

Sorry Colin i have putted this formula in column E1, It's working very well. Thanks for the help.

All the results are coming with "0"

Thanks Narayank, I have used the forensics formula. But what if one cell is blank. It showing error #DIV/0! message. WCDMA CDMA GSM GSM 3 GSM GSM GSM CDMA 2 GSM CDMA GSM #DIV/0!

I have a data as showing below chart. A B C D E Count of Operators.(This is Answer) WCDMA CDMA GSM GSM CDMA 3 CDMA CDMA GSM GSM CDMA 2 GSM CDMA GSM GSM CDMA 2 CDMA CDMA CDMA CDMA CDMA 1 WCDMA WCDMA WCDMA WCDMA WCDMA 1 I need a formula that can show how many operators are in columns as showing...

You are awesome thanks Suresh.