Search results

I'm trying to set up a power pivot to dump order data into a pivot table. When I go into Manage in the Power Pivot I can not find the existing connections set up. When Normally using excel and pulling in data I just go to data>from other sources>MS query and I can see the database connections...

solved. thanks for the help

No what I'm trying to do is be able to update pricing on an export sheet from the system. Sheet 2 has the pricing and qty breaks I need to move over but it has to be in a vertical fashion on the sheet. My orig formulas worked on the sample sheet(the 2nd uploaded doc I provided) but when I made...

Here is the orig to be able to compare to. Maybe someone can figure out where I went wrong in the tweaks I made to screw it up.

also posted at http://www.excelforum.com/showthread.php?t=1129480&p=4331119#post4331119 http://www.mrexcel.com/forum/excel-questions/925989-help-editing-existing-transpose-code-index-match.html#post4450494

example file. sheet 2 is 9,624 lines in the real file I'm working with.

Please help me edit this code to fit the sheet. Having problems after making some changes to the sheet and it won't work now. Field column DE...

solved. thanks for all the help. really appreciate it.

Please help me be able to transpose the data in the workbook I attached. One sheet has what it would currently look like (in the actual file it's about 3,000 lines) and the 2nd sheet shows how I'd like it to look. Also posted this at...

If I have a chart with state - city - orders how can I map it on the power index so that the number of orders at each city show up on that city instead of a pie chart being put in each state with a breakdown of orders within that chart? Also, is there a way instead of having a color coded chart...

I did ask questions...not sure what your talking about buddy

I try to go back and post something if the problem has been solved where people were asking me questions and trying to help with the problem here is the solution I was searching for that I've been testing all morning to make sure there aren't any holes and to cause any changes Option Explicit...

so aren't you being a hypocrite saying people shouldn't waste their time answering questions to a user who visits multiple forums when you yourself are doing the same thing otherwise you wouldn't know if I posted anywhere else...interesting thanks for all your help buddy

wanna try what?

Is that against the rules to search out your answer in multiple places???

I did de dup it already....each email has unique customer data to it and I'm trying to combine all of that data at the email level so that are no more dup emails in the sheet. So I de duped it in sheet 1 and in sheet 2 is where I used the countifs so to combine the customer data at the email level

I have an excel spreadsheet where I have duplicate email accounts with customer data. I'm trying to combine the customer data at each email account so that I can remove the dups and consolidate the customer data. Currently I copy the emails over to a 2nd sheet and de dup. Bring over the...

I can't post the actual worksheet it has customer data in it. When I did what Luke was talking about it eventually gets an error about not having enough space to complete the action of trying to count each column because the file is so big.

I think you requested a sample workbook so I attached one...if not could you restate that I wasn't sure

I tried it using a pivot table but because the file is so big I keep getting errors because how big the file is and not having enough resources to complete the action. I have about 200,000 emails in this and approx 17 fields that need to be counted at each email so it's definitley a big file...

pretty interesting idea...never thought about doing it that way. thanks

If I have a table that looks like: emailcustomer numberapples trees sports ice cream abc@yahoo.com123 YY Y abc@yahoo.com126 123@gmail.com858 Y 123@gmail.com767 YY owow@yahoo.com444 Y owow@yahoo.com455 999@yahoo.com1001 Y Y 999@yahoo.com1103 Y 999@yahoo.com 1005 Y How...

I have a pivot table and I'm using one filter on it with thousands of keywords to look at sales data for them. Is there a way in that filter when I am searching for a keyword to be able to do a AND or OR search so that I can pull multiple different keywords at once without them being in the...

absolutely...just attached what I would like the final outcome to look like

I'm trying to make a new macro for the changes in my data set to transpose my data. I attached an excel file so you can see how it looks currently. I would like it so that each item only occurs in one single row and the data is then going horizontal across the page.