• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I need to find median by filter values

Can it possible without array, bocz due to this array, file is getting time to load.
And also getting error .Plz find the attached pic of error.
Thanks
 

Attachments

  • error.jpg
    error.jpg
    25.8 KB · Views: 3
Hi Mohit ,

Attaching a picture of the error is of no use ; if you can upload the file , it may be possible to do something.

Narayan
 
Hello Mohit,

Obviously you had to change the cells reference to match with your document. Also change the month from "Jan" to "January" in B3, as they are written in that way in your database, and add a IF to match with your additional condition on week.

Pierre
 

Attachments

Thanks but I have changed everything as you mentioned and my formula is also working fine, but the concern is that file is getting very heavy due to array function. so if possible to find the same without array.
 
That's interesting Narayank, the fact to change the database into a table reduces the size of the file? I would not have thought about that...
 
Hi Pierre ,

Sorry , but that is not the real reason for the reduction in the file size.

The basic problem with the original file was that the first 8 columns of data had data till row 4027 , while the last column , which was through a formula , had the formula copied till row 47000 or so.

The reason I shifted to a table was because then I could delete all the unnecessary rows , since the table would automatically copy the formula to newly added rows. Thus , there would be no necessity to copy the formula down to row 47000.

The benefits are that :

1. The file size has come down.

2. The formulae , both in the table and in the summary sheet , have become dynamic , since the ranges used will automatically resize themselves

3. The recalculation speed has increased.

Narayan
 
You must log in or register to reply here.
Back
Top