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...
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...