explained

hi guys, i need to be able to create an array of circles. for example, if cell A1 has the value 5 in it, and cell A2 has the value 600, then i need to be able to fit 5 circles in the width of 600... I hope i explained myself properly. Thanks

hi all i have got this far with the formula =IFERROR(VLOOKUP(B8,P8:Q1265,2,FALSE),"ERROR! ") I would really like to not show the "ERROR!" until there is a number in Cell B8 is there a way to do this? Hopefully i have explained what i need lol (Trying to learn so please be nice lol) Thanks...

I have the following equation: =IF(AND(S19="yes",$V$5>0),VLOOKUP(I5,Table27,5,0),VLOOKUP(I5,Table27,4,0)) I'm having trouble adding to this equation: if S19="no", return a value of 0. Hoping explained my self and someone can help. Thanks Alex

Hi, I need help to generate serial numbers as explained in the image (below link) Sorry I didnt understand how to attach an image in this form.. Solution either in the form of formula or in the form of vba code, both are acceptable... Thank you in advance...

Hi Everyone - This might be explained easiest by the sample table below. I'm looking for a formula that will take my inputs (Month & Year) and return the value from the last available date in that month/year from the table. <tbody> Month: 3 Year: 2013 NEEDED FORMULA: 1563...