Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Thread: Updating charts

    by levy77
    Replies
    1
    Views
    77

    Updating charts

    Hi

    I currently have data on stocks, next the the stock price I have indexed it to a certain date which I can set. I have then graphed this data on a line graph. I'n trying to find a way to have a...
  2. Re: Counting Data "Sold" Ignore Duplicate Number

    Hi

    Does this help?


    <tbody>
    1
    Sold
    1
  3. Re: Creating a digital In/Out accountability tracker...setting status to in/out automatically

    Can you provide a sample spread sheet?
  4. Re: Index function with variable range reference

    <tbody>

    <tbody>
    Personnel Type

    </tbody>

    B
  5. Re: Index function with variable range reference

    Could you merge rows 6 and 7 together (will have to use the offset function) and base the index match off the merged rows?
  6. Re: Search for a value and return the row and column

    All values will be unique, if I have accidentally put one in which is the same I hope an error appears.

    Thanks daz, I ended up making a formula which is...
  7. Search for a value and return the row and column

    Is there a way to search for an exact match within an array of data and return the row and/or column of the match? The formula is to go in cells B2 and B3 in the first table.



    <tbody>
    Search...
  8. Re: Question with 3 or 4 condition Vlookup & Index Formula

    That's true. Good pick up! Thanks for that
  9. Re: Matching given month to a column containing the same month

    Hi xlmaz,

    Have row one in the working sheet equal to the launch month day. The row below that enter the formula =DATE(YEAR(A1),MONTH(A1),DAY(A1)+1) and drag it down. Whenever you update the launch...
  10. Re: Question with 3 or 4 condition Vlookup & Index Formula

    How does this work ngh?

    https://drive.google.com/open?id=1Me6bobVENQfGC6zk-lT2xzUIqNEZa_uB
  11. Re: Question with 3 or 4 condition Vlookup & Index Formula

    Hi ngh,

    A simple solution would be to add a column next to your first table with the formula for that being; =A3&B3&C3 and drag that down.

    You can than do an index match and reference that...
  12. Replies
    4
    Views
    203

    Re: Finding a value in a specific row

    Hi Whiox,

    Check the sheet I have attached. The formula I used is;
    =INDEX($B$2:$F$366,MATCH(DATE(YEAR($A$2)+$I$2,MONTH($A$2)+$J$2,DAY($A$2)+$K$2),$A$2:$A$366),MATCH($I$3,$B$1:$F$1))
    Select the...
  13. Replies
    3
    Views
    159

    Re: cleaning/formatting data

    Perfect, thanks!
  14. Replies
    3
    Views
    159

    cleaning/formatting data

    Hi

    I want to get live data from a buoy which come in the form of an online text file (it can be seen by clicking on the link below).

    I want to import this data and end up having only the data...
  15. Replies
    7
    Views
    337

    Re: Need help matching data

    Here is the sheet Rocco https://drive.google.com/open?id=1-hGyljVDfptA9M1qjlABBhkn1aTIfUUl
  16. Replies
    7
    Views
    337

    Re: Need help matching data

    Hi Rocco,

    I used a vlookup to return the vale of the order from list 2 and put that value next to list one. I then used a simple If function to return "Yes" if they were the same and "No" if they...
  17. Replies
    3
    Views
    141

    Re: Reference Column Starting At Lower Cell

    Can you give an example? Having a hard time trying to work out what you want
  18. Replies
    6
    Views
    261

    Re: Generate Summary Paragraphs

    You could look at having a sheet with all your return values then use a lookup function. As per the example below.

    <tbody>
    Number
    Result

    Days

    Output
  19. Re: Calculating the average handling time to complete a task

    I have just had a play around with this formula and it is a great way of going about the problem. However, I could not get it to calculate the days between if the EOI was the previous month to the...
  20. Re: Calculating the average handling time to complete a task

    I took a slightly different approach but very similar to above. Mine just adds one extra column than above.

    https://drive.google.com/open?id=1n0UoQQLi6FqAbCE9S67nn-n3um18cQKe

    Any feedback...
  21. Replies
    1
    Views
    125

    Re: Estimate Work Orders Per Year

    You could look at using the =FORECAST() function, this may not be that accurate for what you want but worth a try I suppose.
  22. Replies
    13
    Views
    644

    Re: Sum Numbers up to Number in Top Column

    Try =IF(B$2<>0,IF(AND(SUM(B$2:$C$2)<sum($b$3:$b3),sum($c$2:c$2) style="color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">=SUM($B$3:$B3)),$B3,""),IF(SUM($B$3:$B3)<=C$2,$B3,"")), it should...
  23. Replies
    13
    Views
    644

    Re: Sum Numbers up to Number in Top Column

    Also, You could use =IF(B$2<>0,IF(AND(SUM(B$2:$C$2)<SUM($B$3:$B3),SUM($C$2:C$2)>=SUM($B$3:$B3)),$B3,""),IF(SUM($B$3:$B3)<=C$2,$B3,"")) for all the columns.
  24. Replies
    13
    Views
    644

    Re: Sum Numbers up to Number in Top Column

    Hi RaMDT,

    In C3 try the formula =IF(SUM($B$3:B3)<=$C$2,B3,"").
    And in D3 try the formula =IF(SUM($B$3:B3)>$C$2,B3,"").

    Drag both these down and it should give you what you need.

    Is this...
  25. Re: Formula Help| Finding Time depending on attempts

    Note that the way excel goes about working formulas out, its not completely necessary for all the brackets. Might be handy to understand whats going on but may also add more confusion.
Results 1 to 25 of 44
Page 1 of 2 1 2