Search results

I have a large spreadsheet with a lot of data and columns. I have a pivot table to sum all that up however I want to flip all the signs in the pivot table. Meaning 300,000 should show as -300,000 and then say -6,667 should show as 6,667. Is that possible. I used the pivot table formatting...

That one didn't work. Could it have to do with my filter being in the Report Filter of the pivot table? When i normally click the filter at the top of the pivot table i can only select one or multiple items from the drop down. I can't use the Contains or Greater then option like you can in the...

I have a pivot table with some filters at the top. I would like to use VBA to filter the pivot table by the word in cell A1. I can do this, my only issue is I would like to Filter by Contains in the word A1. Example is the items in the pivot table fiedl are: Andrew, Lori Andrew, Tim, Lori...

That worked. I didn't think to break it up like that. Thanks.

I have some data that has items like Red Pen, Paper, Blue Pen etc. I want to do a SumIf based on contains a word like pen and i have this formula that works ok. =SUMIF(D4:D11,"*Pen*",E4:E11) My issue I don't want to have a hard coded word in there like Pen. I want to have a drop down in Cell...

I'm having an issue with declaring the last row # in my macro. I have a macro with this and it works but it doens't work 100% the way I want it to. I have this to get my last row. LastA = Range("D21").End(xlDown).Row Then I have this to select some cells and do some other functions that work...

I see what you are doing there now.

So I have to go to TabABC and cell B3 which contains my data. Cut that, and Paste it into Combined Cell A2. Then go to TabXYZ and cell B3 and Cut that, and paste into Combined Cell A3?

Still doesn't help. I think I left the part off that they are on the same tab. This might be better. Tab Name = Combined B3 ='TabABC'!$B$3 B4 ='TabXYZ'!$B$3 B5 ='TabMMMMM'!$B$3 So if I was to copy B5 and paste into b6 it would read ='TabMMMMM'!$B$3. that is the same formula...

Not really. In Cell B3 I have the formula of ='TabABC'!$B$3. And in B4 I have the formula of ='TabXYZ'!$B$3, in cell B5 i have ='TabMMMMM'!$B$3. And I want to do that all the way down to row 48. How can you automatically update the tab name reference in each formula? You can see i'm...

I have a file with 48 tabs of data on it. I want to combine the data into 1 organized tab. (Yes I know it should have been that way from the start but I didn't create the file) I have sevearl formula's in all the cells in row 3 that are linked ='TabABC'!B3 and ='TabABC'!B4. Now each row I...

That works perfectly. In some trials I was doing before, I didn't have the MIN in the front of the formula but rather in the middle. Thanks for the help on this. I understand the formula now seeing it and reading it.

That is a start. It's missing another piece using Column B though for Type. I see the formula in cell H8 that you have. But what if it's the Min of both Paris, 1 Bedroom and Group B. Is there a MINIFS formula to use? I see this part F($A$3:$A$11=$G8 where is't looking in Column A to match it...

See if this works. City Type Group A Group B Paris 1 Bedroom 1 67 Rome 1 Bedroom 2 34 Rome 1 Bedroom 45 23 NYC 1 Bedroom 12 78 NYC 2 Bedroom 56 56 NYC 2 Bedroom 23 34 NYC 1 Bedroom 78 23 Paris 1 Bedroom 23 45 Rome 1 Bedroom 23 67 Looking for: ' Type 1 Bedroom Group A Min Max Avg...

I've learned a lot about the Index Match formula on this site from articles and some questions. I'm stuck doing something like this below and wonder if it can be done. I have a data tab with Column A is City, Column B is Type, Column C is a price for Group 1, Column D is a price for group 2...

I used the Hui Rollover Technique learned on this website before to change all my numbers on a file based on what I hover over. Also I've used just the radial buttons to change data also. My question expands on that and is this possible in excel 2010. Let's say I don't want to change all my data...

would the IF statement slow the calculation down at all if I have about 3,000 formula's on the tab?

I have this formula below to return me sevearl rows of data from a specs tab based on what ID is in a cell (C7, D7, etc for each column). It works great except for 1 thing. If the field I am returning on the Specs tab is blank, this formula puts a 0 instead of returning the blank. Is there...

Perfect thanks. The 2nd one with the 4 MMMM worked.

I have 2 cells. A1 contains a Category (Facilities), and A2 contains the date (September 14, 2012) when a I a formula to combine them together with some text, the date comes out as 41666 instead of Septeber 30, 2012 in the text. =A1&"as of"&A2 gives me Facilities as of 41166. How can it...

Thanks. That worked great. I just started using the Worksheet Change Function in my files. Good to know about ActiveSheet.Range for those functions.

I have this simple code below. It's using the worksheet change function and everytime the value in D2 is changed, then the pivot table gets updated and then I want to select a cell on another sheet. The code works great in the begining but the error is when I try to select Sheet2 then Range B1...

How do I call that macro to run? If cell AB4 changes from say 1 to 3, I want to do that pivot table refresh line code. Then later if cell AB4 changes from 3 to 17 same thing, refresh the pivot table. Anyway to do that without a trigger?

Can a pivot table be updated via code whenever a cell changes a value but the value is not changed by any button pushing or click event? I've utilized the Hui rolloever technique for charting from the chadoo site with the Hyperlinks to change the charts. I built extra steps off that hyperlink...

Thanks for the help. Both files worked. One thing i noticed is when I was using the table, even though I'm in Excel 2007 the file was a .xls file and said Compatitabiliy Mode at the top. The pivot table options are grayed out for contains. I converted the file to .xlsx and the options became...