The cell contain formula as blank

[Chintan Trivedi]

Is there any way to consider the cell as blank in which formula is there. The formula derive data from the excel shet (Name: DD-MM-YY)under the colum name (DD-MM-YY). I have not updated the data in the sheet named as 23-Feb-13 and hence the sheet where I have applied the formula to derived the data from the 23-Feb-13 is seems blank.

But when I apply the formul(MAX(INDEX((F19:GS19<>0)*$F$10:$GS$10,0)), where F19:GS19 is the value and F10:GS10 is the dates) to derived the date for whcih the latest data available, it doesn't consider as blank.


I my office the site to upload the documents are blocke so I could nt provide the excel file.

 

[Faseeh]

Hi Chintan,


Let me rephrase your problem: Your data looks likes below:

[pre]

15-Feb-13	16-Feb-13	17-Feb-13	0-Jan-00	19-Feb-13	0-Jan-00
10	        20	        30	        40	        45              60

[/pre]
..Where the sheet you are working on retrieves dates and data below it from some sheet (Name DD MM YY) so the cell that are showing Dates and Data below are formulas. That display zeros when do not find any thing.


..But My observation is that formula should give you problem in calculating MAX() as zeros create problem with MIN() or SMALL() function. so what is the problem actually?


Faseeh