I want to learn that how to do this with formula when large data is there.

You are allowed ONLY one thread per topic. I have closed your parallel threads. Please do NOT do that again.

Is this homework?

If so, we do not wish to cheat YOU out of YOUR education.

What have YOU tried so far?

NO HELP to be offered until we get a response.

I now see that the threads are different, but the titles are the same.

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Normally, I would do this for you, as a new member. BUT, since you have doen this 3 times, YOU must do it YOURSELF.


However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!


NO HELP TO BE OFFERED:

a) until we know that this is NOT homework and

b) if it IS homework what the OP has tried, and,

c) a proper title has beeen provided.

Regards,

Glenn.