Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    8
    Views
    363

    Re: Easy way to format

    That format should exist in the format cells dialogue box (ctrl+1). Otherwise you could create a custom format (located under the "custom" category in the Format Cells Dialogue box)

    Otherwise you...
  2. Re: #REF! error when copying the formula from 1 column to the others

    When You select the cell, in the formula bar, what reference is giving you an error(#REF)? If you're only moving to other columns (and your rows are the same), I'd guess the J$1 is giving you the...
  3. Replies
    1
    Views
    99

    Multiplying Row's of an Array

    Hello,

    I'm using a formula to basically create an Array that looks something like this:
    {1,1,0; 1,1,1; 1,0,0; 0,0,0}

    and i'm trying to turn it into this:
    {0;1;0;0}
    by multiplying the rows...
  4. Formula: Cell Contains Every Value in Range

    Hello,

    I'm trying to create a formula that bounces a cell string ("Lookup") off a list of rows. If all cells within a row of "terms" is found (anywhere in the entire list of terms), then I want to...
  5. Replies
    2
    Views
    280

    Re: Data Validation Multi-Select

    Instead of doing data validation, have you considered doing this in a pivot table?
  6. Replies
    5
    Views
    108

    Re: Nested UDF Formula Returns Value

    Sorry for the late response. Entering it as an array fixed it (although I was fairly sure I had tried that already). Thank you very much for your help.
  7. Replies
    5
    Views
    108

    Re: Nested UDF Formula Returns Value

    So I think the problem might be with the using the zcut in a parameter for any kind of formula. because
    =Max(zcut(transpose(A1:A10)))
    =Sum(zcut(transpose(A1:A10)))

    Also returns a "#VALUE" error....
  8. Replies
    5
    Views
    108

    Re: Nested UDF Formula Returns Value

    ZCut


    Public Function zcut(arrIn As Variant) As Variant
    Dim tval As Variant
    Dim arrOut As Variant
    Dim i As Integer
    Dim j As Integer
  9. Replies
    5
    Views
    108

    Nested UDF Formula Returns Value

    Hello,

    I'm running into an interesting problem when I go to make a nested formula with 2 UDF's. I get a #VALUE error even though it seems like everything is evaluating correctly.

    Quick...
  10. Replies
    5
    Views
    321

    Re: Automated Timecard Calculations

    Ah...I see your problem now.


    <tbody>

    A
    B
    C
    D
    E
  11. Replies
    5
    Views
    321

    Re: Automated Timecard Calculations

    Excel 2010
    <colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>

    A
    B
    C
    D
    E
    F
    G
  12. Re: Using a pivot table calculated value in a formula

    I'm not sure that I follow. But it seems to me that you could just add your calculated field a second time and use "summarize values as" > "% of parent total".
  13. Replies
    1
    Views
    120

    Re: Filtered Data Not Showing

    Either separate the data manually. Or filter the data within the pivot table with pivot filters. The later is more sensible. There's no way to have a pivot table look at visible cells only.

    In...
  14. Replies
    1
    Views
    2,159

    Conditional Running Total

    Hello,

    I am trying to figure out a formula that will give the the running total sum of a list of data for descending dates, but stop once the running total (of 'X') hits a certain number (say...
  15. Replies
    3
    Views
    312

    Re: Adding an extra Function

    Seems like you're asking 2 different questions.


    With ctrl+shft+enter:

    =IF(sum(len(B19:D19))>0,IFNA(INDEX(Quote!$A$13:$A$31,MATCH($E$18,Quote!$B$13:$B$31,0)),0),$C19>=1)
  16. Replies
    7
    Views
    665

    Re: Multiple VLOOKUP formulas in ONE cell

    Indirect converts a string into an actual range
    So if A1 contains: T_1
    then
    Indirect(A1)
    looks at the named range "T_1"
  17. Replies
    1
    Views
    219

    Re: =if(count(search({ help

    So just write that condition into another if statement:

    =If(C2="Early","",IF(COUNT(SEARCH({"late","missed"},A1)),"LATE",""))
  18. Replies
    7
    Views
    665

    Re: Multiple VLOOKUP formulas in ONE cell

    It looks like you're missing a parameter and parenthesis
    =IF(ISBLANK($B$2)," ",IF($B$2="T_1",VLOOKUP(C1,T_1,2,False),IF($B$2="T_2",VLOOKUP(C1,TBL_S_2,2,FALSE)))))

    However, This is a good use for...
  19. Replies
    3
    Views
    178

    Re: Run macro in another book (diffeent)

    You can save your macros as a .xla file(excel add-in flie), and then plug it in as an add in. Your macros should then be accessible in any excel document.
  20. Replies
    1
    Views
    201

    Re: Months showing in pivot table

    *Misread the post*
    I originally misread the post and posted an incorrect solution.

    I don't have 2016 but I found a few things that may be of interest.

    My understanding is that you can remove...
  21. Replies
    6
    Views
    1,276

    Re: Maxif without array

    I don't think an array formula would cause too much of a performance issue. I would imagine a column reference could potentially slow you down, have you considered using a dynamic named range?
  22. Re: Quick question about answer question on pop ups during running macro

    It's hard to tell with the given information. I don't know what kind of prompt it is or where it comes from. With the lack of information, I guess the easiest solution I could think of is to...
  23. Replies
    1
    Views
    83

    Re: Insert column in pivot

    You can't. Your best bet is to create a calculated field(that contains your formula) and add that field to your pivot table. That or place your formula next to the pivot table.
  24. Re: PIVOT TABLES- How to count the number of people who answer the same thing for multiple topics-PLEASE HELP ME CRACK IT!

    My understanding is your base data looks like what you've provided. But you'll need a column header for the first column
    Try this:
    1. Alt then D then P
    2. Select "Multiple Consolidation ranges"...
  25. Re: Combining LOOKUP and OR (in lookup_vector?)

    Try:
    =IF(A3<=A$1,LOOKUP(2,1/(or($B$2:B2<>{"n","x"})),$B$2:B2-1),"")
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4