For some time now I have been downloading bank statements. I have columns for Transaction Date, Transaction Details, Amount, Balance, and one transaction per...

I want to take a list that has in a column Firstname Lastname and what I want to do is covert that into Lastname, Firstname. Is that even possible? The...

I am trying to get this result in excel 22:00 to 02:00 =4 22:00 to 03:30 = 5.5 Can anyone help me with this please Thanks in advance

I'm trying to create a formula in a cell that, given x, y, and n in other cells, calculates x*y + (x*y)*y + ((x*y)*y)*y + (((x*y)*y)*y)*y ... n times. Anyone...

Please help. I have to check 30 Lotto tickets ever week and have tried (and failed) to come up with a way over putting all the selected tickets in a grid, and...

When i open an excel file there are no commands or buttons at the top of the sheet. This must be a central function as it is the same in all files and...

Is it possible to transfer a whole worksheet to another so that it is shown in its entirety at the top of the receiving one and if it is how do I do it? Thank...

How to copy the hyperlink of a list of cells in another column

I want to display the result of a calculation as a ratio, i.e 16:1 Any ideas on how I can write a function that will allow this to display?

When I grab a selection to Sort within an Excell worksheet and click my Sort button arrow I never know if Excel will arbitrarily decide that I have a header...

Is there a formula/function to to this? Each student get 3 attempts at a test and I take the highest score. I want a formula that will display the highest...

With the below eqn do the dates have to be a cell reference or is it possible to use a specific date? One...

I have a list of names on one worksheet. I have a second worksheet that is basically a form. I would like to print out each page with the names from worksheet...

I need to copy the worksheet but I need to copy not only the values but also the formulas . Also I do not know the password . I hope there is a way to do this...

Greetings - trying to evaluate a range of cells that contain dates, and if the date is equal to or greater than today's date, sum a second range of cells:...

I have a file where one of the worksheets is set to invisible. ( 0 - xlSheetHidden). how ca I switch it to visible? every time I try to change it a warning box...

Hi, I am making an index of worksheets tat I use for my pupils. When I type in some cells excel offers me some text that is in previous cells in the...

I am trying to use Goal Seek in a Pivot Table but Excel won't let me, any suggestions on how to get it to? Thanks, TJ

I thought this would be easy but still can't get it. How do you get a vlookup to return a value from a column to the left of the array? Thanks -- Brisbane...

I have a goal to save $50,000.00 in eight years. My annual interest rate is 6.35%. What amount would I need to put away monthly, to obtain this goal? How would...