Dear Group,
We use subtotal for row now I like to following please help if it is
possible: -
1 In one worksheet i am using Column A1 to EL82
2 In each cell there is value 0 or I or R
3 I want a count value in column EM
4
pl share sheet with example..
Cheers!!
On Wed, Jul 9, 2014 at 12:17 PM, Rajeev wrote:
> Dear Group,
>
>
>
> We use subtotal for row now I like to following please help if it is
> possible: -
>
>
>
> 1 In one worksheet i am using Column A1 to EL82
>
> 2
PFA
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Vaibhav Joshi
Sent: 09 July 2014 12:25
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Subtotal for visible/unhidden column
pl share sheet with example..
Cheers!!
On Wed
Of *Vaibhav Joshi
> *Sent:* 09 July 2014 12:25
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Subtotal for visible/unhidden column
>
>
>
> pl share sheet with example..
>
>
>
> Cheers!!
>
>
>
> On Wed, Jul 9, 2014 at 12:17 PM,
: 09 July 2014 13:18
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Subtotal for visible/unhidden column
Check Col L, you need to use UDF as mentioned in it. Calculate sheet by
pressing F9 once you hide / unhide cells.
Cheers!!
On Wed, Jul 9, 2014 at 12:38 PM, Rajeev