Cell values to count up from 1 to the value in cell, then start again and go to next value

[adambriggs]

Hi all,

I am trying to create a list of data pulled form multiple worksheets. To do this I am using the indirect function with index match to look for the worksheet name then use a number for the row lookup reference. In the spreadsheet attached, the column H is the reference and is currently manually entered, but need it to be dynamic driven by row C in the table to the left as the values 7 and 5 will change. Essentially I need it to count up from 1 to max of the first value in col c, then 1 to the max of the next value in column c, and so on and more sheets are added to the workbook. The reason for it being dynamic is that the values in col c will constantly change.

Any help much appreciated.

Thanks,

Alex

[davsth]

in h6 perhaps
=IF(L6=L5,H5+1,1) and copy down

[adambriggs]

Thanks for such a quick and simple response, that does seem to work. Any chance you could explain how as I can't seem to understand it?

[AliGW]

Maybe this will help:

=IF(L6=L5,

If L6 is equal to L5 ...

H5+1

add one to the value in H ...

,1)

otherwise return the value 1.

[adambriggs]

Ah yes very clear, was too busy trying to link it back to the other table. Thats great thank you!

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.