What I'd like to do is reference a cell when pointing to the path of a file. For example, I have a sheet like this: TOTALA ...

I have rounded some numbers to the thousands digits. I need help finding a formula that rounds the displayed (rounded thousands) digits. Everything I try...

Dear all, I have to load CSV file on sage...now when i want to create ACCOUNT NAME...it has to be only 8 digits. Is there anyway i can use some kina...

I want to em each worksheet seperately and be able to save each worksheet seperately? Thanks in advance :)

When we try to open this particular file from any PC on the network we get this error "Excel cannot complete this task with available resources. Choose less...

I'd like to input my date as "ddmmyyyy" . For example, if i input 12032008, i should have 12/ March/2008. However, my current setting turns out to be...

Is there any function to change the cell color ? for example: if Cell A1 is "001" it should be "Green" if Cell A1 is "002", it should be "Pink"

I have an excel worksheet: ID Date Company Transaction_Code 001 10092007 ...

I have a spread sheet (5000 entries) i have an extra column at the end. I'd like to generate a formula which find if my data in column A (A1:A5000) contans...

Hi Max, i have similar hassle. each of my worksheets has a persons name. Such as David, james, Fred. On one front sheet, I am trying to combine all the...

I just want to use if function in excel to compare two cell and format or possibly copy some picture in the third cell using the result of comparision. e.g....

Hi, I have a pivot table that is coming from a simple spreadsheet with following columns: Name, Credits - Where name is the name of an individual, and credit...

I have a document. This consists of say 12 worksheets. The last worksheet has a table. The values in this table are derived from formulas/references to the...

I have a Chart Y-Axis shows percentages X- Axis shows names of campanies There are approximately 30 names in the Table. On many months, the percentages are...

Okay: 2 sheets sheet1: called Nationality Sheet2: called Graph Sheet 1 consists of a table. Column A4:20 is various nationalities. Columns B3-M3 are months...

Hi, I have approx 12 sheets. On each Column A is a list of 87 names. Some changes have been made to later lists but I need to correct all lists to eb the...

=VLOOKUP(1,Nationality!B5:B29,IF(MONTH(date)6,MONTH(date)-6, MONTH(date)+6)) Creating a worksheet with a graph that reflects nationality of visitors to...

how can i convert time into integer, like i m working on a overtime sheet where i need to calculate the time difference and then multiply with they amount per...

Hi, if someone can please tell me how I can add values to closed excel file from an open excel file. What needs to be done here. Thanks.

I'm coping a table from the web into excel. I can't get excel to recognize the date as a date. For example, the date is June 8, 2004 and I want it to...