I think I haven't posted in like 5 years... "Hello!" to anyone who remembers me.
I think the title is clear. I have a spreadsheet I wrote for our accounting department. It's just the expense reporting form.
Right now, I have a field with Today() in it for the date. This is fine when...
Stupid me, again... Just after I posted above, I found the Data Validation link on the 'net.
Sorry for the trouble, again. I hate slow connections, especially when they appear to be between synapses in my head.
Question resolved: Use Data Validation and "list" then point to the list source...
Refer to Chandoo's guest post by Daniel Ferry: http://chandoo.org/wp/2010/06/02/excel-stock-quotes/
And specifically, to the workbook itself:
http://img.chandoo.org/vba/activerange_yahoofinance_excelhero.com.xls
I have been able to add a column to the range and get the column to populate...
I have "answered" this post several times and erased my answer each time. I will not be posting my working spreadsheet. When I've completed the various sheets, I'll make them available to you, at least, SirJB.
In layman's terms, this equation became: calculate the present value as my deposit...
Thanks for the quick response, SirJB!
That's along the lines of what I had working. Your example is basically a table/array where you can do the calculations. I was hoping there was a formula; however, I'm going to go back and analyze the values. I'm nearly certain this can be done within the...
I know how to do the various financial functions (pmt, fv, cumipmt). I am trying to figure out a FORMULA for determining the following:
Let us say I have an income that changes by an amount that can be determined by a formula. I want to put this income into an interest bearing account and...
No, no sole, you do the times first. This will put all times in order. Then you sort by scratches, which will group the scratches with the times still in order. You sort them by "least important" to "most important" to put the most important as the main grouping. Try it my way and you will see.
Shouldn't it be Curpath&"salarylsip"?
I've done some VBA, but I'm just a novice. It seems you've built a variable near the top, then left it to flounder. Just my stab in the dark....
Narayan,
Thanks for those links. After reading the first, and skimming the second and third, I reiterate my suggestion: Use a native XML editor if you plan to do any XML. DreamWeaver makes it much easier than the conglomeration I just saw. This is only marginally easier than wordpad, from what...
Vijay,
XML is extensible markup language. It looks very similar to HTML (if you "view source" on a webpage, you can see some html coding). Basically, XML is a user-defined structure for storing data in such a way that it can be searched and retrieved very easily.
In Excel 2007, Microsoft...
Yes, it is possible. The security on any MS Office file is nearly non-existent. Do a google search, and you'll find dozens of free programs that will work.
Hats off to you, OC!
Sorry that I'm not going to test it myself. Personally, that's a candidate for "helper columns" that are hidden, if ever I have seen one.
I noticed my =left() formula is incorrect.
The "first" name:
=LEFT(A3,FIND(" ",A3))
The "second" name:
=RIGHT(A3,LEN(A3)-FIND(" ",A3))
IF the "second" name has a space in it:
=IFERROR(FIND(" ",G3),0)
The above will give you zero if there is no space in the "second" name. It will give...
Santhosh,
Going back to my initial response:
Will you EVER have more than 3 names?
You can then use my first formula to find the "first" name. You can then use my second formula to find the "last" name. You would need to also find the "middle" name start and finish points using
=FIND("...
Are there always three names or fewer?
=LEFT(A1,LEN(A1)-FIND(" ",A1)) That will find all the text before a space.
=RIGHT(A1,LEN(A1)-FIND(" ",A1)) That will find all the text after a space.
The problem is that you could have two spaces, sometimes. If you play with those formulas, I think you...
I recently wrote a gantt chart sheet. I used conditional formatting to fill the cell with a blue background when the cell value was "1." I used several formulas to calculate what constituted the "1" or not in the cell, based on a task list.
The formula is going to get very complicated, so I suggest you start by writing parts of it in various cells to make sure each part works properly.
I have given you the formula for getting either 9 or 11 digits/characters already.
You will then need a "MATCH" function to check this value...
=LEFT("1234567890987654321",9)
That will give you the left-most 9 characters.
=IF(LEFT(Text,1)="9",LEFT(Text,11),LEFT(Text,9))
The cell above will contain the first 11 characters of Text if the first character is equal to 9.
Note that there is no error checking, and note that the number...
There are some data missing:
Are your dates mm/dd/yy or dd/mm/yy?
How long is a course valid?
Once that is done, you just do date math to check the dates.
=DAY(TODAY()) will give today's day, which can be compared to the course's day.
=MONTH(TODAY()) will give today's month, which can be...
VBA has not changed much at all. What has changed is what you can do with VBA. You must learn the version for 2010. Everything you could do in earlier versions is still there in 2010. There are new things in 2010 that are not there in earlier versions.
Developing the code, though, might mean...