Search results

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

I'd appreciate any help for this. I want to post the data from one cell on a worksheet to a new column on a worksheet. The tricky part is, the data needs to be posted on a specific row based on 2 criteria (year and quarter). Example: Worksheet 1 - Has the criteria and data to be posted...

Yep..problem solved :) the above array formula works and allows a TEXT result.

I'm not sure...if you are trying to identify unique values, you can use this formula: =SUMPRODUCT((A1:A21<>"")/COUNTIF(A1:A21,A1:A21&"")) But that returns 11. There are 21 unique values, so this must only count out to a certain digit. Maybe the experts know?

A formula that works is: INDEX(C1:C4,MATCH(1,(A1:A4="x")*(B1:B4="y"),0)) Where: column C is the data wanting to be retrieved. Column A and B are criteria being matched. *Note..must be entered as an array (CTRL-SHIFT-ENTER)

Deb...that's actually a little different function I think than what I'm trying to achieve. Your example searches for a text string. I'm looking to return a cell value based on multiple criteria. It works if the cell value is a number, but apparently not if TEXT. My current formula is...

Thanks Deb...I'll give it a shot and let everyone know.

I successfully use SUMIFS formula to with INDEX(MATCH) to return a result from a specific worksheet that matches the multiple criteria in the formula. I just tried to pull in a result that is a text value and not numerical. It returns a "0". I have formatted the cells using different...

Luke...I changed the droprange and tied it to the sheet that ultimately selects the property from the list. (there are a couple places use that, and some use VLOOKUP to pick that number to the corresponding name). Anyways, by changing that, it did change the name and half the data on the...

Cacos...I'm definitely not one of the excel experts around here, but I had the same issue with my lists with multiple drop downs. I had to make a helper column to achieve this. Then I used this array {enter with ctrl-shift-enter} formula to erase and reorder the list and erase the blanks...

Well...this is a start...which is farther than I was :) It didn't quite work. The data is pulled mostly from the report card sheet I'm trying to pull via INDIRECT. But, some data goes to a parameters page, which identifies which list should be made and that uses VLOOKUP. I do have a list...