General

how do I change format to percentage without multiplying by 10
I wrote: I think it would be better to convert the imported number. You can do this by putting 100 into an unused cell and copy it. Then select the ROI cells, right-click, and click Paste Special > Divide > OK, and format the ROI cells as Percentage. You can delete the 100. If that seems too tediou... 14 Apr 2010 16:42

SUMIF w/multiple conditions
Now, what if I need to sum only the amounts in column "J3:J50" where there is no "#Value" displayed. "Jacob Skaria" wrote: =SUMPRODUCT(--(A3:A50="Consumer"),--(J3:J50>0),--(J3:J50))/C55 -- Here's my current formula: =SUMIF(A3:A50,"Consumer",J3:J50)/C55 This works fine to get... 14 Apr 2010 18:57

Need help formatting rows
Hello everyone, I am using excel 2007 I would like to know how to do the following if possible have column A add column B and put the total in column C and then put the amount of column C in column A of the next row. EX: 1+1=2 in row 1 then automatically have it put 2 in row 2 column A Thanks in advance if anyo... 14 Apr 2010 17:49

Sumif using Values, but returning text or values
Hi, I have 2 different reports. One has a list of contracts with a unique id and the other has a much larger list of contracts that also have a unique TEXT id that I need to return to the smaller report. The only common field between both reports is the contract value in dollars. Any help would be great a... 14 Apr 2010 16:42

Can I combine two of or more files of the same type and layout
I would like to combine several spreadsheets and then do a sort of both of them. Is this possible. ... 14 Apr 2010 14:28

Excel calcutions using date/timestamps
I'm trying to write an excel formula to calculate the performance improvement using timestamps. Process A took 2hrs, 20 min, 9 sec expressed as 2:20:09 Process B took 1hr, 12min, 28 sec expressed as 1:12:28 Difference is calculated as a-b = 1:07:41 How do I calculate the Process B percentage improvement in... 14 Apr 2010 14:28

Disable Options in 2003
I am wanting to disable to 2003 options to where a user can not turn on the row & column headers. Can someone please help with this. Thank you ... 14 Apr 2010 15:34

Duplicate data
I have a file that contains duplicate supplier records and I want to be able to identify where a supplier number is duplicated and then delete all but 1 of the duplicate records. I was given a COUNTIF formula but it is not working. I was told to add 2 columns and in the first blank column type =Row() in the ... 14 Apr 2010 16:42

One pivot table for multiple worksheets/tabs
Hi there Just a quick one re: pivot tables. Say I have multiple worksheets all with 35k lines or so, all with the same headings and data formats, is it possible to create a pivot table that looks at all four tabs and sums them into one table on one worksheet? Thanks Mike ... 14 Apr 2010 18:57

Why does picking an cell highlight two cells?
In an Excel 2007 worksheet, some cells when picked with the mouse highlight the adjacent cell. The cells are not merged and data is only entered into the cell that was picked. ... 14 Apr 2010 12:12