I want to set up a spreadsheet to chart NRL results, such that I can input the results of each game and it will sort teams by their current ranking round by...

Hi all, I have a column of cells that I want to VLookup the answer for. It's for a snooker tournament. It could be for a golf tournament too! I have a...

It seems like it should be possible to do this with conditional formatting, but i can't find a function that detects whether a cell contains a formula. any...

I have a quote which has borders around each cell i.e. a table. However, these borders are displayed on screen but on print preview and when printing some...

I want to change the name and title placements in a cell/ worksheet/excel file. For ex. the content of the cell is "Rajeev Chhajer" and i wanna change...

I've created a directory and set up the mail merge. Chose "merge all records" and when I preview the directory per recipient, they are all there but when I...

I am working on a Huge Date requested by the Management, but I stopped working due to the data requested is hard to finalized it. It really need a Genius to...

Hi I can only find 5 yr financial projection spreadsheets that do not integrate P&L, Balance Sheet and Cash Flow. i.e they only do P&L, or only BS or only...

Is it possible to protect and entire column of formulas in a sheet while still allowing the DELETION of rows?

I have a Workbook containing 3 worksheets and am running 2 "VLOOKUP" columns from 1 worksheet referencing the other 2. My formulas are...

Hello Everyone I have two worksheets if the number in sheet 1 cell B2 is in column B of sheet 2 (say B36) I want the number in A36 to be copied to sheet...

I'm using a workbook with several pages. Yesterday I had no problems seeing my tabs but today, the only thing at the bottom of the page is a bar that says...

In page setup when you "show comments at end of sheet" it refers to the cell no. How can you show the cell nos on the printed work sheet.

How do I copy a worksheet from an external source into a shared workbook?

Is there a limit to the number of custom formats you can create in a workbook? I have an application that might required sveral hundred, and I dont want to get...

I recently got a file and now, my top menu functions are only; FILE - WINDOW - HELP. What happened to the tools and other functions that used to be on the...

I am doing a spreadsheet that has twenty tabs and one master (where I collect all the data from the info entered into each tab). I need to copy the first...

I have no idea how to do this or if it's possible but I've been at this for hours and am at a loss. I have 15,000 cells in one column that all have to have...

Hi, i have this line of code that copy 6 cells to the right. Can this be modified to copy the cell before those 6 cells too? dlr =...

How can I write the average formula so it does not count the cells with zeros in it... A1= 12 A2= 0 A3 = 12 A4 = 0 A5= 12 A6 =0 if I write the formula as...