Thread: how to insert a collum on a sheet without it changing cell referen
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
  
Posts: 9,221
Default how to insert a collum on a sheet without it changing cell ref
Sorry, I got carried away earlier. If grabbing the entire row 3, no need for
INDIRECT, just: =COUNTIF(Numbers!3:3,1)
--
Max
Singapore
---
Reply With QuoteReply With Quote