Excel/Expert Profile

Average Ratings

• Knowledgeability 9.91
• Clarity of Response 9.89
• Politeness 10.00
• Response Time(hr) 32.6
• Response Time(hr, last 90 days) 50.3

• Number of Questions Today 0
• Max Questions to be Asked in a Day 3
• Total Questions (since joining AllExperts) 963
• Volunteer Since 2007-05-21
• Prestige Points 3920

Recent Reviews from Users

Read More Comments

Recent Answers from Tushar Sakhalkar

2011-12-24 EXCEL:

I do not think, you need macro unless you want it to be done automatically every time entry is made in sheet 1.   As for sorting, you will need to use "Data -- Sort" command.  For ranking the you want

2011-12-22 query in excel:

You should be able to manage it easily by writing appropriate IF statement.  Let me try to understand.  In sheet1 (Secondary)- If E1(Secondary)=E1 (Master) then - A1...P1 (Secondary) = A1...P1 (Master)

2011-11-25 create macro to populate cells:

Hi Garry,  I have really not understood the requirement.  1. Someone enters value in Active!A2.  2. Macro searched for ALL records matching Active!A2 in "Data" and copies them to "Data Searched" at the

2011-11-18 insert space:

Hi John,  There is certainly a formula (Assuming original data in A1) --  "=Left(A1,4) & " " & MID(A1,5,2) & " " & MID(A1,7,3) & " " & RIGHT(A1,4)"    Make sure that once you have all data changed to new

2011-11-11 auto populate data tables based on a drop down selection:

Hi Hayley,  Solution I think could be --  (1) Create a complete database on another worksheet (say "Data')in same workbook.  (2) Protect the worksheet so that "unauthorized" persons cannot see this.  (3)