Ads

Sunday, 1 February 2015

File Path-Excel Formula

If you want to have "Path" of a file to a particular cell then you can use the below formula.

=CELL("filename",A1)


at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)
  • Sumifs()
    This formula helps to sumup based on multiple criteria. It is same as sumif but sumif support only one condition whereas sumif support mul...
  • Excel Shortcuts
    Copy= Ctrl+C Paste= Ctrl+V Paste Value= Menu Key(key between Windows key & Ctrl.)+V Paste Formula= Menu Key(key between Windows key ...