Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.14 seconds.

  1. Re: how to divide and unique names in to one slicer

    Use text to columns.

    Highlight the column with the data in
    Select Data then Text to Columns
    Click next
    Check Comma
    Select finish
  2. Re: how to divide and unique names in to one slicer

    I doubt many will want to open a zip file!
    Better if you post a sample and an explanation of what you are trying to achieve.
  3. Re: Formula to add values from two columns ingoring one if the other has an amount in it?

    You're welcome.
  4. Re: Formula to add values from two columns ingoring one if the other has an amount in it?

    That is what my suggestion does!



    <tbody>
    5
  5. Re: Formula to add values from two columns ingoring one if the other has an amount in it?

    Maybe

    =SUMIFS(D20:D250,F20:F250,"")+SUM(F20:F250)
  6. Re: How to add spaces to the both sides of text in a cell

    Is it always 4 spaces at the beginning & 7 spaces at the end?
  7. Replies
    6
    Views
    113

    Re: Require formula

    Or maybe

    =SUBSTITUTE(TRIM(SUBSTITUTE(A1,","," "))," ",",")
  8. Replies
    4
    Views
    98

    Re: Simple String question

    If they are always separated by | then you could simply use Text to Columns with | as the separator.
  9. Replies
    10
    Views
    410

    Re: Index Match, sum if or vlookup?

    Another way

    =SUM(OFFSET($C$1,MATCH($B$10&$A$10,$A$2:$A$5&$B$2:$B$5,0),,,MATCH($A$11,$C$1:$F$1,0)))
    Enter as an array with Ctrl, Shift & Enter



    <tbody>
  10. Thread: sum time

    by gaz_chops
    Replies
    6
    Views
    161

    Re: sum time

    This also works & is not an array formula

    =SUMPRODUCT(A1:A6+0)
  11. Thread: sum time

    by gaz_chops
    Replies
    6
    Views
    161

    Re: sum time

    You're welcome.
  12. Thread: sum time

    by gaz_chops
    Replies
    6
    Views
    161

    Re: sum time

    Try

    =SUM(A1:A6+0)
    Enter as an array with Ctrl, Shift & Enter
  13. Thread: sum time

    by gaz_chops
    Replies
    6
    Views
    161

    Re: sum time

    Have you tried to sum them? If they are entered as you show them then it should work.



    <tbody>
    00:00:15


    00:00:48
  14. Replies
    36
    Views
    831

    Re: Check if a cell contains same digits

    A non array formula

    =SUBSTITUTE(A1,LEFT(A1,1),"")=""
  15. Re: Connecting cells and flipping the data between two values

    If your data starts in cell A1, then try

    In cell B1 Enter =A1=FALSE
    In cell C1 Enter =B1
    In cell D1 Enter =C1=FALSE
    In cell E1 Enter =D1
    In cell F1 Enter =E1=FALSE
  16. Re: Count number of times a specific text appears in a string & range

    What is the criteria whereby the search value is counted, or not?
  17. Re: Count number of times a specific text appears in a string & range

    Try

    =SUM(--ISNUMBER(FIND(B1,A1:A3)))

    enter as an array with Ctrl, Shift Enter
  18. Replies
    6
    Views
    198

    Re: Array Formula Issue

    Try

    =SMALL(IF(($B$3:$B$26>=10)*($B$3:$B$26<=15),$B$3:$B$26),ROW()-2)
  19. Re: Sum if based on horizontal and vertical criteria

    Maybe

    =SUMPRODUCT(($C$1:$E$1=$A11)*($B$2:$B$6=B$10)*($C$2:$E$6))
  20. Replies
    3
    Views
    167

    Re: Countif, suproduct, etc. Formula needed

    You're welcome.
  21. Re: Calculation to have cell turn red or yellow

    You're welcome, thanks for the feedback.
  22. Replies
    3
    Views
    167

    Re: Countif, suproduct, etc. Formula needed

    In B1 enter 1, in B2 enter

    =IF(A2="","",IF(A2=A1,B1,B1+1))

    copy down range
  23. Re: Calculation to have cell turn red or yellow

    In conditional formatting, use

    For yellow
    =ABS(A10-C10)<=1

    For Red
    =ABS(A10-C10)>1
  24. Replies
    4
    Views
    268

    Re: I need to make Sum with 3 criterias

    With the information you have provided, it's not possible. Give more details of the data/structure etc.
  25. Replies
    4
    Views
    268

    Re: I need to make Sum with 3 criterias

    Try sumifs

    =sumifs(sum range, criteria range, criteria, criteria range, criteria)
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4