Search results

Wow! thats awesome. Thanks Khalid :-)

thanks ... Is there an easy way to apply Ctrl+Shift +Enter for the rest of the rows in the range? I have some 10000 rows running?

Hi, I need a combination of lookup and max formulae. In a range, I want to find the maximum value of a particular cell. In the table below, each ID is at a different stage. I want a formula that can return the highest stage number for that ID. This is a simple table, while my data is huge. and...

Hi Praves, Sum product would be a good option. You can use more than 2 conditions. Check out Chandoo's post on Sumproduct, in the link below: http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/ Regards, Mano

Dear all, I am Mano and working as an analyst. I am trying to build a report for sales renewals. I have uploaded a sample of the worksheet here: https://docs.google.com/spreadsheet/ccc?key=0AgTAsAjMNn7FdHF3anJ6SERZaXdORzdzeFdqWGY1WlE Eg: Each planet has n number of customers, who renew...

@Hui: Yes I did go over the link,but it kind of went over my head :-P .... I used Luke's solution of using the condition to get the number. Thanks!

Sum product would be good!

Somehow the function doesn't work on conditionally formatted colors...

Dear Hui, Thanks a bunch... Awesome !! and to think I spent half a day on this ;-) Have a fantastic vacation :-) - Mano!

Hello Hui, Thanks for the Summ function. Is it possible to have the same function for Count. I have tried the UDFs (from the references above) but somehow they dont work in my workbook (unlike the simple summ function provided by you) :-) @Chandoo: Thank you for this wonderful blog and the...