rolls

Hi All, Going to do my best to explain what I’m looking for here :-). So I’ve created a table that calculates a quantity of an item (eg the amount of pipe required for a project by room) this results in a range of pipe lengths. What I’m hoping for is a formula to group the data (as efficiently...

Been working this issue for a while and haven't been able to solve it myself. I can two workbooks, Rent Rolls and Rent Rec. I have several Named columns on rent Rec to keep things simple. Here is the formula I use in Rent Rolls...

I need a formula to work out number of rolls for X amount of lengths an I can' have part of a length from different roll For example if I have a roll size of 20 metes and lengths of 3 metres, for 12 lengths it is easy 12 x 3m = 36m divided by 20m rl = 2 Rolls The issue becomes when it goes up...

Hey everyone, I'm new here so just a short Hello and hoping you're all well. I have a one column list of over 3000 rolls of a dice. E.g 3 6 5 3 2 3 4 4 2 2 3 etc, etc I need a way to know how many rolls before the same number came up again. So, in the above snippet of the data, if I checked...