Thread: how many rows since the last time this happened
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] d.e.lindstrom@gmail.com is offline
external usenet poster
  
Posts: 18
Default how many rows since the last time this happened
Row number 1844 column C contains the integer 10.
I want to search back up row C (starting at row 1843) to count how many rows there are between row 1843 and the last time there was a 10 in row C.
I would prefer a solution that uses VBA.
Reply With QuoteReply With Quote