If you are using Office 2007/2010 you can use SUMIFS() function. Or the easy solution is to add a new column in the front say Column A and then your from data from Column B for Flower/Size/Price. The column A will have the unique value based on the " & " operator. Basically =B2&C2...this will...
Hi- I am Dibyendu, have joined this forum to discuss problem related to excel/vba & now Powerpivot. A student of Chandoo's learning university. As a profession I working with Operations, Aanlysis & strategy. Have been a fan of excel since my first job but still today seems lot to learn. Here to...
Hi SirJB7- Thanks for your reply, point noted on the Excel forum rules and other aspect of this beautiful forum.
Regarding my questions and your response. I am looking for the value 2 for Employee number 1234567 since the last time booked by him was 6.1.13 so this would be his latest Unique...
Hi All - everyday now and then I have to check for the latest values and the latest item where someone has booked his/her timesheet. They can book under x number of unquie IDs which can also be used by n number of people. The idea is to find the last used unquie ID and related details of that ID...