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 ,
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 ,
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 ,
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...