Re: $$Excel-Macros$$ Merge entry cell

Respected Champs, Can you explain why the exponential function 10^10 is used in the formula =LOOKUP(10^10,E7:H7,E7:H7) i.e 10 to the power of 10 would yield a quite large number and how can it be useful in the look up function. Regards, P.VIJAY KUMAR -- Join official Facebook page of this fo

Re: $$Excel-Macros$$ Merge entry cell

Dear Ms-Exl-Learner, As always, Thank you very much for all the help Regards Amar On Tue, Dec 18, 2012 at 10:42 AM, Ms-Exl-Learner wrote: > Not sure whether this... > > For 2003 version of excel > =IF(ISNA(LOOKUP(10^10,E7:H7)),"",LOOKUP(10^10,E7:H7)) > > For excel version which is higher than

Re: $$Excel-Macros$$ Merge entry cell

Not sure whether this... For 2003 version of excel =IF(ISNA(LOOKUP(10^10,E7:H7)),"",LOOKUP(10^10,E7:H7)) For excel version which is higher than 2003 =IFERROR(LOOKUP(10^10,E7:H7),"") On 18-12-2012 10:16 AM, amar takale wrote: Dear Parvin, I want like If same number all cell something cell als

Re: $$Excel-Macros$$ Merge entry cell

Dear Parvin, I want like If same number all cell something cell also miss=one number which same If single number=show single number that it simple. I used Ms-Exl-Learner that perfect but if all cell same but last cell different number then show that numbers,I want that time show error then i will

Re: $$Excel-Macros$$ Merge entry cell

Even shorter than the previous one, =LOOKUP(10^10,E7:H7) Just type =10^10 in a cell for knowing the evaluated result. On 12/17/12, amar takale wrote: > Hi Dear, > > Solution is Perfect but waht is 10^10,I confused.I got Output but little > confusing. > > Thank Very much > > > On Mon, Dec 17, 201

Re: $$Excel-Macros$$ Merge entry cell

Hi Amar, But Amar what about if there is number like : 2 ,2,3,4 then what should be the output for this. Regards Prince On Monday, December 17, 2012 6:32:12 PM UTC+5:30, amar takale wrote: > > Dear Noorain, > Actually I want Each column filled by different person & after finish data > entry I

Re: $$Excel-Macros$$ Merge entry cell

Dear Noorain, Actually I want Each column filled by different person & after finish data entry I consolidated all column in one sheet then some of data entry is same in column but I want If same entry then show same one single unique number in K column.If more than two person input same numbers the

Re: $$Excel-Macros$$ Merge entry cell

Dear Amar, Please explain your query and what is your exact requirment. On Mon, Dec 17, 2012 at 6:06 PM, amar takale wrote: > Hi All Experts, > Pls give any solution.I will try it bu not sucess > > > On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal wrote: > >> *Dear Amar,* >> * >> * >> *Pl share

Re: $$Excel-Macros$$ Merge entry cell

Hi Dear, Solution is Perfect but waht is 10^10,I confused.I got Output but little confusing. Thank Very much On Mon, Dec 17, 2012 at 4:37 PM, Ms-Exl-Learner wrote: > =LOOKUP(10^10,E7:H7,E7:H7) -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES

Re: $$Excel-Macros$$ Merge entry cell

Hi All Experts, Pls give any solution.I will try it bu not sucess On Fri, Dec 14, 2012 at 6:04 PM, Pravin Gunjal wrote: > *Dear Amar,* > * > * > *Pl share the test file.* > * > * > *Regards* > *Pravin Gunjal.* > * > * > On Fri, Dec 14, 2012 at 5:50 PM, amar takale wrote: > >> Dear Experts >> >>

Re: $$Excel-Macros$$ Merge entry cell

*In K7* =LOOKUP(10^10,E7:H7,E7:H7) *Non *Array Solution. On 14-12-2012 5:50 PM, amar takale wrote: Dear Experts Pls can anybody help me on this matter. As always, Thank you very much for all the help Regards Amar On Thu, Dec 13, 2012 at 1:00 PM, amar takale

Re: $$Excel-Macros$$ Merge entry cell

*Dear Amar,* * * *Pl share the test file.* * * *Regards* *Pravin Gunjal.* * * On Fri, Dec 14, 2012 at 5:50 PM, amar takale wrote: > Dear Experts > > Pls can anybody help me on this matter. > > As always, Thank you very much for all the help > > Regards > Amar > > > > On Thu, Dec 13, 2012 at 1:00

Re: $$Excel-Macros$$ Merge entry cell

Dear Experts Pls can anybody help me on this matter. As always, Thank you very much for all the help Regards Amar On Thu, Dec 13, 2012 at 1:00 PM, amar takale wrote: > Dear all > Can Anybody tell me formula to merge cell entry in one column if it is > duplicate then over right on it > > Reg

$$Excel-Macros$$ Merge entry cell

Dear all Can Anybody tell me formula to merge cell entry in one column if it is duplicate then over right on it Regards Amar -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please