Search results

I am not sure if this is what you need but here it is. I know just enough to get the information I want but my knowledge ends quickly on how to format. Should the "sorts" be the last thing done to the data? If I do the refresh in Power Query it holds and is the same each time but when I load it...

Sorry posted before I said thanks for your help and looking.

I used to use countif($a$2:a2,a2) to count and then number each occurrence of a number in a column but now need some help to get if done with multiple criteria. DESCRIPTION 4" BEGONIA-BADA BING SCARLET 1 4" BEGONIA-BADA BING SCARLET 2 4" BEGONIA-BADA BING SCARLET 3 4" BEGONIA-BADA...

When I do a refresh on Power Query the Sort I had in Excel goes away. If I do the Sort in Power Query it doesn't import that Sort to Excel. I don't think that Power Query imports or loads the information the same way twice. Is this just the way things are or am I missing something simple...

I modified your formula to this =IF(ISNUMBER(DATEVALUE(TEXT($A61,"dd-mmm-")&B$1)),SUMIFS(ARBatch[AMTENTR],ARBatch[Date],DATE(B$1,MONTH($A61),DAY($A61))),0) and it works! On all the years! Thanks so much for putting me on the right path. I really appreciate your time and thoughts. Lee

Sorry but it doesn't work either. It gives nothing but 0's down the column. Thanks for trying.

Excel 2013 Column A has the dates from January 1, 2012 to December 31, 2012 beginning in Row 2 formatted as 1/1, 1/2 to 12/31. Row 1 has the years 2012 to 2015 in columns B - E The sales data is in a separate table called ARBatch. I have this to pull in the sales data for each day copied down...

I found that some of the cells didn't have Data Validation in them and when it was applied to all cells in the column the new cells in that column now have the correct Data Validation. Thanks and sorry for the misinformation but you guys made me think and Luke was on the right path in that some...

I'm sorry it isn't conditional formatting it is Data Validation that isn't copying. It is from a Drop Down List from a range on another worksheet in the same workbook.

I have one column in Excel 2013 Table that isn't carrying the conditional format when a new row is inserted. The conditional format is a drop down list to choose an entry. Any help is appreciated. If the cell contents are copied using copy/paste then the formatting is there. Thanks, Lee

Thanks, I've used the file you refer to in some Power Pivot tables and I'm very thankful that he did that for everyone. I used it in my Power Query but still can't get Pivot Table to Group like a normal pivot table. It may be do to the merges that I have to do as it will not Group on any field...

Thanks for the reply but this is inside Power Query which is a .com add-in for Excel. I think the formula is something like from what I've found on Microsoft website but I can't get it to work. Date.FromText("2010-02-19") equals Date,YYYY-MM-DD Your formula works better if it is something like...

How can I change an international date type from SQL inside Power Query to an American date field? The data from SQL comes out as 20140620 and I want to change it to mm/dd/yyyy or 06/20/2014. Any help is greatly appreciated. Thanks, Lee

Is it possible to not have any orphaned rows when printing a Pivot Table report? Currently I use page break preview and manually adjust the page breaks so as not to have an orphaned row on the next page with its sub header and related rows on the previous page. This is ok if the report is...

I am fairly new to Powerpivot and need help in getting the average units sold per week as rows based on the number of years displayed as columns. The example below shows the years and the units sold per week for the item 4" Sq Pots. I'm wanting to create a new column that would have the average...

The query is listed below as it appears in Power Query. It was suggested that I try it because Power Pivot isn't available in Excel 2013 stand alone version yet. I change the date 20130901 to Sept 1, 2013 in the worksheet by putting it on the last column of the returned query. If I refresh then...

I have a Power Query that returns a date as 20130910 for September 10, 2013. I can get the date in Excel 2013 but every time I refresh the Power Query it removes my column or my query gets corrupted and I have to redo. The M. language is hard for me to follow and I can't find an example of a...

Thanks, there is a lot to take in. I will try to solve it on my end with the information you gave.

I want to insert the first cell in a filtered table column in the footer of a report. I found a vba code snippet from http://www.cpearson.com/excel/headfoot.htm to do the footer but I don't have a clue on where to begin with selecting the first cell in a filtered column. Thanks for any help. Lee

https://www.dropbox.com/s/9h48axi9oqte8c6/Production%20Schedule%202012%20Uploaded.xlsx I hope the link above works to the file. I removed and edited so all should work. I am using 2010 when I get the problem. When the file is opened in 2007 it works as normal. The # of Crops column is what...

Thanks to both of you for the suggestion. I4S089 4" IMPATIENS-SUPER ELFIN BR. ORANGE 1 OF 7 60 I4S089 4" IMPATIENS-SUPER ELFIN BR. ORANGE 2 OF 7 90 I4S089 4" IMPATIENS-SUPER ELFIN BR. ORANGE 3 OF 7 120 I4S089 4" IMPATIENS-SUPER ELFIN BR. ORANGE 4 OF 7 120 I4S089 4" IMPATIENS-SUPER ELFIN BR...

I have a table in Excel 2010 with the following in column C =IF(A834<>"",COUNTIF($A$2:A834,A834)&" OF "&COUNTIF([ItemNo],A834),"") When I paste a new block of items into the table it changes the formula to =IF(A835<>"",COUNTIF($A$2:A842,A835)&" OF...

Got around my problem by export inventory numbers and items to Excel and then manipulating the text in Excel so could relate in Power Pivot. It works and is really fast updating in under a minute verses several minutes in pivot table. Thanks to all for helping out. Lee

They are in 2 seperate tables within the power pivot window. OEINVD has the invoice details from the SQL database with the item description field with text 4" HERB-ROSEMARY-BARBECUE 4" HERB-ROSEMARY-ARP 4" DIANTHUS-MELODY ROSE The other table is PLANTGRPS that has the genus of the plant and...

ANTHERICUM ARTEMESIA BEGONIA MANDEVILLA MEGASKEPASMA PETUNIA THUNBERGIA AGERATUM ALYSSUM ASCLEPIAS BACOPA Sorry, I don't know why this column didn't post.