Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    8
    Views
    182

    Re: Conditional Formatting Formula

    Can you supply any further information? Are the cells being calculated by a formula (and if so, what)? What sort of range of values should result? Abd I didn't check whether you want the CF once for...
  2. Replies
    8
    Views
    182

    Re: Conditional Formatting Formula

    Welcome to the forum!

    Use the built-in "Bottom 10..." rule. This ignores blanks and text entries. Set it to Bottom 1 for the minimum value.
    Or use this formula (assuming your range to format is...
  3. Replies
    4
    Views
    142

    Re: VLOOKUP Not Showing Result ?

    If you know that you have an entry, but it could be text or number, then:
    =IFERROR(VLOOKUP("?*",A2:A12,1,0),MAX(A2:A12))
  4. Thread: Target dates

    by ClaireS
    Replies
    3
    Views
    113

    Re: Target dates

    This would flag up jobs that were completed ate or that have not been completed yet, though the completion date is past:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color:...
  5. Thread: Target dates

    by ClaireS
    Replies
    3
    Views
    113

    Re: Target dates

    As a very basic answer, try something like this:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color:...
  6. Re: change data validation after alloweditranges password was entered

    Why do you need the password? You could just unlock all the cells they could normally edit, leaving the special ranges locked, then Protect the sheet. They could then still edit the usual cells,...
  7. Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    Or just =LEFT(A1,8)&MID(A1,13,2)&"/"&MID(A1,9,3) where A1 is the cell containing your source string.
  8. Replies
    3
    Views
    175

    Re: Odd Pivot Table Behavior

    You obviously have very well structured data as a rule ;).
    Glad I was able to help.
  9. Replies
    4
    Views
    273

    Re: Insert New Worksheet

    Try using the INDIRECT function to look at the sheet before the current one. Find a cell in all sheets (say $A$1) that you can reference to give you the sheet number of this sheet, then use something...
  10. Replies
    3
    Views
    175

    Re: Odd Pivot Table Behavior

    You get Count Of rather than Sum Of if there are ANY blank cells or text values in the column. Excel the treats the whole column as a text field, so you are seeing Field Settings rather than Value...
  11. Re: one pivot table from two different excel table

    Consolidate the sales data into a single table using Power Query or Data, Consolidate. Then start a Pivot Table based on this, and Add this data to the Data Model when you are creating the Pivot...
  12. Replies
    12
    Views
    364

    Re: Using a Named table in Data Validation

    Glad you managed to sort it out, Gary, and thanks for letting us know!
  13. Replies
    9
    Views
    308

    Re: Counting events

    Lovin' the signature, #Gerald , and totally agree! Pleased to say I knew what it would do before I ran it.
  14. Replies
    9
    Views
    308

    Re: Counting events

    Wow Gerald, that maths is way out of my league! but sticking with my formula, counting events in a table, try this:
    ...
  15. Replies
    9
    Views
    308

    Re: Counting events

    I will give it some thought, but it'll have to wait till the morning now!
  16. Replies
    9
    Views
    308

    Re: Counting events

    If you can make a column of the times for your events, you could use the formula shown here:

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px...
  17. Replies
    7
    Views
    381

    Re: Conditional formatting

    Put a $ before the G in your conditional format formula.
  18. Re: Return a Blank instead of #N/A and/or 0 with INDEX/MATCH

    Thanks, glad I was able to help. :)
  19. Re: Return a Blank instead of #N/A and/or 0 with INDEX/MATCH

    If the formula only returns the #NA error value then =IFERROR(
    INDEX(Data[GC],MATCH([Product Key],Data[Product Code],0)),"") returns the value, or a null text string "" if the result is an error....
  20. Re: Data Validation List With Offset Formula Allows Free Text Entry

    I am intrigued - as I use this forum, I see many uses of the OFFSET function to produce dynamic lists, as presumably you are doing here. But why not just use Tables? You cannot directly use a Table...
  21. Re: Conditional Formatting: everything but "X", "Y", or "Z"

    Me too, I am in awe of so many of the contributors on this board, and I find it a great learning resource!
  22. Replies
    12
    Views
    364

    Re: Using a Named table in Data Validation

    I always use Tables as sources for Data Validation - the advantages of Tables far outweigh the faff required to create the Data Validation.

    The solution is simple - just apply a traditional range...
  23. Re: Conditional Formatting: everything but "X", "Y", or "Z"

    I agree with Shane. I would make a Data Validation List - then you could put all valid values into the list and limit entries to those. Then you don't need to use very complex - or rather general -...
  24. Re: IF due date cell is < today = "" unless completed cell contains a date

    Good call! I put it in because I was editing from the formula in #13 which used different logic. Not necessary in mine. :rolleyes:

    Also, weird how the quote changed the formula, adding a spurious...
  25. Re: Conditional Formatting: everything but "X", "Y", or "Z"

    Yes it will: if you add Data Validation to existing data, you can Circle Invalid Data to highlight records that do not meet the condition.
Results 1 to 25 of 122
Page 1 of 5 1 2 3 4