$$Excel-Macros$$ Re: Introduce Yourself !!

2015-04-25 Thread Shivam Saraswat
Hi All, My name is Shivam Saraswat and my age is 24 yrs. I am working as an MIS Executive in Compunnel Software India Pvt. Ltd. in Noida . I want to nourish my skills in Excel and VBA. My interests is generating VBA codes. I have multiple books for Excel formulas. -- Are you =EXP(E:RT) or =NO

$$Excel-Macros$$ Count Unique Value in Date Range

2015-04-25 Thread Zafar Iqbal
Dear Experts, Kindly help in formula to count unique values in give date range. I tried with sumproduct but failed. Sample data is attached. Thanks for your kind support, always. Regards, Zafar Iqbal -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N

Re: $$Excel-Macros$$ Loop in filtered value by VBA

2015-04-25 Thread Sunil Kumar Yadav
My means sometimes LF invoice no. not exist in data that time my filter query got error bcoz filtered value blank i want to query go to next step for other invoices copy without any errorin simple words i want to run loop in many columns in same time only in filtered visible value!!! Thanks,