Recent content by bbuubb

That was some good formula writing Pete! Many Thanks! It can betiring to deduce your way through formula writing like this.

Thanks guys, Good ideas that I hadn't thought of. It turns out your right about absolute references still being affected when I delete rows. It looks like the index function will work for me if I populate row and column call numbers around my custom range for the index function to reference...

Hello, My goal is to have a master sheet with all my data on it, and secondary worksheets that mimic portions or columns of the master for easy organization and printing purposes. I can initially accomplish this by filling formula (sheet1!a1=sheet!2a1) across the whole worksheet. In order to...

Thanks IRstuff. The only thing in my XLSTART folder is the personal.xlsb file. What folder does excel store all of the toolbar and program settings in?

To those of you who know the inner workings of Excel; I use Excel 2007 on several different computers daily. I also use a good syncing program to backup all of my work files daily to a flash drive and the cloud. This program recognizes files that are new, or have been change very well, and will...

and it's still the same entry format: dd.mmssss where ssss=(ss.ss)

Ok, I'm back. I figured it out but it's a little messy. I had to split the formula with an IF statement to make it work for angles less than 1. Sorry about that. Here it is...

Sorry, I just realized that i am off by a factor somewhere, and this formula doesnt work for angles less than one degree. ill try get back to you with the correct formula. again i apologize.

Here's a formula that I stumbled across and modified a little to fit my needs. Enter your angle in a cell as dd.mmssss. The seconds are ss.ss entered as ssss. formula to convert to dms to dd...