Hi guys, looks like a nice forum you have here. I've started making a record of all the purchases every month that my kitchen makes. I've set every supplier...

Hi, This is my first post and there will be many more to come I expect. My first Question is in relation to transposing. I cant seem to transpose linked...

I would like to create a spreadsheet where if you input date as Jan06 in cell A1, subsequent cells B1 C1 D1 etc automatically fill as feb06,mar06,apr06 -...

Aftre changing time into decimals, whrn I add up the numbers in each column, I loose .01 in the third column, then the same in every sixth column.

When using the payment function in Excel, I notice that the result of my formula is always a negative number. I have seen two different ways to crrect...

Files are being saved in the correct format and can be opened normally from the recent files section of the File Menu in excel. The copmputer tried to open...

I am trying to add more payroll stubs on my payroll calculator. I have 5 employees and it only gives me stubs for four of them. I need to be able to add more...

I am trying to set up a spreadsheet with driving test results including one column to say pass one to say fail and calculate the percentage of each on a...

i posted this in general forum but i think its better suited here - i got a worksheet such as this: SequenceId Musician Initial YOB YOD Instrument 1 Micheal...

Hello, I have a workbook that has 50 sheets. I want to create a loop that will copy each individual sheet to its own workbook and save it with a name. ...

I am wishing to create the shading as shown on the 2nd image/chart on this page: http://office.microsoft.com/en-us/assistance/HA011097991033.ASPX I'm trying...

Hey, I have a pretty complicated question, it's probably easy for well versed users, but I'm not sure what the cleanest way to do this is. Here's what I'm...

Hi Anyone know how I can calculate the amount of days between two dates not taking into account weekends and possible Bank holidays? TIA Steve

Hey So Im making a log to keep track of things, and I want to calculate my sleep, but I don't want to have to write the date each time, Went to Sleep: ...

301.5/cos19.79=301.5/.94023=320.43 ? -- Lois Ann

i have a list of names in one worksheet, i used a countif formula to count the number of names - but how do i replace the zero when a data is not found to...

I am setting up a spreadsheet w/ the top half using gridlines and the bottom half blank to type in information I need concerning the subject. I don't know...

How would I write this? G= degrees. If 0-90 degrees = G If 90-180 degrees =180-G If 180-270 degrees = 180+G IF 270-360 degrees = 360-G -- Lois Ann