chellebell
New Member
- Joined
- Dec 16, 2016
- Messages
- 2
Hello,
I'm working on an excel document that tracks who checked in and after a specific date we'll move them to a different area. Below is the current code:
=COUNTIF(BN6:INDIRECT("BN"&ROW()-2),"x")
I want to fill-across, but when I do I have to go in and change "BN" to the next row. I've tried all sorts of ways, referencing the current cell to get the column, indirect to reference the column, offset, and quite a few others that I can't remember. I did find one that was close (I can't remember what it was now), but it didn't get it right. It was using
COLUMN()+1
But it would only reference the original (above) plus 1, which would direct it to the next row. I can't for the life of me remember what the exact formula was. (I've been working on this and fixing an Access Database, so my mind is kinda fried right now.
Thanks in advance for any and all help.
I'm working on an excel document that tracks who checked in and after a specific date we'll move them to a different area. Below is the current code:
=COUNTIF(BN6:INDIRECT("BN"&ROW()-2),"x")
I want to fill-across, but when I do I have to go in and change "BN" to the next row. I've tried all sorts of ways, referencing the current cell to get the column, indirect to reference the column, offset, and quite a few others that I can't remember. I did find one that was close (I can't remember what it was now), but it didn't get it right. It was using
COLUMN()+1
But it would only reference the original (above) plus 1, which would direct it to the next row. I can't for the life of me remember what the exact formula was. (I've been working on this and fixing an Access Database, so my mind is kinda fried right now.
Thanks in advance for any and all help.