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
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
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
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
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
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
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
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
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
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
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
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
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
13 matches
Mail list logo