Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.02 seconds.

  1. Re: Conditional formatting with or function, not case sensitive...

    I have dealt with these sorts of formula before and I can see what you mean. I keep excel formulas moderatlely simple. Longer / more complex formulas have more potential for errors which I prefer to...
  2. Re: Conditional formatting with or function, not case sensitive...

    Hi Peter

    I think what you are saying is...

    The formula searches for text strings whether they are specific words or parts of words - is that correct.

    If that is correct...

    Your comment...
  3. Re: Conditional formatting with or function, not case sensitive...

    The formula is as follows:

    =COUNT(SEARCH("word1",M3),SEARCH("word2",M3),SEARCH("word3",M3)),

    The first cell it applies to is:

    M3 (M1 and M2 are my headers along with the rest of rows 1 and...
  4. Re: Conditional formatting with or function, not case sensitive...

    Trying several times, I highlighted the whole column and placed dollar signs in front of the column and row numbers (selection criteria) and then placed the formula into the formula bar without...
  5. Re: Conditional formatting with or function, not case sensitive...

    Hi Rory

    Thats wierd - I tried your method which seems to be what I am looking for, only it found several blank cells and cells without the specific words I put in. Perhaps I'm doing something...
  6. Re: Conditional formatting with or function, not case sensitive...

    Hi RoryA

    Thank you.

    It looks as though you mean to create a list of words for the formula to look up whereas I mean to place the words, probably within quotes, within the conditional formatting...
  7. re: Conditional formatting with or function, not case sensitive...

    Is there a formula I can use to search cells in a column for say 3 specific words whether they be on their own or in a text string. I'd like to search for up to 10 words but perhaps this is not...
  8. Conditional formatting with or function, not case sensitive...

    Is there a formula I can use to search cells in a column for say 3 specific words whether they be on their own or in a text string. I'd like to search for up to 10 words but perhaps this is not...
  9. Replies
    5
    Views
    149

    Re: Vlookup and match?

    Nice one Fluff - just what I was looking for - thank you!!!
  10. Replies
    5
    Views
    149

    Re: Vlookup and match?

    <tbody>
    Hi RasGhul

    I know the Ys do not necessarily match in the following sample - its just to show the idea...

    ...also, the formula is in all cells but shows blank where the item does not...
  11. Replies
    5
    Views
    149

    Vlookup and match?

    Two tables of data...

    I have table1 with headers which I need to do a horizontal lookup on to match table2 with the same headers

    I have a serious of columns of data in table2 which I then need...
  12. Replies
    16
    Views
    482

    Re: Sum numbers between two specific cells

    Thanks Peter. Always find your help with Excel top notch! No worries getting there after the grand master
  13. Replies
    16
    Views
    482

    Re: Sum numbers between two specific cells

    Now you're a grand master...don't think, feeeeeeel!...thank you soooooo much

    Dan
  14. Replies
    16
    Views
    482

    Re: Sum numbers between two specific cells

    It works in the first row (row2) but when I drag down it does not work in any of the following rows
  15. Replies
    16
    Views
    482

    Re: Sum numbers between two specific cells

    Always the nmbers 1 through to 9.
    Always only 9 numbers.
    Never two or more of the same numbers.

    =sumbetween works in the first row but not in the next rows - not sure what it is doing?!
  16. Replies
    16
    Views
    482

    Re: Sum numbers between two specific cells

    Like it says - the numbers between 8 and 6, that is the 7, 1 and 2, in this instance, although the numbers may be in any order so long as the formula works out the sum between two of the specific...
  17. Replies
    16
    Views
    482

    Re: Sum numbers between two specific cells

    <tbody>
    8
    7
    1
    2
    6
    3
    9
    5
    4
  18. Replies
    16
    Views
    482

    Re: Sum numbers between two specific cells

    Hi FormR

    Thats a step further than I anticipated and clearly shows you have great Excel skill! Can you show me a formula that will work on a single row and one that will work on a single column,...
  19. Replies
    16
    Views
    482

    Sum numbers between two specific cells

    I need a formula to sum the values in a series of cells where the cell to the left is a specific number and the cell to the right is a different specific number.

    Any help would be much appreciated.
  20. Re: VBA Excel 2016 - Upper Case and Font size lines required...

    Thats done it, thank you so much for your help Fluff (and advice regarding the code insertion technique)!

    Dan
  21. Re: VBA Excel 2016 - Upper Case and Font size lines required...

    Hi Fluff

    Its raised the text size in a few cells in columns H and M and looks to have underlined most if not all the other text items and has made all text in all cells bold.

    Also, can you send...
  22. Re: VBA Excel 2016 - Upper Case and Font size lines required...

    Thank you for the replies, will view yours Joe4. I tried yours Fluff and its doing something but maybe due to my missing the top 3 lines of the Sub that its not working correctly...sorry, the Sub...
  23. VBA Excel 2016 - Upper Case and Font size lines required...

    The following code works fine, only I would like to insert a line of code to change the text to Upper case and another line to change the size of the font.

    Any help would be much appreciated:

    ...
  24. Re: List text in column without spaces from a spreadsheet if numerical values greater than 0

    Example: sheet1


    <colgroup><col width="87" span="2" style="width: 65pt;"></colgroup><tbody>
    Item1
    Quantity
  25. Re: List text in column without spaces from a spreadsheet if numerical values greater than 0

    Brings up runtime error 1004 and inserts the header and the first item several times into sheet2?


    Dan
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4