Amal - Excel - Business Software - Computing/Technology

About > AllExperts
	Search for

Main Menu

Login (Experts Only)

About Us · FAQ · Tell Friends About Us · Link To Us · Free Encyclopedia · Disclaimer · Tech Support

You are here: AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Amal

Expertise: Can answer basic worksheet related questions like formulae usage, connecting to RDBMS from server to extract rows from tables, basic macro construction, pivot table creation, dynamic updation of worksheet data from Server RDBMS..

Experience in the area
3 years

	View Past Answers	View Detailed Ratings

Average Ratings
Prestige Points: 2688
Knowledge	9.77 Best of the best
Clarity of Response	9.73 Best of the best
Timeliness	9.77 Best of the best
Politeness	9.88 Best of the best
Number Of Questions (in Past 24 Hours)		0
Max Questions to be Asked (in 24 Hour period)		5
Total Questions (since joining AllExperts)		221

Recent Reviews from Users

Knowl	Clarity	Time	Politeness	Date
7	6	6	8	10/05/08
10	10	10	10	06/03/07
10	10	10	10	03/02/07
10	10	10	10	05/01/06
10	10	9	10	02/01/06

User Comments

it was good, but i have still doubt. if i get csv file. it easy to open the file in excel. but if i want to save this. it will be in csv format. so i
(harish on 10/05/08)

thanks mr amal
(sekhar on 06/03/07)

Thanks so much Amal!
(John on 05/01/06)

Thank you.
(paul on 02/01/06)

View All Comments

	View Past Answers	View Detailed Ratings

Recent Answers from Amal

2008-12-03 How do I learn practical VBA?: Hi Maryam, Books are the best bet to learn VBA (or any topic for that matter). If you do not have the patience to learn page by page, suppose you are employed, you could try to think of automating small...

2008-10-03 excel -vba- text file: Hi Harish, For people that are familiar with Excel, this would not be a problem. Once you open the file in Excel, use File -> Save as and save this file as an .xls file. Regards, A Amal Raj...

2008-08-04 Extract text from a cell: Hi, The formula to get the date would be , =IF(B4="WorkInProgress",DATEVALUE(MID(D4,4,2)&"/"&MID(D4,1,2)&"/"&MID(D4,7,2)),"") The formula to get the time would be =IF(B4="WorkInProgress",TIMEVALUE(MID(E4...

2008-04-01 Problem in aplying vlookup formula: Hi Lalit, Please ensure that the table_array is sorted and the table_array rows are not in the same rows as your data rows. Suppose you delete your data rows, the data in your table_array could also...

2008-01-02 Counting problem: Hi Fkwan, You would need to use the formula like =dsum(). It would be a lengthy procedure to explain the usage of this formula. Please refer to the (F1) help for this formula, that would even have examples...