-
I am trying to get the correct formula to extract the last word in a string. Data Correct Answer John Doe Doe John A. Downer Downer John A. and Jane Smithhaven Smithhaven If anyone can give me the correct fomula for extracting this data I would greatly appreciate it.
-
Thanks to you both for your help. The suggestion works perfectly and the methodology is beginning to gel (I hope!).
-
Hi Mike, Thank you very much for your reply - which does work in the sernerio I have given. Where the resulting address from =ADDRESS(ROW(Latest2)+MATCH($W$77,Latest2,0),COLUMN(Latest2),4,1) is in c57 - address = k7 and the result of =ADDRESS(ROW(Latest2)+MATCH($W$77,Latest2,0)-1,COLUMN(Latest2),4,1...
-
I have been working on this during the night and have so far come up with this. Being a relative beginner it probably isn't the bestsolution but here goes:- To find the first No in the 52 cell range named Latest2 (K6:K57)I have written this:- =ADDRESS(ROW(Latest2)+MATCH(K77,Latest2,0)-1,COLUMN(Latest2...
-
Although I am a beginner I have been producing basic Excel worksheets for serveral years using some of the most common functions. Since I've always wanted to improve my Excels Skills - I though what better than to create a more complicated worksheet now I have time due to illness. Apart from my recent...
-
I am 57 years old and have just started using Excel 2003 (and hopefully soon to have excel 2007) to keep myself occupied. I have set my self a task and have been creating a worksheet to predict the UK Lottery numbers each week. I realise that the odds of winning are massive and it is very unlikely for...
-
I have several spreadsheets which contain a columns used to post a date of activity. Recently, my computer crashed and I was given a new hard drive which contained Excel 2002. When I tried to edit the spreadsheets, it had changed the format of the dates I had entered. I entered them as EX. 4/1/08, they...
-
Can please someone send me the workings in a excel sheet which shows how to create a bell shaped graph. I have 500 data points and i'm struggling to show standard deviation in the form of a bell graph. You help will be appriciated. My email address is : vanse@hotmail.co.uk Thanks
-
[quote user="Nick Hodge"] Patrice I am struggling to understand what you are trying to do, perhaps you could expand a little or post an example? [/quote] Example with 2 worksheets, all data is text: A B C A B C 1 lajfljas halkjhfdl zpqoyr 1 lkjhals alkjhfdlhj lkjjahlfdhs 2 qreyq aldflalkh qoireqwoiuy...
-
I have feedback/text that I need to aggregate into a whole and then summarize ("manually"). Is it possible to consolidate text from the same range of cells on multiple worksheets into one (cell) report? I've tried the usual approach to identifying the worksheet:cells with numeric data that...