Identifying bottom of list
Hi, Thanks to an earlier thread I have the folowing: =countif(a1:a100,"") but I need to vary the formula with the no of rows per data. so if Row 123 is last row I have = countif(a1:a123,"") Maybe I can incorporate LastRow = Cells(Rows.Count,1).End(xlUp).Row into this -- T De Villiers ------------------------------------------------------------------------ T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479 View this thread: http://www.excelforum.com/showthread...hreadid=398143 |
T De Villiers -
Use this formula to get the last row being used: =MAX(IF(A1:A10000<"",ROW(A1:A10000),"")) Also, this is an array formula so enter it using ctrl+shift+enter. Hope that helps. -- Regards, db "T De Villiers" wrote: Hi, Thanks to an earlier thread I have the folowing: =countif(a1:a100,"") but I need to vary the formula with the no of rows per data. so if Row 123 is last row I have = countif(a1:a123,"") Maybe I can incorporate LastRow = Cells(Rows.Count,1).End(xlUp).Row into this -- T De Villiers ------------------------------------------------------------------------ T De Villiers's Profile: http://www.excelforum.com/member.php...o&userid=26479 View this thread: http://www.excelforum.com/showthread...hreadid=398143 |
All times are GMT +1. The time now is 06:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com