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