Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thread: Run time error

    by clares
    Replies
    5
    Views
    267

    Re: Run time error

    Hi Mole999

    I don't know if this will help you but this is what I use and it works using Excel and Outllok 2016

    Dim OutApp As Object
    Dim OutMail As Object

    Set OutApp =...
  2. Help or Advise on to acheive a kind of lookup

    Hi All

    Not sure how to acheive this so hoping somebody could help or advise.

    Sheet 1 contains list of printers and what they have actually printed. The "Total Pages" is what the printer has...
  3. Replies
    3
    Views
    177

    Advise on excel formula approach please

    Hi All

    Not sure how to acheive this so hoping somebody could help or advise.

    Sheet 1 contains list of printers and what they have actually printed. The "Total Pages" is what the printer has...
  4. Replies
    4
    Views
    93

    Re: Nested if statement

    Hi AliGW

    This is perfect, thank you so much.

    Peter
  5. Replies
    4
    Views
    93

    Nested if statement

    Hi All

    I've been trying to figure out this nested if statement for a while and come here to seek your expertise if anyone can help.

    AB15 = Total AMV (5174)
    AC15 = Min RMPV (750)
    AD15 = Max...
  6. Enter a product code and display a product description

    Hi All

    Apologies in advance but I am somewhat rusty with Access and I'll do my best to explain what I am trying to acheive, many years ago I could do it.

    I have a form based on a purchase order...
  7. Re: Sorting, it inlcudes cells that have no data

    Hi There

    Thanks. When using len() is shows 0 on the blank cells, and correct values for the cells with a value.

    Certainly stumped me!

    Kind Regards

    Peter
  8. Sorting, it inlcudes cells that have no data

    Hi All

    Been a long while since I was last here!

    I am using Excel 2016, and seem to have an issue with sorting.

    I have a workbook with 56300 rows, including heading and I am trying to sort...
  9. Replies
    3
    Views
    187

    Re: Rearranging a Formula

    Thank you very much indeed Andrew. Greatly appreciated.
  10. Replies
    3
    Views
    187

    Rearranging a Formula

    I wonder if someone would be able to re-arrange this formula for me as I've tried an it isn't giving me the correct value.

    This formula gives me a Selling Price based on a Cost Price with a Margin...
  11. Replies
    2
    Views
    178

    Re: VLookup with a variable

    Thank you very much indeed, just required a slight tweak:

    ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Logs!R2C1:R" & LogsLastRow & "C2,2,FALSE)"
  12. Replies
    2
    Views
    178

    VLookup with a variable

    Hi All

    I have a vlookup but want to include a variable in part of the formula but I can figure our where the &'s should go!

    ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-1],Logs!R2C1:R3173C2,2,FALSE)"...
  13. Replies
    3
    Views
    314

    Re: Find and Replace Excel 2003

    You are a genius. Thank you so very much.
  14. Replies
    3
    Views
    314

    Find and Replace Excel 2003

    Hi There

    I wonder if there is an answer to my question. I have searched the internet without any joy. I have a workbook with over a 1000 product descriptions and want to replace all abbreviations...
  15. Thread: Double V Lookup

    by clares
    Replies
    14
    Views
    596

    Re: Double V Lookup

    Hi mvptomlinson

    Perfect thank you very much indeed.

    I had to trim() one of the account codes as it had spaces at the end and I have to convert some of the values to numbers. I had to take...
  16. Thread: Double V Lookup

    by clares
    Replies
    14
    Views
    596

    Re: Double V Lookup

    OK thank you for your help anyway. Really appreciate it.

    Kind regards

    Peter
  17. Thread: Double V Lookup

    by clares
    Replies
    14
    Views
    596

    Re: Double V Lookup

    Yes I realised that but when I hit CTRL+SHIFT+ENTER excel (2003) showed me another box asking what worksheet the references were so I clicked them and that's what it gave me? :)

    Kind regards
    ...
  18. Thread: Double V Lookup

    by clares
    Replies
    14
    Views
    596

    Re: Double V Lookup

    I'm placing the formula in C2 on sheet1?

    Kind regards

    Peter
  19. Thread: Double V Lookup

    by clares
    Replies
    14
    Views
    596

    Re: Double V Lookup

    Hi mvpTomlinson

    I have tried with substituting and I still get the #N/A:
    ...
  20. Thread: Double V Lookup

    by clares
    Replies
    14
    Views
    596

    Re: Double V Lookup

    Hi Special K-99

    This is the formula but it returns a #N/A

    =INDEX(AccountShippingAddress!A$2:C$4352,MATCH(B2,IF(AccountShippingAddress!A$2:A$2354=A2,AccountShippingAddress!B$2:B$2354,""),0),3)
    ...
  21. Thread: Double V Lookup

    by clares
    Replies
    14
    Views
    596

    Re: Double V Lookup

    Hi There

    Should I enter this formula on sheet 1 or sheet 2. I see that you are always referencing sheet 1?

    Kind regards

    Peter
  22. Thread: Double V Lookup

    by clares
    Replies
    14
    Views
    596

    Double V Lookup

    Hi All

    I've giving up trying to work this one out. Can someone help me please?

    I have two worksheets in a workbook

    On the first worksheet sheet I have:

    Column A (Account Code) and Column...
  23. Replies
    3
    Views
    374

    Re: check three values

    Thank you so very much...

    Kind Regards

    Peter
  24. Replies
    3
    Views
    374

    check three values

    Hi there

    I want to be able to test three cells (C2, D2, E2) to ensure that each cell has the same numerical value in it. If it were just two cells I could use a simple If statement. Has anybody...
  25. Thread: Addinf Spaces

    by clares
    Replies
    8
    Views
    487

    Re: Addinf Spaces

    Hi Hotpepper

    I understand the replacespace code but would you be kind enough to explain replacespace2 to me?

    Kind regards

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