I've created a Pvt Table which contains 6 fixed columns and it will show data depends on how many columns I wanted to see. In addition, I've created another...

I have a big excel file(300m). When I analyse the data on the sheet, say, for example, give cell D2 the value of C2, then insert a formula =D2+1 for D3, then...

I am getting the number sign (#####) in place of dates whenever i try to type or paste into my worksheet. How do i get it to show the dates and not the...

How does one go about getting current data from Access to Excel without all the "want to replace this file" and other pop ups that Access ask along the way....

Sales of products in february are expected to grow by 1.56% over January sales, create a formula. Example : January 143

HI folks, thanks for the wonderful resource here. I've found a lot of answers but I had to ask this one ... I'm working on a spreadsheet that tallies if...

I have a spreadsheet that contains multiple photos. How can I copy one photo and save it as a jpg file?

Something like this in say, C1: =IF(A1="","",IF(MAX(A1,0)B1,"C","D")) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "jmac2006"...

Is there a formula to highlight (in a different colour) a only the highest and the lowest number in one column. I am not sure if this possible to do in excel...

i have a column of numbers.i want a combination of text and the column of numbers in another column.Text being constant as "Group" Reqd: groupxx where xx is...

Is it possible to copy a workbook & formulas to another workbook without re-entering each formula to reflect a new year? I created a budget worksheet that's...

i have a chart with horizontal and vertical columns and i need to know how to create it with excel

i have 2 different sheets with the same indentifier numbers am trying to figuer out how to get the same numbers

I want highlight the entire row or particular cell. I have columns called permit no., description, requester, date requested validity, approved and permit...

I have a formula: =(h24*j24)+(h25*j25)/sum(h24:25) But I have no idea how many parentheses I am suppose to place around the formula or what additional ones...

in page break view, i couldn't extend my sheet further down row 2252. is there a setting i can override so i won't have to continue on another sheet?

por favor que alguien me ayude necesito desactivar la proteccion de un libro por que necesito modificar unos datos pero todas las opciones estan desabilitadas

I'm trying to create a "drop down list" but don't know how to validate, define and/or create a source box. Trying to follow the instructions using the...

i need block paper for math

Can any one suggest an invoice template for the British market?