#Value error

[sgmpatnaik]

Hello Sir,


Good After Noon all


Sir,


I have small doubt that is when we use the formula and copy to downward then after some rows i got as a #VALUE After some days why it's happening


suppose my formula is


=IFERROR(INDEX(DISP_DATE,SMALL((DISP_PART="XYZ")*ROW(DISP_PART),COUNTA(DISP_PART)-COUNTIF(DISP_PART,"XYZ")+ROW(A1))-ROW(DISP_PART)+1),"")


IN THE ABOVE FORMULA THERE IS NO MISTAKE AND I AM GETTING MY CORRECT RESULT BUT AFTER SOME ROWS THERE IS ONE PROBLEM IT'S DISPLAYING THE #VALUE,


AGAIN I HAVE TO COPY THE FORMULA AND PASTE IN THE COLUMN WHERE THE #VALUE IS STARTING TO DISPLAY


KINDLY SUGGEST ME ABOUT THIS MISTAKE


HENCE I OBLIGE


THANKING YOU


WITH REGARDS


PATNAIK

 

[Hui]

SP


Are the Named Formula's returning ranges which are the same size ?


Can you post a sample file ?


I've renamed your Post as well!

 

[sgmpatnaik]

Thank Q Sir for your quick replay i am feel happy


Sir Actually the Named Rages are related to Dispatch Register and i think the named ranges size and where i use the formula ranges size are may not equal as per your answer first off i have to check my range size.


one more request


is it necessary to range size and using formula range size are be equal


Sir, i just started to enter the date in this file and i check the mistake in parties ledger please check


here is the link for my file


https://dl.dropbox.com/u/75654703/Toshali%20Cements%20Accounts_for%20HUI%20Sir.xlsb


Thanking You


With Regards


Patnaik