New Posts For Thread: Excel Help requiredhttps://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-requiredI want to find the last number in a list which could be of different lengths. I know that there are the simple Lookup and VLookup formulas and these work with data that you input. Unfortunately, my data is created by formulas and Lookup and VLookup dIf I understand the question I would use INDIRECT/ADDRESS with an array formula=INDIRECT(ADDRESS(MAX(IF($A1:$A999 > 0, ROW($A1:$A999), 0)),1,,,"Sheet1"))... enter as array formula using Ctrl + Shift + Enter instead of just Enterwhere Sheet1 is the wohttps://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-required?post_id=524717459#524717459If I understand the question I would use INDIRECT/ADDRESS with an array formula=INDIRECT(ADDRESS(MAX(IF($A1:$A999 > 0, ROW($A1:$A999), 0)),1,,,"Sheet1"))... enter as array formula using Ctrl + Shift + Enter instead of just Enterwhere Sheet1 is the woWed, 03 Oct 2012 08:39:28 -0500compound magic is right - what you need to do is to create a dynamic range (one that changes size depending on data). Google for lots of examples.https://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-required?post_id=524716419#524716419compound magic is right - what you need to do is to create a dynamic range (one that changes size depending on data). Google for lots of examples.Wed, 03 Oct 2012 08:06:54 -0500If Column A has no blank cells in the list ~=OFFSET(A1,(COUNT(A:A)-1),0)https://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-required?post_id=524714215#524714215If Column A has no blank cells in the list ~=OFFSET(A1,(COUNT(A:A)-1),0)Wed, 03 Oct 2012 06:24:05 -0500Yes that works but I was looking for something automatic as while I'm copying and pasting I could just look at the list and type the figure in.https://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-required?post_id=524713183#524713183Yes that works but I was looking for something automatic as while I'm copying and pasting I could just look at the list and type the figure in.Wed, 03 Oct 2012 05:15:10 -0500Copy the whole worksheet and paste special it into another worksheet without it's formulas.https://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-required?post_id=524713143#524713143Copy the whole worksheet and paste special it into another worksheet without it's formulas.Wed, 03 Oct 2012 05:12:29 -0500I tried in B1=A1https://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-required?post_id=524713097#524713097I tried in B1=A1Wed, 03 Oct 2012 05:09:34 -0500Can you not copy and paste special your data to make it be in number format and not formulas?https://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-required?post_id=524713079#524713079Can you not copy and paste special your data to make it be in number format and not formulas?Wed, 03 Oct 2012 05:08:20 -0500I want to find the last number in a list which could be of different lengths. I know that there are the simple Lookup and VLookup formulas and these work with data that you input. Unfortunately, my data is created by formulas and Lookup and VLookup dhttps://community.betfair.com/general_betting/go/thread/view/94082/29410491/excel-help-required?post_id=524713063#524713063I want to find the last number in a list which could be of different lengths. I know that there are the simple Lookup and VLookup formulas and these work with data that you input. Unfortunately, my data is created by formulas and Lookup and VLookup dWed, 03 Oct 2012 05:06:53 -0500