Hello Paul / Ayush,
Can you guys help me or guide me on this one...
Best regards,
Dollar Chande
On Friday, March 10, 2017 at 4:28:34 PM UTC+5:30, Dollar Chande wrote:
>
> Hi All,
>
> I am a novice at macro (very little knowledge) and would seek your kind
> assistance on my attached sheet. I am
Thank you very much.
Thanks
N.Sundarvelan
9600160150
On 24 March 2017 at 21:05, Swapnil Palande
wrote:
> Hi,
>
> There is no need of extra columns you have added in sheet 3 and sheet 1.
> Using "Sumproduct" formula you can get required output. Attached is the
> solution for your reference. I ho
Hi,
Need more explanation. If you could provide sample file then it is easy to
provide appropriate solution.
Have one query, if there is only one criteria then why are you using
"COUNTIFS" formula, use "COUNTIF" instead.
Regards,
Swapnil Suresh Palande.
On Fri, Mar 24, 2017 at 6:09 PM, Sundarv
Dear Friends,
Please help how to dynamically change the criteria range.
That is
=COUNTIFS(Sheet1!$AA:$AA,Sheet3!B$2)
=COUNTIFS(Sheet1!$AB:$AB,Sheet3!B$2)
=COUNTIFS(Sheet1!$AC:$AC,Sheet3!B$2)
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be
use
ActiveSheet.Paste
to paste the content from excel clipboard.
Regards
Eugene
On Thu, Mar 23, 2017 at 1:43 PM, suresh k wrote:
> Hi All,
>
> I have 10 files in my c drive. I have to capture other applications
> screenshot and paste in all 10 files.
>
> I am able to capture screenshot, but n