Search results

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.

Thanks SK it working very well. But for column A1 only. What i need to modify that above code work for all the data are in column "A".

I have a data in Column "A". I want a VBA Code for Text to Column. Column A Data : 1-1-LAM1,04/10/13 00:01:21,67.25 VBA Code Required for below format 1 1 LAM1 4/10/2013 00:01:21 67.25

Can you say what result should be displayed if , against Value-3 , you had the following data : Date 1 2 3 4 5 6 7 8 9 Value-3 0 0 1 2 5 3 2 1 4 Answer will be date - 1st.

http://i48.tinypic.com/2yz0ehs.jpg

Hi NARAYAN, Thanks Again but the above mentioned formula is not working. I am sending a sanp shot of excel. I need Exact date since my value coming "0" continuously

Hi NARAYAN, Thanks for reply. The answer should be like this. Hope you will help me. Date - 1 2 3 4 5 6 7 8 9 Value-1 0 0 1 2 0 5 2 0 0 = 8 Value-2 0 0 5 4 0 0 0 0 0 = 5 Value-3 0 0 1 2 5 3 2 1 0 = 9 Value-4 0 0 1 2 5 3 0 0 0 = 7

I have a excel sheet. I need a formula that can find what i need. I am not good in excel. So, Please help. Example. Date - 1 2 3 4 5 6 7 8 9 Value-1 0 0 1 2 0 5 2 0 0 = ( Formula Required ) Value-2 0 0 5 4 0 0 0 0 0 = Value-3 0 0...