Recent content by maku

Yes...you can. see attached in tab Results (2). You will see it is identical to the results tab that used a pivot table. You can use the index function and sumifs to find and tally your data. Happy Thanksgiving. http://speedy.sh/yCaYx/Excel-Query-without-pivot-table.xls

Have you thought of using a Pivot Table? It will organize your data nicely and makes it easy to retrieve data. Have a look and see if this is something like what you're after: http://speedy.sh/yCCYx/Excel-Query-with-pivot-chart.xls

Yes! Thank you! Thank you! Thank you! It works exactly as I hoped. I will integrate it into my workbook, but I don't foresee any issues. I am going to research the other two methods just to learn :)

Thanks for responding SirJB7. The answers to your questions are: The year/quarter will always be found as the data that is generated on Sheet 1, (C2) is derived from analyzing other items pulled from Sheet 2 from that corresponding year/quarter. After it is derived on Sheet 1, I want the VBA...

I'm sorry you've reached your maximum limit for help today. just kidding. try: {=IFERROR(INDEX(InventoryNum,SMALL(IF((Status=$C$47)*(Category=$D$47)*(Stream=$E$47),ROW(Status)-2),ROW(A1))),"")}

If your data is not sorted...this will find the last deal in unsorted data. =IF(IF(COUNTIF($A$2:$A$39,A2)=1,TRUE,COUNTIF($A$2:A2,A2)=COUNTIF($A$2:$A$39,A2))=TRUE,"Last Deal","")

I think this will work...if the data is already sorted by account name as in your example. =IF(C2=2,"2nd Deal in account",IF(C3>C2,"","Last Deal"))

Luke M...my favorite ninja...glad you're back :)

I'm not positive, but is this what you are looking for? See Sheet 2 on file. http://www.speedyshare.com/zGg4p/Example-with-dashboard.xlsx If so, just use an array formula..make sure to hit CTRL-SHIFT-ENTER when you enter the formula...

Hi Kanti. This code copies data from Sheet 1 and overwrites all data on Sheet 2. I only want to post one cell of data from Sheet 1 to Sheet 2, but based on criteria. What I need is, the code to determine which row the data cell from Sheet 1 (cell C2) in this example should be placed in Sheet...

kchiba...unfortunately that won't work, as sheet 1 is a page that constantly updates and changes based on drop down selections.....kind of like a dashboard. That's why I need a VBA method to add to my existing macro that updates on event change, etc on that page.

I just made a pivot chart...actually two because your data fields aren't consistent. Then lined up the columns 2011 and 2012 and made the bar chart. You don't have to do pivot charts though, you could simply copy and paste the customers and the totals for 2011 and then make a column 2012 and...

Take a look at this and see if it is what you are looking for...tab Chart. http://speedy.sh/Tw6wS/Charting-Query-compare-2011-vs-2012-with-chart.xls

I think you will have to use copy/paste and paste with special selection of VALUE. You can use a macro to do this when you create your original quote the first time. Upon subsequent modifications to that quote, do not run the macro. Using my method, you would need three cells located somewhere...

Blair, you can always search by your name in the "google custom search" field. Probably easier though, is login to Chandoo. Then click on your name (just to the right of the Chandoo logo at the top of the page). Once you click on your name, you will see the topics you started and were...