Hi Manish,
You are welcome!!! and in my previous reply I wrongly mentioned the name as
"Bhushan" instead of your name
.
---
Ms.Exl.Learner
---
On Sun, Feb 6, 2011 at 2:38 PM, Manish wrote:
> Hey... Gr8...
> Thanks for reply...
> You all are just Wow !!! !
Hey... Gr8...
Thanks for reply...
You all are just Wow !!! !!
Regds,
Manish
On Feb 6, 2:01 pm, "Ms-Exl-Learner ."
wrote:
> Hi Bhushan,
>
> Sumproduct can be used when the result is Numeric Value.
>
> Have a look in the attached excel for retrieving the text output.
>
> ---
>
Hi Bhushan,
Sumproduct can be used when the result is Numeric Value.
Have a look in the attached excel for retrieving the text output.
---
Ms.Exl.Learner
---
On Sat, Feb 5, 2011 at 12:09 PM, Manish wrote:
> Also Sumproduct is useful for numaric value.
>
Also Sumproduct is useful for numaric value.
Is there any other formula, that will work as SUMPRODUCT for text??
Pls suggest.
On Feb 5, 11:05 am, Manish wrote:
> Is it possible to hide the complete row based on lookup value??
> For example in your solution, if i lookup value x than i want to hid
Is it possible to hide the complete row based on lookup value??
For example in your solution, if i lookup value x than i want to hide
row 14 because the lookup result is 0 /Blank. And if i change the
value and look the value y i want to hide both row 13 and 14.
Simply, I want automtion for hide bl
@bushan
mail your file to id excel-macros@googlegroups.com and attach the file
On Wed, Feb 2, 2011 at 4:42 PM, Bhushan wrote:
> Hi,
>
> I am not finding any link from where i can upload my sample file.
>
> Regards.
> Bhushan
>
> On Feb 2, 2:11 pm, Manish wrote:
> > Thanks for valuable post.
Hi,
I am not finding any link from where i can upload my sample file.
Regards.
Bhushan
On Feb 2, 2:11 pm, Manish wrote:
> Thanks for valuable post.
> Is it possible to hide the complete row based on lookup value??
> For example in your solution, if i lookup value x than i want to hide
> row 14
Thanks for valuable post.
Is it possible to hide the complete row based on lookup value??
For example in your solution, if i lookup value x than i want to hide
row 14 because the lookup result is �0�/Blank. And if i change the
value and look the value �y� i want to hide both row 13 and 14.
pls sug
Hi Bhushan,
Have a look in the attached files.
I never suggest array formula when the same can be done in normal way.
HTH :)
---
Ms.Exl.Learner
---
On Tue, Feb 1, 2011 at 6:22 PM, Bhushan wrote:
> Dear Ayush,
>
> Pls assist me for the below formula. I
