face

I have a macro which, among other things, draws a smiley face ( :cool: ) from the Insert + Shapes menu after a positive event. I have a reset all button to remove the data generated by the previous macro AND remove the smiley face. However, the smiley face keeps changing name from similey...

This may be more of a math question than an Excel one, but since I want to be able to use it in a spreadsheet I thought I'd pose it here. I deal with folding panels. Picture if you will a panel that is 24" wide and 110" tall. The width and length per panel will vary. The top and bottom are...

Hi, TEXT(A1,"hh:mm:ss##:##:00") is not working. How can I format the time as it will show seconds always "00"? I don't want to use any floor or round function because the problem I face is already because of precision overflow. So I want to take a shortcut with text formatting. Eg: 01:00:01 =>...

Is it possible to use VLOOKUP and have it search for 2 values to find a result? To explain, I want to be able to have the VLOOKUP formula in G3 look at A3 & B3 and find result in the array on another sheet. And this description sounds muddled to my coffee deprived brain so I'm going to attempt...

Hello to all, I am using this formula: =IFERROR(INDEX('[Pie Face Central ******* Food Costing File.xlsx]Recipe'!$L$2:$L$3100,MATCH(U466,'[Pie Face Central ******* Food Costing File.xlsx]Recipe'!$H$2:$H$3100,FALSE),1),"") My question is, if I have the reference cell located on different...

Hi Friends, I’m trying to use windings for smileys but only getting happy face. Please see table below: <tbody> Skills (E12) Knowledge (F12) Attitude (G12) Behaviour (H12) Circumstance (I12) Staff Morale (J12 Y Y NA Y NA Formula Result </tbody> In cell J12, I want to show a happy...