Finding Lowest Common Multiple for a set range that could have multiple scenarios of empty cells

[PNuff]

Hi - I'm looking to find the Lowest Common Multiple of a set range containing 12 side by side cells. However, those twelve cells are user inputted, and all 12 cells may not get populated. Sometimes, for example, only cells 3, 5 and 7 will get an integer, and other times cells 8, 9 and 10 will get an integer. Sometimes, all 12 cells will get an integer. No matter what the input, it will always be integers. Note that sometimes the 12th (last) cell will be empty.

The LCM function does not like empty cells. I've tried some CountIFs and some other rudimentary combinations when it only needs to grab a few cells from the range of 12, but the LCM does seem to want to work with other formulas...

Any ideas would be appreciated.

Thanks!

Pete

 

[barry houdini]

Hello Pete, welcome to MrExcel

Try this array formula to ignore blanks - assumes data in A1:A12

=LCM(SMALL(A1:A12,ROW(INDIRECT("1:"&COUNT(A1:A12)))))

confirm with CTRL+SHIFT+ENTER<strike></strike>

 

[PNuff]

That worked perfectly! Thanks so much!

Pete