Does anyone know if there is a function to display the worksheet name within the worksheet?

I would like to set up a lookup table. when I enter a value in the spreadsheet, it will find the match value on the column A and print out the value of...

I openned my Excel worksheets and all my columns were compressed down to like 2 char. I used auto fit to fix but why would this happen. I have 100's of...

I have data on one worksheet that I want to display in different ways. That data will be updated weekly. One of the ways is to make a bar chart of filtered...

Conditional formatting. I want to add all those values where column name is F02 and row name is Federal in a given area not the whole worksheet.

Hello! I am trying to do a vlookup where the format of the origin cells are "general" and the format of table array is all in text. I am looking up a...

I want to be able to change the size of a cell and hide what is typed instead of it changing the cell size to show what is typed

I have two pivot tables that get there source data from different files. I would like to link the fields from both pivot tables into one spreadsheet that...

How do I change the color of the entire row, if one of the columns in the row meets 1 or more criteria? I am able to change the color of the cell, but not...

I do not have XIRR function to calculate IRR for my investments. I only deposit, do not withdraw, can someone help me with formula or installing XIRR. The...

I have a workbook containing many sheets. The first sheets are years ("2005", "2006", "2007", "2008") followed by sheets for each individual project...

I am using a workload log spreadsheet to enter individual customers names daily as requests come in. To avoid entering customers twice by accident i would...

I am working on a schedule and I need to subtract 70 hours from the event time. If the event time is 1/10/08 06:20:44, when I subtract 70 hours, it only...

Hi folks, In Book2 I have a named range "Employees". In Book1 I have a list box. In the Format Control option for my list box I select the Input Range area....

I just made a very simple ledger that has 4 columns( descriptio, debit, credit and balance) and I am just using one formula in balance column that is...

I am looking for a formula that does not seem to exist within the existing range. I am an intermediate level user of Excel I often use the SUMPRODUCT formula...

How can I load a text cell with either english or French depending on what language the user chose?

How do I make a formula for a time that starts at night, (23:30) and ends the following day (09:00) and come out to be 12.5???? I can make it work for times...

Hi, I was looking for two formulas. One if I have an APR, to be able to insert that and get the APY. Same thing in reverse...if i have an APY to input it...

I have a problem ! In one spreadsheet I have in I152 a formula "I151+1", which formatted as a date gives me "30 nov 07" as a result. In another spreadsheet I...