Hi all, I hope you can help. I have read these forums for a long time but just signed up as this is the first time I haven’t been able to find an answer on here! I am looking for a formulae to get the last cell in a range from a different tab. The range is B9, G9 L9 Q9, V9, AA9, AF9 on the worksheet 'New Monitoring'. I need to show the last used cell from this range in a cell on a different tab/worksheet. I have tried to name the range as 'TestRange' and have tried this formulae - INDEX(TestRange,MATCH(9.99999999999999E+307,TestRange)) But it doesn’t return the value. I am scratching my head and have hit a brick wall. Any help would be hugely appreciated.
This question generated 12 answers. To proceed to the answers, click here.
This thread is current as of November 06, 2014.