Search:

Type: Posts; User: Special-K99; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.26 seconds.

  1. Re: Code Particular Strings As Numbers, Then Sum Numbers

    This works based on your somewhat vague description, cos I can see you expanding your request and this no longer working, so your description isn't specific enough.
    But this will work on what you've...
  2. Replies
    1
    Views
    27

    Re: Move Columns

    Formulas cannot change other cell values.
    Formulas can read other cell values and calculate results from that.

    Specifically what are you trying to do, what are the formulas you start with and...
  3. Replies
    1
    Views
    9

    Re: VBA to Javascript

    Well if you wrote it, you know what it does and how it works.
    So shouldn't this request be in a Javascript forum?

    That's like writing a story in French, wanting to translate it into German, but...
  4. Re: Total Empty column between two characters

    in A1
    =IF(AND(A2="",B2="A"),COLUMN()-MAX(IF($A2:A2="A",COLUMN(($A2:A2)))),"")
    Array formula, use Ctrl-Shift-Enter

    copy along as far as AA1
  5. Replies
    1
    Views
    28

    Re: IF statement

    Remove the brackets around S80, you don't need them

    Do you mean this, it's not clear.

    =IF(Y80<>"","",IF(S80<>"",S80+41,""))
  6. Replies
    5
    Views
    100

    Re: How to get the earliest time by row

    Fred Responded 15/07/2019 08:30 Delivered 15/07/2019 09:30 15/07/2019 07:30

    Why is the result of this 07:30 ?
    There is no 07:30 in that row
    The earliest is 08:30
  7. Re: Finding number between range of numbers?

    Why not just use Ctrl-F to find the number?

    You need to specify clearly where the numbers are - are in they in a column? Which column? - are they in a row? Which row?
    What cell are you storing...
  8. Replies
    5
    Views
    38

    Re: Sumproduct and if statement

    if you mean OR then

    =SUMPRODUCT(((Statement!$J$1:$J$1724="Subscription Fees")+(Statement!$J$1:$J$1724="Income")) *(Statement!$L$1:$L$1724))
  9. Replies
    5
    Views
    38

    Re: Sumproduct and if statement

    Where column J is "Subscription Fees" AND "Income"

    How can something be 2 things at once?
    Do you mean OR ?
    Do you mean

    Where column J is "Subscription Fees" OR "Income"

    "There is another...
  10. Re: How to display data from one sheet if blank or another if filled

    Remove all $ from the formula
    You dont see any $ in my formula do you?
  11. Replies
    12
    Views
    163

    Re: "double" INDEX & MATCH search?

    "See attached test"

    FYI
    You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

    https://www.mrexcel.com/forum/about-board/508133-attachments.html
  12. Replies
    10
    Views
    201

    Re: Transpose Data to Create new table

    I doubt I'll answer this as I'm busy at work but

    in the New Table

    why does 2400 appear in the 31-60 column for All-Good 11/26/2018 ?
    The value is 7200 which doesn't appear ANYWHERE in the New...
  13. Replies
    5
    Views
    227

    Re: Index match

    Is this a typo ???

    =INDEX(K27:N27+MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

    It should be

    =INDEX(K27:N27,MATCH(H28,J28:J33,0),MATCH(H29,K28:N33))

    For subsequent dates you'd be better off...
  14. Replies
    4
    Views
    59

    Re: Detect fill colour in cells

    I'm not an expert on VBA and certainly haven't delved into the "detecting colours" side of VBA :(
  15. Replies
    3
    Views
    89

    Re: Miscounting in column T

    No it doesn't.

    You have the value 151 in K3, that plus a non zero value in E3 counts as 2.
    Excel is correct.

    Column K has data that you haven't displayed correctly.
    Change the colour column...
  16. Re: If Column X contains specific text in Column Y then SUM Column Z

    1. Lacking in example data, so this may not work, more test data = more accurate solution.

    2. Your subject says SUM Column Z.
    There is NO column Z in your example data.

    To set column D to...
  17. Re: Excel Transpose (T) From Column to Row specific position.

    Here's a formula solution, you will have to make adjustments on this as you have not supplied any cell reference data.

    This assumes the following

    Your original data is in A$2:A$1000, adjust...
  18. Re: Excel Transpose (T) From Column to Row specific position.

    That does not answer my question.
    Do you want a formula solution or VBA (I will not be able to help with a VBA solution as it is not my area of expertise).
  19. Replies
    10
    Views
    161

    Re: Hanging, Not Responding

    "I enter data and go to another cell to enter more data. Excel is frozen at this point and won't accept any mouse click or key entry. The bar at the top of the screen says the file name followed by...
  20. Re: Excel Transpose (T) From Column to Row specific position.

    Questions

    1.

    Will each element of data ALWAYS have FOUR rows then ONE blank cell separating them.
    FOUR rows = A, 123, 456, 789
    then one BLANK row.

    Is this ALWAYS the case or could it vary?
  21. Replies
    4
    Views
    59

    Re: Detect fill colour in cells

    How is it "already have shading"
    If manual shading then you have to use VBA to detect the colour of the cell, you would not be able to do this via Condtional Formatting.
    If you're saying the cell...
  22. Replies
    6
    Views
    73

    Re: separate something in a cell.

    Or use a helper column

    in B21
    =SUBSTITUTE(A21," > ","")
    then use Text To Columns with a separater of m
    This assumes that m will always be in the cell between the > signs

    One piece of data...
  23. Replies
    4
    Views
    112

    Re: SUMIFS - 2 conditions, 1 column

    =SUMIFS(A:A,C:C,E1,B:B,"whse 1",B:B,"whse 2")

    This is an AND condition
    SUM column A if column C equals E1 and column B equals "whse 1" and column B equals "whse 2"

    How can a cell in column B...
  24. Replies
    3
    Views
    61

    Re: Adding Logic to an Existing Formula

    in P161
    =IF(D161<>"",D161,IF(ISERROR(VLOOKUP(O161,'G-Block CMO-FMO and IP Ranges '!$A$61:$G$400,2,FALSE)),"",VLOOKUP(O161,'G-Block CMO-FMO and IP Ranges '!$A$61:$G$400,2,FALSE)))
  25. Replies
    6
    Views
    189

    Re: Index/Lookup

    You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

    https://www.mrexcel.com/forum/about-board/508133-attachments.html

    Or upload the file to an...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4