Search:

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

Page 1 of 2 1 2

Search: Search took 0.00 seconds.

  1. Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    Thank you. Much appreciated.
  2. Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    Thank you. Much appreciated
  3. Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    Thank you so much that brilliant. works a treat !
  4. Re: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    1) single cell A1 Row 2 but will pull the formula down through the rest
    2) yes
    3) yes
    4) yes
    5)yes this is the year
    6) yes

    Thank you !
  5. Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

    Help appreciated - completely lost! :laugh:
  6. Replies
    3
    Views
    469

    Re: IF nested Complex formula Excel 2010

    Hoping to come up with a one cell calculation if possible, please
  7. Replies
    3
    Views
    469

    IF nested Complex formula Excel 2010

    Excel 2010
    Hi, any can anyone help with this please? Thank you!

    Excel 2010
    I need to calculate theoretical number of available working days and hours during contract period , total which...
  8. Replies
    3
    Views
    313

    Re: Scatter Charts Excel 2010

    Andrew
    I have checked. Perhaps I didn't explain properly. I need to know what the value relates to when I hover, such as a label, without returning to the data to look it up. Is it possible for...
  9. Replies
    3
    Views
    313

    Scatter Charts Excel 2010

    Can any help please? How to hover over scatter graph and see the cell value relating to the data point i.e. the source, rather than the cell reference. It is very time consuming to keep going back to...
  10. Replies
    7
    Views
    294

    Re: INDEX MATCH LOOKUP returning wrong value

    Hi Markmzz
    Thank you, much appreciated.
    You will notice that you have chosen 3 lines in a row from the master data for Sheet 2, but this is the problem, it is returning values regardless of what...
  11. Replies
    7
    Views
    294

    Re: INDEX MATCH LOOKUP returning wrong value

    =INDEX(Main!M2:M9, MATCH(Main!B2&Main!E2,Main!B2:B6&Main!E2:E6,0))
    M2:M9 = CValues range of cells (without column label)
    B2 = subNumber E2=Aquisition B2:B6 does not include column heading lable,...
  12. Replies
    7
    Views
    294

    Re: Index / match for lookup

    Thank you Markmzz. very much appreciated. will give it a go now and let you know.
  13. Replies
    7
    Views
    294

    Index / match for lookup

    INDEX/MATCH
    Help please ! I need to scan left and right in another worksheet to look up a number value but the lines concerned use the same reference number, but with a different subset number. ...
  14. Replies
    2
    Views
    270

    Re: Creating Pivot tables from Pivot Tables!

    Thank you. That thought was very helpful and I now realise it is a better solution to organise the data better before making the pivot chart. Many thanks
  15. Re: LOOKUP ?? Referencing Grades in a Table to use within the calculation

    thank you, worked a treat
  16. Replies
    3
    Views
    168

    Re: Excel date calculations

    Rick thank you for the prompt reply :) I shall try that. Very much appreciated. Any thoughts please re my headache with the Pivot Table on a different thread?
  17. LOOKUP ?? Referencing Grades in a Table to use within the calculation

    Hi Excel Geni
    I am trying to calculate the Annual Estimate by multiplying the Grade 'percentage equivalent' by the Annual Amount using the equivalent Grade amount quoted in a small table within the...
  18. Replies
    3
    Views
    168

    Excel date calculations

    Can anyone tell me what formulae to use to calculate the difference between two dates in number of days, and then divide by 30 to give the number of "Periods", with value rounded to 2 decimal places...
  19. Replies
    2
    Views
    270

    Creating Pivot tables from Pivot Tables!

    Hi Pivot Table Geru(s)
    Help please! Can anyone tell how to further summarise pivot table data where each row already has sub data, and there are many lines with similar titles as sub sections, so...
  20. Replies
    7
    Views
    459

    Re: Extracting Surname field

    Thank you Peter. That's perfect.
  21. Replies
    7
    Views
    459

    Re: Extracting Surname field

    Sorry to trouble you. I tested successfully on later version of Excel and the data cannot be moved from system on Excel 97. Using suggestion solution, I get Compile Error Sub or Function not defined...
  22. Replies
    7
    Views
    459

    Re: Extracting Surname field

    Thank you. You are a genius. Special thanks too for not assuming any knowledge of VB on my part! :)
  23. Replies
    7
    Views
    459

    Re: Extracting Surname field

    Thank you. I did search but go no results, so perhaps I am using wrong search word? I have used various to get the first space, but unsuccessful in tracking if 2 spaces exist as per example in...
  24. Replies
    7
    Views
    459

    Extracting Surname field

    I have data where I need to extract the Surname only, but in some cases there is either 1 or 2 middle names, or no middle name.
    examples John George Evans, John Evans, Sue Mary Jo Ellis, Jean...
  25. Re: Excel How to extract numbers from text in cell

    Thank you so much. I'm afraid I didn't explain properly. I need to remove the numbers to leave the name Example Andrew, 20055, Keith to become Andrew Keith
    Any suggestions please?
Results 1 to 25 of 26
Page 1 of 2 1 2