1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Same value occurring n amount of times.

Hi all. I have a row with values. I would like excel to either; return a ‘Y’ in an adjacent row, or highlight (via conditional formatting) the cells when the same value appears at least n amount of times in a row. With the n being dynamic (referenced in a cell somewhere). Is this possible? Thanks!

submitted by /u/jiggaman887
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com