Forum Discussion
Excel Formula
Hello Everyone, I am fairly new to using Excel and just had something dropped in my lap that I have to deal with. We had a former employee create a form that autofills with information from a progra...
Since you acknowledge being "fairly new to using Excel" let me add to the direct answers you've gotten the general suggestion that, in addition to acquiring a basic book or two on Excel, you become familiar with websites like the following: https://exceljet.net/
Here's a page where I've already searched the term "absolute" where you'll find what the "$" does, in the bigger context: https://www.youtube.com/watch?v=sHfWRb2yUrM
And here's one that includes what the "!" means, in giving an address in another sheet: https://exceljet.net/search?query=referring+to+other+sheet
Excel is a marvelous tool, but it does challenge with a learning curve. You've discovered here in the techcommunity a good resource. Don't hesitate to make use of it.
