If you want to have "Path" of a file to a particular cell then you can use the below formula.
=CELL("filename",A1)
Sunday, 1 February 2015
Subscribe to:
Posts (Atom)
-
This formula helps to sumup based on multiple criteria. It is same as sumif but sumif support only one condition whereas sumif support mul... -
Copy= Ctrl+C Paste= Ctrl+V Paste Value= Menu Key(key between Windows key & Ctrl.)+V Paste Formula= Menu Key(key between Windows key ...