You are here:
I can answer questions regarding using Excel in general, analytics, macros, VBA, formulae, etc. I try to understand your business requirement, and suggest an effective and efficient method to solve your problem. Hire me to work on your project at vWorker.com
I have extensively used MS Excel since version 2000 up to 2007 in various business scenarios such as evaluating feasibility of a project or investment, compiling small level database and running metrics on them, formula to manipulate and extract information from unorganized data, forms to use Excel data in external applications, etc. I am a Business Analyst by profession and Excel is a key requirement.
Coal and Oil, LLC
MS(IT)+MBA Dual Degree, Bentley University, USA
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Shoaib | 04/17/12 | 10 | 10 | 10 | Thank you very much Shahid for your ..... |
| Chan | 04/16/12 | 10 | 9 | 10 | Fast response and knowlegable! |
| Paul | 04/13/12 | 10 | 10 | 10 | Thanks -- it worked great. |
| Shoaib | 04/13/12 | 10 | 10 | 10 | Thank you so much Shahid once again ..... |
| Adnan | 04/12/12 | 10 | 10 | 10 | Dear Shahid Thanks, It is working fine ..... |
No, you will have to enter that formula in each and every sheet, except for the summary sheet; and you have to drag that cell down till the last required row so that it checks every row of data. I know
Hi Shoaib, Sorry for the late reply, but unfortunately, what you ask cannot be done simply using a single formula. Only after I looked at your file was I able to understand your requirement. However
Hello, I will need a sample file to help you since it has been quite a while since I solved queries similar to this for you. Cheers, Shahid
Hello, I have never worked on Excel using Regional languages, but would suggest you to check the following. 1. Make sure you have installed Hindi Language support, from the Office CD 2. Make sure
Let's assume all Latitudes are entered in the A column and Longitude in B. Enter some title for "Difference" in cell C1, we'll use this to calculate the minimum value. We will use cell D1 and E1 for our
Answers by Expert:

©2012 About.com, a part of The New York Times Company. All rights reserved.