Re: $$Excel-Macros$$ date problem

2016-07-11 Thread Sant Ram
Just change custom formatting -- Select data range right click go to format cell go to customer in number tab paste this - dd/mm/ [image: Inline image 1] On Mon, Jul 11, 2016 at 10:54 AM, Izhar wrote: > Please open the file, I've given everything in the attach file >

$$Excel-Macros$$ Copy value from Object

2013-07-10 Thread Sant Ram
Hi, I need help urgently how to copy value from an object (i have copy objects from web page) Thanks in advance -- Regards, Santy -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Useful VBA/Excel Manual deletion of row/data

2013-06-18 Thread Sant Ram
Hi, can u please share some example sheet. On Tue, Jun 18, 2013 at 9:25 PM, Manjunath Narayanappa manjunath.narayana...@aon.co.uk wrote: Dear expert, I have a spreadsheet where every month I need to delete more than 500 rows manually. Is there any macros automatically data should get

Re: $$Excel-Macros$$ Need City in Blanck Coloume.

2013-05-08 Thread Sant Ram
Exactly Priti you are right but your formula is not working ... as i observe that you are just want increase your post count .. in we will provide top best solution not a temporary solution I totally agree with sunny... On Wed, May 8, 2013 at 11:26 AM, priti verma

Re: $$Excel-Macros$$ Need help to fill the range between two date.(column wise)

2013-05-07 Thread Sant Ram
Hi maksood, you can use series function with column selection..and in step value put 7 and Stop value put end date [image: Inline image 1] On Tue, May 7, 2013 at 6:05 PM, maksood alam 786maks...@gmail.com wrote: Hi guys, I have to select two dates, start date and end date. e.g. start date

Re: $$Excel-Macros$$ Change to numbers

2013-05-07 Thread Sant Ram
You can also you use formula like =SUBSTITUTE(E2,,,) On Tue, May 7, 2013 at 1:30 PM, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Danial : Press Ctrl + H and then in find what box keep comma , and in replace leave it empty and click Replace All it shall help... On Tue, May 7,

Re: $$Excel-Macros$$ Dcount funtion

2013-04-24 Thread Sant Ram
Hi Amar, If you are using Database function ..please ensure that all header name are same i.e.. database,field, and criteria... Your formula is working fine.. but you have changed header name see cell H11 Regard, Santy On Wed, Apr 24, 2013 at 3:29 PM, अनिल नारायण गवली

Re: $$Excel-Macros$$ Rajan Verma : Most Helpful Member - July'11

2011-08-03 Thread Sant Ram
congratulation Rajan,Ashish,Dilip,Venkat,Sunny (XLS S),Noorain.. On Wed, Aug 3, 2011 at 10:52 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Rajan Verma has been selected as 'Most Helpful Member' for the month of July'11 He has posted 170 posts in July 2011

Re: $$Excel-Macros$$ HI --help me

2011-07-25 Thread Sant Ram
use formula =IF(iserror(ur formula),,ur formula)) On Sun, Jul 24, 2011 at 5:50 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi, I have one questions.Usually while doing reports what are errors you will get ? Thanks --

Re: $$Excel-Macros$$ Two major milestones : 8000 members and 1000+ posts

2011-07-25 Thread Sant Ram
congratulation ayush On Tue, Jul 26, 2011 at 9:22 AM, Ayush jainayus...@gmail.com wrote: Dear members, I am glad to share that this forum has achieved two major milestones this month. The number of members have reached 8000 and 1000 posts in a month which is highest in forum history. The

$$Excel-Macros$$ Job in Delhi

2011-07-23 Thread Sant Ram
*Experience required for the Job:* 2 - 4 years *Annual Salary of the Job:* 2.0 - 3.0 Lacs *Job Location:* Delhi/NCR *Dear Candidate,* Hi, We have an urgent requirement of MIS/Sr MIS Executive at our head office at Okhla. Company profile: CPM India is leading organization in sales marketing

Re: $$Excel-Macros$$ Re: and the Microsoft MVP award goes to Ashish Koul :)

2011-07-04 Thread Sant Ram
Hey Boss, Congratulation. On Sun, Jul 3, 2011 at 8:15 PM, ashish koul koul.ash...@gmail.com wrote: Thank You All.. On Sat, Jul 2, 2011 at 10:37 AM, Brajesh Kumar Porwal brajeshkumarpor...@gmail.com wrote: *Congratulations Ashish

Re: $$Excel-Macros$$ count unique values

2011-07-04 Thread Sant Ram
Hey, try my attachment i think my formula is very simple so please try Regards, Santy C On Mon, Jul 4, 2011 at 10:13 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hello, If you want to count the unique numbres in a range, use this with just Enter,

$$Excel-Macros$$ Request for instruction

2011-07-04 Thread Sant Ram
Hey, please provide the SUMPRODUCT , SUBSTITUTE and ARRAY formula's how to use and instruction -- Regards, Santy C -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

$$Excel-Macros$$ JOB MS Excel Expert (Macro / VBA)

2011-07-04 Thread Sant Ram
MS Excel Expert (Macro / VBA) 2 Opening(s) Shanti Consultants * * Summary *Experience:* 3 - 6 Years *Location:* Delhi, Delhi/NCR, Noida *Compensation:* Rupees 3,00,000 - 6,00,000 *Education:* UG - B.Sc - Computers,BCA - Computers PG - PG Diploma - Computers *Industry Type:* Oil