| Recent Answers from Tushar Sakhalkar |
 |
2008-11-19 Comparing lists.: Hi Magnus, (1) There is function called MATCH in excel but I think it will not serve your purpose. You can check help on that to confirm. (2) My suggestion would be to use SUM (of all transactions) -...
|
2008-11-18 Excel Formula: Sarah, I cannot think of a formula that can achieve this. I can attempt to write a MACRO if it is ok for you. You will need to run every time you want column 4 to be updated. Alternatively, you can make...
|
2008-11-15 MS Excel help: Part Second: If you enter formula =AVERAGE(INDIRECT("A"&(ROW()-1)*30+1):INDIRECT("A"&(ROW()*30))) in B1 it will give you average of first 30 numbers in Column A. Copy (or drag) this formula to B2 and...
|
2008-11-15 Exccel: Some background- (1) Protection of any range (including a column) comes in to play only when a worksheet is protected. (2) By default entire sheet is protected. Hence, I will show you how to unprotect...
|
2008-11-13 forumlas of ecels: for learning various topics of MS Excel please visit- http://www.functionx.com/ - Site for self learning tutorials of number of Softwares, Applications & Packagaes including Excel http://www.fgcu.edu/support/office2000/excel/...
|
| More Answers for "Excel" |