Re: $$Excel-Macros$$ Combining six IF formula into one formula

2014-07-28 Thread Vaibhav Joshi
hi you cont need such formula.. use this formula =A1-MOD(A1,10)-A1-MOD(A1,10)+10 It is modeless whatever be the range yo have your answer!! Cheers!! On Mon, Jul 28, 2014 at 12:19 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Vaibhav Sir, Your formula is very good,Appreciate! Can

Re: $$Excel-Macros$$ Combining six IF formula into one formula

2014-07-28 Thread Prafull Jadhav
Awesome!.Vaibhav Sir. Thanks a Lot! Regards, Prafull Jadhav 9920553518 On 28 July 2014 12:28, Vaibhav Joshi v...@vabs.in wrote: hi you cont need such formula.. use this formula =A1-MOD(A1,10)-A1-MOD(A1,10)+10 It is modeless whatever be the range yo have your answer!! Cheers!!

Re: $$Excel-Macros$$ Combining six IF formula into one formula

2014-07-28 Thread Ravi Kumar
another way =CHOOSE(MATCH(A1,{red,sta,ida,pco,pid,pde},0),us2,ru2,cu2,us3,ru3,cu3) On Sat, Jul 26, 2014 at 9:22 AM, Nur Hossain nur2...@gmail.com wrote: Dear all , how to merge following six formula into single formula. small formula is required . Thanks IF(A1=red,us2,) IF(A1=sta,ru2,)

$$Excel-Macros$$ Re: need macro

2014-07-28 Thread Rohit Jadhav
Hi Vaibhav I want to see the code can you please provide the password for the file. On Thursday, July 24, 2014 4:05:55 PM UTC+5:30, SUDHIR VERMA wrote: Dear Experts, I need macro, which can encrypt with password after defined no of days. Example- i make file today, after 20

Re: $$Excel-Macros$$ Re: need macro

2014-07-28 Thread Vaibhav Joshi
hi password is password, but before enabling macro delete all content of sheet 1 Cheers!! On Mon, Jul 28, 2014 at 1:41 PM, Rohit Jadhav rohitj...@gmail.com wrote: Hi Vaibhav I want to see the code can you please provide the password for the file. On Thursday, July 24, 2014

Re: $$Excel-Macros$$ URGENT : Help on excel for matching data

2014-07-28 Thread Vaibhav Joshi
can you highlight error cells!! On Mon, Jul 28, 2014 at 10:43 AM, bhanu prakash bhanu...@gmail.com wrote: Hi Vaibhav, Had checked your solution, few lvl's are picking up correct other few are lvl picking wrong #'s ..had checked your response.. Regards, Bhanu On Sat, Jul 26, 2014 at

Re: $$Excel-Macros$$ excel VBA solution - offered at reasonable price

2014-07-28 Thread OJEMENI Uzoma
Excel VBA training needed online. Do you provide such services? On 28 Jul 2014 02:41, Sara Lee lee.sar...@gmail.com wrote: Does any one need help in Excel VBA project or may be entire project to be completed? Let me know. You will get the solution at a reasonable price whether u in US or in

Re: $$Excel-Macros$$ Need help in creating macro

2014-07-28 Thread Jocky Beta
Hi Vaibhav, It's highliting only row, it's not showing wich entry or exit is missing out of 18nos. It would be very helpful if it would be done. Regards On Friday, July 25, 2014, Vaibhav Joshi v...@vabs.in wrote: Hi Pl check this... Cheers!! On Fri, Jul 25, 2014 at 4:10 PM, Jocky Beta

Re: $$Excel-Macros$$ need macro

2014-07-28 Thread SUDHIR VERMA
what is password for attached file On 24 July 2014 20:21, Vaibhav Joshi v...@vabs.in wrote: Hi Check this file. In sheet 1 Cell A1 put begining date, in cell B1 put date put formula =A1+10 so that on the tenth date after date mentioned in cell A1 macro will work. You need to hide row 1

Re: $$Excel-Macros$$ need macro

2014-07-28 Thread Vaibhav Joshi
password is password On Mon, Jul 28, 2014 at 6:41 PM, SUDHIR VERMA newinex...@gmail.com wrote: what is password for attached file On 24 July 2014 20:21, Vaibhav Joshi v...@vabs.in wrote: Hi Check this file. In sheet 1 Cell A1 put begining date, in cell B1 put date put formula =A1+10

$$Excel-Macros$$ Required data separation by formula

2014-07-28 Thread Nur Hossain
Dear all, I need data separation by formula , please check the attachment. I have shown color mark that need to separate from column A to column B, C, D onward. like below : ​ -- 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

$$Excel-Macros$$ Urgent required Developer (MYSQL) - Reston, VA

2014-07-28 Thread Gary .
Please respond to gurjant.si...@damcosoft.com *Position: Developer (MYSQL)* *Location: Reston, VA* *Type: Contract/ FULL TIME* JD: We need to look for strong developer (MySql) – with hands-on experience in designing Db schema, stored procedures, cursors, writing complex queries. Thanks

RE: $$Excel-Macros$$ Required data separation by formula

2014-07-28 Thread Amit Desai (MERU)
Please see if this helps.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Nur Hossain Sent: Monday, July 28, 2014 10:29 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Required data separation by formula Dear all, I need data separation