Welcome, Guest
You have to register before you can post on our site.

Email:
  

Password
  





Forum Statistics
» Members: 623
» Latest member: ajaysharma8532
» Forum threads: 760
» Forum posts: 1,872

Full Statistics

Latest Threads
Sum Function
Forum: Ask Excel Question
Last Post: Sajan
25-Nov-2021, 01:10 PM
» Replies: 4
» Views: 1,750
VBA check if
Forum: Ask VBA Question
Last Post: Vivekananda Sinha
12-Jan-2021, 08:45 PM
» Replies: 1
» Views: 1,116
Dependent Drop Down
Forum: Ask Excel Question
Last Post: Anil Kumar Pal
23-Nov-2020, 10:05 AM
» Replies: 1
» Views: 799
for and next
Forum: Ask VBA Question
Last Post: Abhay
08-Sep-2020, 03:26 PM
» Replies: 0
» Views: 854
PAN NO. FORMULA
Forum: Ask Excel Question
Last Post: dsharma789@rediffmail.com
06-Jul-2020, 11:51 AM
» Replies: 0
» Views: 894
Getting error while tryin...
Forum: Ask VBA Question
Last Post: Rinku Sharma
25-Jun-2020, 09:01 PM
» Replies: 0
» Views: 722
Hyperlink Pivot table dat...
Forum: Ask Excel Question
Last Post: sanj_edu
14-Jun-2020, 06:37 PM
» Replies: 0
» Views: 712
Calculate idle time no mo...
Forum: Ask VBA Question
Last Post: Inderjeet Pal
28-Apr-2020, 11:59 AM
» Replies: 0
» Views: 823
Making Pivot table
Forum: Ask Excel Question
Last Post: Vivekananda Sinha
17-Feb-2020, 12:39 PM
» Replies: 1
» Views: 1,162
Need help on code
Forum: Ask VBA Question
Last Post: Inderjeet Pal
15-Feb-2020, 04:23 PM
» Replies: 0
» Views: 873
Date Selection In Range
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 02:03 PM
» Replies: 1
» Views: 1,102
count
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 01:19 PM
» Replies: 3
» Views: 1,867
Array
Forum: Ask Excel Question
Last Post: imexcelguru
14-Jan-2020, 12:16 PM
» Replies: 4
» Views: 1,793
find unique values as hig...
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 10:07 PM
» Replies: 4
» Views: 2,662
add numbers in a cell
Forum: Excel Challenges
Last Post: imexcelguru
13-Jan-2020, 08:36 PM
» Replies: 0
» Views: 789

 
Twitter Add picture
Posted by: Kanhaiya Srivastava - 27-May-2019, 10:09 PM - Forum: Ask VBA Question - Replies (1)

Hi

How to add picture in outlook Email via VBA


  absent & Present
Posted by: virendra - 25-May-2019, 10:20 PM - Forum: Ask Excel Question - Replies (1)

hello friends please solve these excel question



Attached Files
.xlsx   three question.xlsx (Size: 13.76 KB / Downloads: 13)

  IE Automation
Posted by: Kalwant singh - 20-May-2019, 10:33 AM - Forum: Ask VBA Question - Replies (1)

Hi,

Can any one help on below issue.

internet explorer not letting me to correction any field after fill form by vba code successfully. And two coloum are auto calculate those field also showing blank. When I refresh the page again it's working fine on manual filling.

Regards,
Kalwant Singh


  If & And Condition
Posted by: Anil Kumar Pal - 20-May-2019, 09:47 AM - Forum: Ask Excel Question - Replies (4)

Dear Team,

I have a scenario in this i have incentive table for a salesperson if he achieves 90% then incentive will be 70% of Rs.100000
and when he achieves 91% then incentive will be 72.5% of Rs.100000.....

However i have done the exercise with IF & And condition but it looks very long function is there any shorter way to get the output? 
Please help me out.

I have used the attached condition.



Attached Files
.txt   Condition Used.txt (Size: 458 bytes / Downloads: 10)

  Concate Function
Posted by: Chandan kumar - 17-May-2019, 04:43 PM - Forum: Ask VBA Question - Replies (1)

Hi All,

I have created one function that concatenate the Emp. Code. It is working fine. But some time we get space with Emp. Code that not get eliminated by trim and clean function. Emp. Code have 8 digit length.

Attached is the excel file.

Regards
Chandan Kumar



Attached Files
.xlsm   ConcCateXformula.xlsm (Size: 16.75 KB / Downloads: 7)

  Mail draft code not working properly.. always miss half portion of the chart
Posted by: Inderjeet Pal - 17-May-2019, 10:04 AM - Forum: Ask VBA Question - Replies (1)

I have written a code to start an email that contains :--------- Text---------
Chart here from excel

Then Range
Chart
Chart 

Again text here.
BUT THE PROBLEM IS THAT MY CODE IS WORKING FINE BUT WHEN IT PASTING THE CHARTS AND RANGES IT ALWAYS MISSED THE LAST HALF POSTION OF THE RANGE.


  Power BI TEST
Posted by: Inderjeet Pal - 10-May-2019, 04:39 PM - Forum: Ask Excel Question - No Replies

One test in POWER BI.



Attached Files
.docx   Power BI Test.docx (Size: 14.62 KB / Downloads: 8)

  Reverse words
Posted by: Chandan kumar - 09-May-2019, 09:52 PM - Forum: Ask Excel Question - Replies (3)

Hi All,

Good day to you. I have one question attached in this post. need to reverse the words. It is asked to one of my colleague
in the interview.


Thanks,
Chandan Kumar



Attached Files
.xlsx   Question.xlsx (Size: 9.13 KB / Downloads: 15)

  Need Help
Posted by: Vipin Yadav - 08-May-2019, 12:39 PM - Forum: Ask Excel Question - Replies (1)

Dear Team please help to 
I am trying to find a correct Tat date but not including  , Insuff Raised Date, Insuff Cleared Date



Attached Files
.xlsx   Sampal.xlsx (Size: 11.49 KB / Downloads: 10)

  Mail merge
Posted by: Abhay - 04-May-2019, 06:23 AM - Forum: Ask Word Question - Replies (2)

Dear Sir,

I have been printing "certificate data" on "already printed certificate" in MS Word through mail merge option, maintaining record in MS Words's address book is not so much handy.


Can I link mail merge to MS Excel data.

Regard,