Search:

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

Search: Search took 0.00 seconds.

  1. Thread: Pivot Charts

    by kurtisw
    Replies
    2
    Views
    136

    Re: Pivot Charts

    AFAIK you will need to setup a separate pivot table for each chart. The way I do it is setup my first table with all the information that I will need, add the the slicers and my first pivot chart. I...
  2. Replies
    2
    Views
    140

    Re: Using either vlookup or IF function

    Using Marcelo example and your data is formatted as a table the following should work as well.

    =SUMIFS(Table1[Pallet Quantity],Table1[Date],A3,Table1[Inbound/Outbound],B2,Table1[Part Code],B1)
  3. Replies
    5
    Views
    173

    Re: How to convert date to Month/Year only

    Assuming the date is in column A you can use one of the following formulas in the new column,

    to get the month number use =MONTH(A1)
    to get show month full name use =TEXT(A1,”MMMM”)
  4. Replies
    6
    Views
    441

    Re: Hyperlink & Vlookup formula

    What version of Excel are you using ?
  5. Re: Find last blank cell in a row and use value two cells prior

    Would this meet your needs?

    =ADDRESS(2,MATCH(TRUE,INDEX(B2:Z2="",0),0)-2)
  6. Replies
    6
    Views
    441

    Re: Hyperlink & Vlookup formula

    Can you place this formula in C2?

    =HYPERLINK("#"&CELL("address",INDEX(Sheet2!$A1:$B3,MATCH($B2,Sheet2!$A:$A,0),0)),$B2)
  7. Replies
    6
    Views
    441

    Re: Hyperlink & Vlookup formula

    Since you are attempting to reference the same cell that you are wanting to place the formula in you will need to reference the actual text value you are searching for.

    Place the following formula...
Results 1 to 7 of 7