Search results

Hi , Shouldn't that be : =COUNTIF(H$5:H$26,"x") = 1 Narayan

Hi , In my Excel 2010 , the CELL function remains G irrespective of whether a cell has been formatted BOLD or not. Narayan

Hi , At this rate , we will never get anywhere. Can you mention just one worksheet cell and the worksheet tab where you have a formula which needs to be corrected ? Just one worksheet cell. Just one worksheet tab. Unless this is given , please do not bother to reply with anything else. Narayan

Hi , I am not able to understand what formulas need to be fixed. Can you start with the first column where formulas need to be fixed , and explain what you want done ? Narayan

Hi , I don't think this is the correct file , corresponding to your post. Please check and upload the appropriate file. Narayan

Hi , Thanks.This file is OK. Narayan

Hi , The uploaded file gives errors when I open it. Can you ensure that your file is fully verified ? Otherwise , any uploads may be missing important parts such as data validations. Narayan

Hi , If the diameters are entered in centimetres , and the thickness in millimetres , the result in metres is given in the attached file. Narayan

Hi , See the attached file. Narayan

Hi , See the attached file. Narayan

Hi , I have not understood your requirement. Do you want names from C12 downwards to be the distinct names from the range C5:F8 or from C4:F8 ? Can you check out this post ...

Hi , I have no idea what is causing the problem , but using structured table referencing eliminates it. Use the formula : =SUMIF(Table13[col6],A1,Table13[col5]) in cell F1 and copy down. Narayan

Hi , Doing this without VBA is risky because it is entirely dependent on the recalculation method being manual. Excel has no foolproof formulaic method for detecting transitions , which is what you want here. VBA has the Worksheet_Change event which recognizes when a worksheet cell has been...

Hi , Can you check the attached file for the names in the range C5:F8 in the PAYOUTS tab ? Narayan

Hi , I have opened your workbook in Excel 2010 , and the same behaviour is present. Strange. What ever be the font of those cells which contain the formulas , what ever be the font size , the moment a new row is added to the table , the font of those cells changes to Calibri , font size 11...

Hi , Something like this ? Narayan

Hi , Does this mean anything ? Narayan

Hi , Can you go through this and say whether it clarifies the problem ? If not , I will explain in more detail. https://stackoverflow.com/questions/33798867/vba-userform-with-dtpicker Narayan

Hi , These are two different requirements ; resizing the screenshot can be done if the actual size constraint is known. Can you give the final dimensions to which the screenshot needs to be sized ? Hiding the empty cells has to be done in Excel before the screenshot is taken. This can be done...

Hi , See the attached file. Narayan

Hi , Try this : =SUMPRODUCT(($D$3:$D$5="Done")*LOOKUP($C$3:$C$5,{"High","Low","Mid"},{1,0.25,0.5})/SUM(MMULT(--($C$3:$C$5={"High","Low","Mid"}),{1;0.25;0.5}))) Narayan

Hi , I doubt that any help will be forthcoming , because the format of the calendar is such. Secondly , there is no data collected in one place in the workbook ; all it contains is calendars for various months , some of them with some data filled in , some blank. It may be easier if the data...

Hi , As an aside , this may be of some use : https://excelcharts.com/animation-interaction-and-dynamic-excel-charts/ Narayan

Hi , What do you mean by a moving bubble chart ? Narayan

Hi , What is your level of learning as far as VBA is concerned ? Do you want every line of code to be explained , or are there specific portions of the code which you want explained ? As far as learning VBA is concerned , there are many good websites which teach VBA starting from the basics ...