Search:

Type: Posts; User: MikeGeno; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    105

    Speed up Pivot table Refresh time

    I have a workbook with a sales data tab that is 9 columns by 340,000 rows. I have 4 pivot tables all linked to the same data. 3 of the pivots refresh almost instantly as they do not drill down to...
  2. Re: Return a value using 2 criteria - Index and match?

    pgc,

    thank you very much this works perfectly!
  3. Return a value using 2 criteria - Index and match?

    Ive tried a few variations on index and match to return a value on 2 sets of criteria but am having issues.

    In the example below the user will enter the product family name in A2 and enter an...
  4. Replies
    4
    Views
    162

    Re: Complicated Lookup...

    You couldn't use HLOOKUP in this instance you would first have to unmerge the cells with the QTY and type the QTy in twice, and when you did the HLOOKUP it would always find the leftmost value and...
  5. Replies
    4
    Views
    162

    Re: Complicated Lookup...

    If I understand correctly you are trying to create a Vlookup to pull the values from the corresponding columns based on the Quantity?

    You could try a nested VLOOKUP for the column reference....
  6. Re: Caculate the most recent month a customer made a purchase

    Thank you everyone for the help most appreciated! All of the last 3 solutions worked and much easier than my 40 nested ifs.
  7. Re: Caculate the most recent month a customer made a purchase

    =IF(AS2<>0,AS$1,IF(AR2<>0,AR$1,IF(AQ2<>0,AQ$1,IF(AP2<>0,AP$1,IF(AO2<>0,AO$1,IF(AN2<>0,AN$1,IF(AM2<>0,AM$1,IF(AL2<>0,AL$1,IF(AK2<>0,AK$1,IF(AJ2<>0,AJ$1,IF(AI2<>0,AI$1,IF(AH2<>0,AH$1,IF(AG2<>0,AG$1,IF(A...
  8. Re: Caculate the most recent month a customer made a purchase

    It seems to always return the most recent column no matter what data is present.

    In some instances I may have an account with Sales in month 1, none in month 2, Sales in Month 3, and None in Month...
  9. Caculate the most recent month a customer made a purchase

    I have a spreadsheet with months listed chronologically across columns and customers listed down the rows.



    Customer Month1 Month2 Month3 Most Recent Month Purchased
    ABC
    BCD
    CDE
  10. Calculated Field Question - Count each value only once

    I have pivot table with 6 Columns

    Month
    Item Code
    Unit Sales
    Sales Dollars
    Invoice Price
    Price Increase

    I have 12 months worth of data so each Item code shows up 12 times in the data table...
  11. SUMPRODUCT with labels and values in the same column

    I have a spreadsheet that is laid out as below. I am looking at 30 product groups that repeat each of the rows below. I am trying to calculate the Total US GP Dollars.

    (Column C represents Year 1,...
  12. Replies
    6
    Views
    17,819

    Re: Unable to insert rows

    Never need to apologize for trying to help, I am always grateful for the great people on this board who spend their own busy time trying to provide help to those in need.

    I Appreciate you taking...
  13. Replies
    6
    Views
    17,819

    Re: Unable to insert rows

    So I copied a blank cell from a new workbook and pasted it into the last 5 rows of the worksheet then deleted them and it seems to have fixed it. Odd error.
  14. Replies
    6
    Views
    17,819

    Re: Unable to insert rows

    I dropped the code in and ran it but it did not fix the issue. This is very odd. I have had this happen a few times in the past but the deleting of all rows always did the trick. Any other...
  15. Replies
    6
    Views
    17,819

    Unable to insert rows

    I am having an issue using Excel 2010. I am trying to insert a row in one of my worksheets.

    When I attempt to do so I get an error:

    "To Prevent loss of data, Excel cannot shift non blank...
  16. Lock an index to the correct column based on a value

    Working on a file with 2 tabs where I need to use index to reference a value in the pivot table.

    I have a pivot table with months down the rows and item numbers across the columns. The Item...
  17. Replies
    3
    Views
    2,971

    Re: Unable to group pivot field by month

    Thank you, I forgot to convert the dates to numerics when I brought them in from my data (They were text). Works now.
  18. Thread: complex sum

    by MikeGeno
    Replies
    3
    Views
    259

    Re: complex sum

    Can you put in column D a MAX formula on each row that looks at columns B and C and then just do your sumif off column D and the text qualifier?
  19. Replies
    3
    Views
    2,971

    Unable to group pivot field by month

    I have a pivot table with dates in the row filter as listed below. I want to group by month. For some reason when I select one of the dates and try to click the Group Field button in the pivot...
  20. Replies
    0
    Views
    407

    Seasonal Forecasting multiple item codes

    I have been searching for a way to forecast out 12 months for my business that has various seasonality spikes. I have found a few very helpful methods that de-seasonalize the data and show a nice...
  21. Replies
    4
    Views
    497

    Re: Vlookup issue with asterik in value

    That works perfectly. Thank you so much for the help! This will save me many hours of going back and retracing my steps to make sure data ties out.
  22. Replies
    4
    Views
    497

    Re: Vlookup issue with asterik in value

    I've always left off the false, as long as you have the comma after the column reference it assumes false, has always worked for me reading it as false.

    I just added it to my formula try and I...
  23. Replies
    4
    Views
    497

    Vlookup issue with asterik in value

    I am wondering if there is a workaround for a vlookup issue I am having.

    I have a list of item codes, many of them contain an asterik.

    Here is an example:

    =vlookup(a2,d2:e3,2,)
    ...
  24. Replies
    4
    Views
    235

    Re: Can Vlookup do this?

    You can easily fill in the blank rows so that it will fit in a pivot friendly format.

    In Column B highlight all the cells from B4 to the bottom of your list.

    Hit Ctrl-G (Goto)
    Alt-S Special...
  25. Replies
    4
    Views
    235

    Re: Can Vlookup do this?

    Try a pivot table with the year in the page by field and then just select 2009 to see only those results
Results 1 to 25 of 130
Page 1 of 6 1 2 3 4