Search:

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

Search: Search took 0.00 seconds.

  1. Replies
    1
    Views
    177

    Re: Cash Flow Projection Probabilty

    Can anyone help with this?
  2. Replies
    1
    Views
    177

    Cash Flow Projection Probabilty

    I have a years worth of Cash Flow projections for Capital projects that are based on the start and end dates of construction. Each month i have been tracking the actual's compared to what the...
  3. Replies
    0
    Views
    138

    Scatter Plot question

    I am creating a scatter plot in excel with over 180 points. With that many points I am not able to use data labels to show which point is for what item. Is there a way that I can change the y...
  4. Replies
    1
    Views
    111

    Changing years

    Currently in a column I have years, ie. 11,20,45. I am wanting to create a formula that when say 2017 changes to 2018 the years increases by 1, ie 11 to 12, 20 to 21 and 45 to 46.

    Is there a way...
  5. Thread: Find text

    by sajohnson05
    Replies
    4
    Views
    115

    Re: Find text

    Is there a way it will work if a certain text is in sheet 1 but the exact is not in sheet 2. Say in sheet 1 it say ICU but in sheet two it may say ICU/CCU.
  6. Thread: Find text

    by sajohnson05
    Replies
    4
    Views
    115

    Find text

    I am trying to find text from worksheet 2 and put the risk factor into worksheet 1. Any help would be great, not sure the best formula to use.

    1

    <tbody>
    Area Served
    Factor


    *******
  7. Replies
    1
    Views
    138

    VLookup between two sheets

    I have attached to screen shots as you see below. What I am trying to do is get what is in column B row 6 into the model(second screen shot) into the corresponding location based on what is selected...
  8. Thread: Sumif

    by sajohnson05
    Replies
    4
    Views
    159

    Re: Sumif

    Below are the fields I am trying to sum. I am trying to sum 0-299 and 300-399


    <tbody>
    0



    PROD SAL & WAG
    $0.00
  9. Thread: Sumif

    by sajohnson05
    Replies
    4
    Views
    159

    Sumif

    I am trying to use the formula "sumif" and i have a range from say 0-299, 300-399, 400-499, 622-699. These are account numbers. Currently i get a 0 in the field when i use the groups as the...
  10. Replies
    1
    Views
    137

    Need Help Database

    Not sure where to start on the help I am looking for but here goes.

    I have a workbook with about 50 worksheets. This is for a budget that I manage. In each worksheet across the top is each month...
  11. Replies
    5
    Views
    178

    Re: Help with Formula

    Thank you. That was exactly what i needed.
  12. Replies
    5
    Views
    178

    Re: Help with Formula

    Thank you. The only thing that I failed to mention is that I will have 53 different sites and would need a be able to sum and count by that site
  13. Replies
    5
    Views
    178

    Help with Formula

    I have two tabs with a list of different sites. I am needing to get cost amounts based on the type of work and also a count of line items per system. Below i have shown what is on one tab and the...
  14. Replies
    3
    Views
    164

    Re: Need help with formula

    Thank you that was perfect.
  15. Replies
    3
    Views
    164

    Need help with formula

    I can not figure out my formula that I need. Below is what i am trying to do.

    I have an invoice for $155K and need to split it between 162 locations based on square footage. I am trying to split...
  16. Replies
    1
    Views
    166

    Re: Insert line over Multiple sheet

    bump. Any help would be great
  17. Replies
    1
    Views
    166

    Insert line over Multiple sheet

    This is my first post as I am just now learning how to use macros. What I am looking to do is find a date ie 8/1/13 on different sheets in my workbook and these are on different lines. Once I find...
Results 1 to 17 of 17