[Tags: guide, accounting, excel]
I am a CPA and use Microsoft Excel spreadsheet software everyday. Being advanced in Excel makes my job extremely easier. I figured I'd see if there is anyone out there who has quick questions in excel that I can help. Hey what can I say I'm a generous guy.
To ask your question, use the comments form below! I will post responses to your questions below. I do not answer replies through email, as posting the answer here will help others who may have the same question as you.
Ask away...
Note: Please provide enough information for me to be able answer your question (the more info the better). The more effort you put into your question the more effort I will put into my response.
- Related Articles:
- Excel: Numbers not formatting correctly. Unable to add decimals
- Audit Shortcuts for Excel
- Too Many Cell Formats in Excel (Resolved)
Reader Comments (Page 1 of 1)
Friday December 19, 2008 @ 02:21 PM
Circular reference means you are including the result of a formula in the calculation. You will need to post specifics in order for me to help you. Information such as the data you have and what you are trying to do is needed.
Monday December 22, 2008 @ 04:24 AM
Can i extract a data by lookup using 2 column data?it not match a single column data, but i need it to match a complex 2 or more column data
Monday December 22, 2008 @ 09:27 AM
You can try using SUM(IF()). http://support.microsoft.com/kb/275165
Sunday March 29, 2009 @ 07:50 AM
Dear, I have a Excel Sheet of about 500 questions from different subjects. As my job need, i have to take the exams of the trainees here. I want the excel Sheet that can generate random questions from the list. The full description is, I have a spreadsheet with questions. Every question has four options, option A, Option B, Option C, Option D. The trainee need to select from the list proveded as From Option A to Option D. No need to use keyboard. Only select from the List. My main problem is i am not able to sort it randomly. Right now i am doing it mannually. I am getting the results ready as the trainee clicks on the Finish Button but not the random generation. Please help me. my mail id is mangeshmalvankar[at]gmail.com
Sunday March 29, 2009 @ 07:07 PM
RE: Mangesh
I might not understanding correctly ... but If you want to sort randomly how about you add a column to the spreadsheet and put the formula rand() for each row in that column. The rand function will insert a random number which constantly changes into the cell. Now you can sort by the column and you will have unique order everytime.
Monday March 30, 2009 @ 01:20 AM
Dear Sir, Thanks for replying. Please understand. I am handelling a exam. The exam paper contains 20 questions on each subject. A question has four options Option A, Option B, Option C and Option D. Another Sheet contains about 500 questions. In one row, Question, Option A, Option B, Option C, Option D, Correct Answer, Trainees Answer, Justification. These are different columns in that row. means 1 row contains one question. another row has another question. In this way i have to ask 20 questions on each subject. But the questions must be in the randomly generated fashion. each question must be unique for that test.
Right now i am doing manually. but i am getting the results ready when the trainee clicks on finish. All the result sheets are updated in my laptop eachtime. for this i am using the MAP DRIVE option successfully. But a much problem with Random generation. Hope you understand the program. Please guide me. i am regularly viewing your site. but not getting the proper answer. my mail id is mangeshmalvankar[at]gmail.com.
Friday December 19, 2008 @ 01:44 PM
Tyring to do an IF function but am getting a circular reference error. Not sure if you use this function and could possibly help?