Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    283

    Use regex to compare cells

    I need to carry out 3 checks between 2 cells

    Check 1 - Inconsistent capitalization
    In another tool we use ^[A-Z] (In the filter source field) and ^[a-z] (In the target field)

    Check 2 -...
  2. Show changes (Track Changes or similar) in a new cell

    A1 - original sentence
    B1 - edited sentence
    C1 - is there a way to show what has changed similar to track changes in this cell?

    A1 - My name is Chris
    B1 - My name is Dave
    C1 - My name is...
  3. Replies
    3
    Views
    209

    Re: Extract a number from a string

    Thanks both, this was what I was looking for.
  4. Replies
    3
    Views
    209

    Extract a number from a string

    I have a column like this.

    Quality Score: 5 (20180412)
    Quality Score: 5 (20180220)
    Quality Score: 4 (xxxxxxxx)
    Quality score: 4 (20180713)
    Quality Score; 4 (20180605)

    I need to get just the...
  5. Replies
    4
    Views
    259

    Re: Delete every 2nd and 3rd row

    Thanks Ron and Mick they both worked a treat.
  6. Replies
    4
    Views
    259

    Delete every 2nd and 3rd row

    I have an excel column with about 5000 rows of text. Is there a quick way to delete every 2nd and 3rd row? There is nothing in the text that would allow me to filterin a smart way.

    Currently
    1
    2...
  7. Replies
    3
    Views
    163

    Re: Max formula (=MAX(A11*B11, 70))

    Thank you. That is what I needed.
  8. Replies
    3
    Views
    163

    Max formula (=MAX(A11*B11, 70))

    I use the formula to default to 70 if A11*B11 is less than 70.
    How do I change this so it doesn't default to 70 if the calculation is 0?

    Rich
  9. Vlookup change cell color if cells NOT the same

    Sorry if this is a simple one.
    I have a list of words in column A and column B
    How do I highlight the cell in column B if it doesn't match the cell on th esame row in column A?

    Thanks
    R
  10. Re: Macro for batch search/replace but also add columns (advanced?)

    Thank you. I acheived what I needed with Vlookup. Took me a while to Google and work it out but worth the time it will save me each month. :-)
  11. Re: Macro for batch search/replace but also add columns (advanced?)

    yes, I have a table in another sheet but I am not sure I understand the above. Can you hekp with an example?
  12. Macro for batch search/replace but also add columns (advanced?)

    Hi,
    Can someone help me with a batch search replace script?

    I get a fixed a list of names in column A every month. I have a fixed list of 100 people but each month, the amount of people reporting...
  13. Replies
    4
    Views
    129

    Re: Drop down list that gets 3 cells

    The first option worked. Thanks
  14. Replies
    4
    Views
    129

    Drop down list that gets 3 cells

    I have a list on sheet 2 with 3 columns

    Column A = ID
    Column B = Name
    Column C = Age

    On sheet 1 I need to select the ID from a drop down list.

    ID is in column A
    Name is column D
  15. Re: Don't calculate range if the word NO is present in a different cell

    Thank you both!!!!!! Ahoy's worked. Don't need a better way when I get the results I had hoped for.

    Rich
  16. Don't calculate range if the word NO is present in a different cell

    I have this calculation

    =SUM(E21:E68,G21:G68,I21:I68)

    Is it possible to exclude any of the columns from the calculation is No is present?

    If E20 says No the my calculation would be...
  17. Re: If A1 lower than my minimum rate round up to minimum

    Thank you
  18. Re: If A1 lower than my minimum rate round up to minimum

    Thank but that will only give me the rounded up figure in the cell I enter the formula. What if I want Al to update?
  19. If A1 lower than my minimum rate round up to minimum

    I am trying to create a quote sheet and we have minimum rates.
    If the amount in A1 is lower than my minimum hourly rate of 15 how can I make A1 round to to 15?

    Thanks
    Rich
  20. Help with formula to calculate profit margin

    What formula would I need to use to calculate profit margin here. I am getting confused when the VAT is included and not

    A1 - Purchasing price (exl VAT) - 7.61
    A2 - Selling price (inc. VAT) -...
  21. Replies
    9
    Views
    8,055

    Re: Delete rows with Red text

    Thank you very much kind sir. Works like a treat and will save me hours.
  22. Replies
    9
    Views
    8,055

    Re: Delete rows with Red text

    Hi Rick,
    The first one worked perfectly in less than a second. Is it possible to hide the rows instead of deleting them?
  23. Replies
    9
    Views
    8,055

    Re: Delete rows with Red text

    I couldn't get it to work. I left it running for 2 hours and then I just killed the process. We have about 3000 rows
  24. Replies
    9
    Views
    8,055

    Delete rows with Red text

    Hi,

    I am a total Excel beginner so please excuse me if there is already a fucntion in Excel to do this.

    Is it possible to have a macro that would delete the entire row if any cell in column D...
  25. Re: change Balance sheet amounts to different currency

    Thanks, but what happens if I need to update the exchange rate?
Results 1 to 25 of 134
Page 1 of 6 1 2 3 4