$$Excel-Macros$$ MS Excel

2013-12-10 Thread Rajender Soni
Dear Team I have a bulky database having details of Dealer, item code and Qty, I want to make a report that which dealer has not sold which item, please help, preferably using pivot table. dealer Item a a1 b a2 a a3 c a4 a a5 d a6 Regards, Rajender Soni -- Are you =EXP(E:RT) or =NOT

$$Excel-Macros$$ Don't see 'View Code' option when I right-click on the sheet tab

2013-08-28 Thread Rajender Soni
Dear Chaya Try Alt + F11 to view the code screen. Regards, Rajender Soni | +91 750 322 55 50 -- 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 @ https://www.facebook.com/discussexcel FORUM RULES 1

$$Excel-Macros$$ Count formula

2012-04-03 Thread Rajender Soni
Dear Shrinivas Try the below mentioned formulae also: *=COUNTIFS(D7:D955,">=05/01/2012",D7:D955,"<07/01/2012")* Regards, Rajender Soni | +91 750 322 55 50 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor threa

Re: $$Excel-Macros$$ Small help regarding cell validation!

2010-08-19 Thread Rajender Soni
to your requirement. -->if the cell does not contains the keyword "soni" it will not show any error -->The formulae used in data validation is =IF(ISERROR(SEARCH("Soni",D3,1)),TRUE,NA()) Please let me know if anything else

$$Excel-Macros$$ Conditional Formatting on a formula

2010-08-12 Thread Rajender Soni
Hi Please find attached the solution sheet. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

$$Excel-Macros$$ Re: Bring in all matched unique values using lookup

2010-08-11 Thread Rajender Soni
Hi Please find attached the solution. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2

$$Excel-Macros$$ Re: how to enable macros?

2010-07-30 Thread Rajender Soni
all Macros (not recommended; potentially dangerous code can run)* 4. Be sure that the macros are from reliable source. 5. Click ok .. ok .. and came out of the loop. Hope this will solve your problem. Regards, Rajender Soni | +91 750 322 55 50

$$Excel-Macros$$ Re: $excel-macros$ help

2010-07-21 Thread Rajender Soni
Hi Preeti Please find attached the solution as required, do let me know if something else is required. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER

$$Excel-Macros$$ Break MS Excel password

2010-07-15 Thread Rajender Soni
Hi Team Please send me software to break the password of MS excel worksheet. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

Re: $$Excel-Macros$$ Finding a cell based on multiple criteria typed into cells

2010-07-14 Thread Rajender Soni
Hi Please find attached the sheet, let us know if something else is required. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links

$$Excel-Macros$$ Urgent - MS Excel charts

2010-07-12 Thread Rajender Soni
for different product category. Regards, Rajender Soni | +91 750 322 55 50 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join

Re: $$Excel-Macros$$ Need code for Sort & Sub-totals

2010-07-06 Thread Rajender Soni
Hi Please find the sample file attached. Regards Rajender Soni -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN

$$Excel-Macros$$ Help needed

2010-07-05 Thread Rajender Soni
Hi Pls revert to the issue below: My rown no. is fixed - 5, column no. is changing, now i want that suppose i click in column g, then i will get the cell value of G5, if i click on column a, anywhere in column a will get the cell value of cell a5. Regards Rajender Soni