Forum Discussion

Iron Contributor

Jul 05, 2019

Find the 10,000th row in larger data set

Hi, I have large data set that changes rows every 10,000. I have large number of products, and looking to find the return for each. Every 10,000 it changes year. So i want to find the return from...

Every 10000th row help.xlsx418 KB

Charting

excel

Formulas and Functions

Macros and VBA

power bi

Theo_Bear

Copper Contributor

Jul 10, 2019

calof1

Hi try the following:

Home->Conditional Formatting->Highlight Cell Rules->More rules->Create your rule

You can select a specific color for the row number, as a rule, and filter by color.

Or you can play around with MOD()ROW().

Hope my 1 cents worth helps you in the right direction.