Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.18 seconds.

  1. Re: Sumifs between 2 dates and and additional criteria

    sumifs()
    but would need to know the ranges of data to create the formula for you

    you say

    but then go on to add an OR for a wire


    What text is in the column for "Check" and for "wire" and...
  2. Re: File size - is it based on #cells with values or complexity?

    In older versions , I often had to click on the unused columns and rows
    So left just the area the spreadsheet used
    did this to all sheets and the size reduced considerably - that was version 2003...
  3. Re: Highlighting every 6th occurenct in a table - conditional formatting?

    yes, and you maybe able to use a formula like
    Assuming the product was in A column
    countif($A$1:A1,A1) = 6
    then it should highlight Just the sixth occurrence - But not the 12th or 18th
  4. Replies
    13
    Views
    472

    Re: Problem with date and/or cell formatting

    you are welcome
  5. Replies
    13
    Views
    472

    Re: Problem with date and/or cell formatting

    should be fine then
    i did change a holiday date as a test to 20th jan
  6. Replies
    13
    Views
    472

    Re: Problem with date and/or cell formatting

    Also if you select the entire range OR just the columns B:H
    it will work for the cells in the other rows with dates

    Assuming you are not adding dates or coincidentally numbers in the same range...
  7. Replies
    13
    Views
    472

    Re: Problem with date and/or cell formatting

    the first cell in the formula has to be used
    so change A1 to B1 and it correctly highlights the correct date
  8. Replies
    13
    Views
    472

    Re: Problem with date and/or cell formatting

    date format is UK , as i'm based in UK
    change the date cells format to general - and you should see a number - if it stays as a date then its not a date format - although cell+1 would not work

    ...
  9. Replies
    13
    Views
    472

    Re: Problem with date and/or cell formatting

    https://www.dropbox.com/s/xdwl19cdtzjxw1o/Dates_holidays_etaf.xlsx?dl=0
  10. Replies
    13
    Views
    472

    Re: Problem with date and/or cell formatting

    create a list of holidays on a seperate sheet
    then in conditional formatting use a formula

    Select the range of dates you want to highlight

    =countif( range of list , first cell of the dates...
  11. Replies
    7
    Views
    253

    Re: Sumif formula request

    What happens if its 1000, 2000 or 3000 , the way you have written Nothing
    as you have used greater than ? and also less then so,

    no value if

    1000 = ? %
    2000 = ? %
    3000 = ? %
  12. Replies
    7
    Views
    253

    Re: Sumif formula request

    is this just the one cell - sumif() usually adds up a range

    otherwise a nested IF or Choose ()
    Do you mean A1 less than 1000 not less or equal to ?

    =IF( A1 < 1000 , "" , IF ( A1 < 2000 , D1...
  13. Re: Conditional formatting to multiple cells in single column M

    dont check A2 - as you have selected the A column, you need to use A1
    Otherwise , you are 1 row out
    if you want to use A2 , then you need to select the range
    A2:A1000
    or to whatever range row...
  14. Re: Conditional formatting to multiple cells in single column M

    make a conditional format formula
    for 2007, 2010 , 2013 or 2016 excel version
    Conditional Formatting


    Highlight applicable range >>

    Select the column
    A:A
  15. Re: Data to appear when between 2 dates - Round 2

    sorry, i dont fully understand
    How does excel know the due date ...

    A1 = todays date - so that will keep changing

    B3 = Due Date - and has a 1 in the cell, which I assume means 1 day after...
  16. Replies
    1
    Views
    199

    Re: how do i convert number into hours in minutes

    B1-A1
    formatted as time - should work

    your formula should not work - as thats a negative time (A-B)
  17. Re: Conditional Formatting when all Fields = TRUE

    set a formula in conditional formatting

    select the range of cells - if say C2 to D20
    then add a formula to conditional formatting =C2
    and format to put a border round

    that will put a...
  18. Re: Need formula to pull in # of something based on a range

    in the raw data , try putting some formulas
    you could have a column that specifies range
    or 3 columns - depends on data results needed
    which can then be added to pivot table and counted

    =if(...
  19. Re: Need formula to pull in # of something based on a range

    so the pivot table for the example would give

    12c3 = 3
    14d4 = 2

    accounts within range
    0-5 = 2
    5.1-10 = 3
    10.1+ = 0
  20. Replies
    1
    Views
    144

    Re: Number VS Text format

    sorry dont understand
  21. Replies
    1
    Views
    179

    Re: Return the current quarter between two dates

    4 reviews in 9 months
    so no reviews from 1st Oct to 31st Dec
    and every one has 4 reviews

    so if i had a start date of Jan
    I get a review
    1 = Jan - Mar
    2 = Apr - Jun
    3 = Jul - Oct
    4 =...
  22. Replies
    12
    Views
    329

    Re: Formula to find conditional formatting

    =countif(C:C,C1)>1
    would provide the TRUE or FALSE

    so if you want "Duplicate" or "Unique"

    = IF ( countif(C:C,C1)>1, "Duplicate" , "Unique")
    and copy down
  23. Replies
    4
    Views
    247

    Re: Compare two tables

    can you expand please
  24. Replies
    3
    Views
    157

    Re: Need Sumif Formula

    you are welcome
  25. Replies
    3
    Views
    157

    Re: Need Sumif Formula

    =SUMIFS( $I$1:$I$1000 , $D$1: $D$1000 , "Direct" , $K$1:$K$1000 , "Pending" )
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4