Search:

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

Page 1 of 2 1

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

by HelenL
Replies
10
Views
343

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

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

by HelenL
Replies
10
Views
343

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

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

by HelenL
Replies
10
Views
343

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. Thread: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

by HelenL
Replies
10
Views
343

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. Thread: Excel formula to rearrange the cell contents ENG/DEF/001/14 to ENG/DEF/14/001

by HelenL
Replies
10
Views
343

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. Thread: IF nested Complex formula Excel 2010

by HelenL
Replies
3
Views
469

Re: IF nested Complex formula Excel 2010

Hoping to come up with a one cell calculation if possible, please
7. Thread: IF nested Complex formula Excel 2010

by HelenL
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. Thread: Scatter Charts Excel 2010

by HelenL
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. Thread: Scatter Charts Excel 2010

by HelenL
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. Thread: Index / match for lookup

by HelenL
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. Thread: Index / match for lookup

by HelenL
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. Thread: Index / match for lookup

by HelenL
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. Thread: Index / match for lookup

by HelenL
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. Thread: Creating Pivot tables from Pivot Tables!

by HelenL
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. Thread: LOOKUP ?? Referencing Grades in a Table to use within the calculation

by HelenL
Replies
2
Views
136

Re: LOOKUP ?? Referencing Grades in a Table to use within the calculation

thank you, worked a treat

by HelenL
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. Thread: LOOKUP ?? Referencing Grades in a Table to use within the calculation

by HelenL
Replies
2
Views
136

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...

by HelenL
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. Thread: Creating Pivot tables from Pivot Tables!

by HelenL
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...

by HelenL
Replies
7
Views
459

Re: Extracting Surname field

Thank you Peter. That's perfect.

by HelenL
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...

by HelenL
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! :)

by HelenL
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...

by HelenL
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. Thread: Excel How to extract numbers from text in cell

by HelenL
Replies
4
Views
1,260

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