Forum Discussion
Need FORMULA help please! Converting # from countif function and converting it into individual cells
Hi - I need help choosing the best formula. Using #'s 1-10, I need to convert this into individual fields in excel. For example, if I have the number "4" in ONE cell, I need this to translate into...
Hi,
Sorry, but your request isn't clear enough!
Could you clarify it?
However, try this solution below, it might be close to what you asking for.
=IF(ROW(A1)<=$A$1,TEXT($A$1&"00","$#"),"")
Regards