Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Next 3 months line of a chart shown in a different format/style

    Hi,

    I have a chart showing 13 months data values per month, 1= met 2 = stable 3 = Miss.

    So the chart shows 8 months of previous data then the current months value and the next three months all...
  2. lookup between two values in a column even when there are multiple values using the same value

    Ok im trying to total up the time when a support record is assigned to various groups with in the system.

    I have the support record id in Col A
    Col F has the actual team name when its changed in...
  3. Replies
    1
    Views
    103

    Re: Finding the failure point team

    Think i can complete this with the lookup function had a mental block with vlookup echoing in my mind.
  4. Replies
    1
    Views
    103

    Finding the failure point team

    Need to locate the team in a timeline when the goal time is reached. I have two tables the first shows the (A) record id (B) team name (C) date and time. Records can have multiple rows because they...
  5. Replies
    2
    Views
    196

    Re: Chart of DOOM

    will do thanks, sorry didn't google the correct terms before I posted i've also found some other ways to get my result i will post links here of what i find it seems to be a missing requirement in...
  6. Replies
    2
    Views
    196

    Chart of DOOM

    Hi,

    Not seen many chart type help questions on this forum but here goes :-

    I have data over a 12 month period which has two values for team "Alpha" and two values for team "Beta" im trying to...
  7. Replies
    4
    Views
    307

    Re: Index and Match matrix sum

    many thanks tested and all ok
  8. Replies
    4
    Views
    307

    Re: Index and Match matrix sum

    So this formula only references the row not the column is this possible to get both.
  9. Replies
    4
    Views
    307

    Index and Match matrix sum

    Hi,

    can someone give me an example of a Index and Match to look at a table and give me the sum of the values.

    col A contains the numbers (a4:a9)
    1
    2
    3
    1
    2
  10. Re: value from Column A when IF is "yes" in Column B

    Col A formula looks for the word "Server" in Col D and returns the 6 digits after the word Server.
    Col B formula looks for the word "Added / Removed / Updated" and returns the value "A R or U"....
  11. Re: value from Column A when IF is "yes" in Column B

    Col A formula looks for the word "Server" in Col D and returns the 6 digits after the word Server.
    Col B formula looks for the word "Added / Removed / Updated" and returns the value "A R or U"....
  12. value from Column A when IF is "yes" in Column B

    Hi,

    Ive looked for several days now to get this formula working. I have a list in col D (text), in col A i look for a unique item in col D in col B i look for another unique value in col D these...
  13. Replies
    0
    Views
    110

    Target value of 98% in a list of value

    Hi.

    I would like a formula to tell me the value in a list that equals 98% of the population of the list.

    So I have a pivot table of returns for a month the pivot shows the count of the returns...
  14. Re: Cross ref Target number in a list for 98%

    I thought of this i was really looking for a formula to tell me it was 25 rather than use a helper column but i think thats the only way.
  15. Cross ref Target number in a list for 98%

    Hi,

    I have a list of data returns the numbers in that range fall between 0 to 100 a lot of the numbers fall in the low part of this range eg. 9.
    I need to work out the target number of this...
  16. countifs to return target from massive data set

    hi, I have 100 devices on the network situated in zones labeled A-J giving feed back every 5 minutes for 7 classes of data each month.

    now i need to work out per device if i set a target how many...
  17. Able to get an images from a formula but cannot hide the image border

    Hi,

    I have followed this youtube https://www.youtube.com/watch?v=P4XriuikOs8 to apply the concept of images from a result of a formula but my sheets have white backgrounds and i can see the cell...
  18. Building Summary on date and time ranges Countifs Sumproduct

    Hi,

    having issues when building formulas to lookup data for a certain date and time range.

    E.g. need the count of tickets raised in a day in a time range 2/1/2015 from 8:00:00 am to 8:30:00...
  19. Summarising data based on the first instance of an indicator

    HI All,

    I have data for tickets which have multiple steps. I have this data sorted and summarising the entire ticket duration but ive been informed when a ticket has a ceratin step that is the...
  20. Replies
    1
    Views
    129

    sum from date not date and time

    Hi,

    Trying to sum data in col B only using the criteria of the date in Col A, col A has the date and time format so unsure how to sum. have tried to use the day and month functions but not...
  21. Replies
    3
    Views
    253

    Re: sum data between two cell values

    Many thnaks will test and return here with my results
  22. Replies
    3
    Views
    253

    sum data between two cell values

    Hi All,

    I know this is a question like using Sumproduct to total data between dates but i just cant get this to work.

    Each line in the report shows a status change with in a record there are...
  23. Quick Sumproduct refresh of the function - require help

    Hi All,

    Been away from excel for a while and very rusty with Sumproduct so im trying to get help with the following example to help me with a list problem.

    I have two lists. Im extracting data...
  24. Replies
    2
    Views
    175

    Re: Repeat : counting blanks dynamic range

    but that doesnt incorparate the dynamic range of col A
  25. Replies
    2
    Views
    175

    Repeat : counting blanks dynamic range

    Hi,

    I have a list several columns wide and need to count the blanks in a column in the list, looking through the forum there are a few array formulas.

    Is there a way to count blanks in Col B...
Results 1 to 25 of 129
Page 1 of 6 1 2 3 4