$$Excel-Macros$$ Extract images from PDF files easily.

2020-07-14 Thread Zeeshan Sid
Looking for the best way to extract the images from a PDF file? With the new PDF extractor tool, you can easily extract images from PDF file. The tool can extract photographs and other graphical data from PDF files without any data

$$Excel-Macros$$ Re: Excel Password Recovery

2020-07-08 Thread Zeeshan Sid
There are several ways by which you can recover the password of an encrypted Excel file. For more info:- https://www.sysinfotools.com/blog/restore-password-protected-excel-files-without-software/ > On Friday, July 3, 2009 at 5:01:11 PM UTC+5:30, debas...@gmail.com wrote: > > > Dear All, >

$$Excel-Macros$$ Re: significance of sign in formula

2010-10-13 Thread Sid Guevara
Oct 13, 9:22 am, Sid Guevara wrote: > Dear Shantanu, > > Siti Vi is quite right, you do need Ctrl+Shit+Enter to enter the array > formula.  Also, you could simplify your formula a little by using a > double minus for the SUMPRODUCT, and do away with the IF. Minus minus > (--) c

$$Excel-Macros$$ Re: significance of sign in formula

2010-10-13 Thread Sid Guevara
: =SUMPRODUCT(--($G9:$AS9<=BV$3)*($G$9:$AS9>0),$G$4:$AS$4) Hope this helps, Sid. On Oct 12, 7:59 am, shantanu chouhan wrote: > Dear all experts > > i am using a sheet where a cell containg a formula > > cell:{=SUMPRODUCT(IF(($G9:$AS9<=BV$3)*($G9:$AS9>0),1,0),$G$4:$AS$4)}

$$Excel-Macros$$ Re: Sort and then extract digits from 7 to 25

2010-08-02 Thread Sid.
ormulaR1C1 = "=MID(RC[-1],7,19)" Application.Goto Reference:="R1000C2" ActiveCell.FormulaR1C1 = "=MID(RC[-1],7,19)" Selection.Copy Range(Selection, Selection.End(xlUp)).Select ActiveSheet.Paste Application.CutCopyMode = False End Sub Kind regards, Sid.

Re: $$Excel-Macros$$ Question re: cell comments and validated lists

2010-08-01 Thread Sid.
That's it exactly! Many thanks Dave, Sid. On 1 Aug, 13:32, Dave Bonallack wrote: > I forgot to say that the drop-down is in C1 > > Regards - Dave. > > > Date: Sun, 1 Aug 2010 01:36:25 -0700 > > Subject: $$Excel-Macros$$ Question re: cell comments and validated

$$Excel-Macros$$ Question re: cell comments and validated lists

2010-08-01 Thread Sid.
osen? Any thoughts? Thanks in advance, Sid. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.li