•1 min read•from 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!
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#Excel compatibility
#Excel alternatives for data analysis
#financial modeling with spreadsheets
#rows.com
#Excel
#conditional formatting
#same value
#values
#return
#highlight
#n
#row
#dynamic
#amount of times
#Y
#adjacent
#cell
#cells
#possible