When Copy and Paste Value, I get numbers in 6 to 7 numbers from decimal points. Meaning it will post the value for example xx.xxxxxx. Is there a way that I...

Is their a function to extract first 3 words from a text string? Thanks. Dinesh Shah

How do you sort column? Dinesh

Pivot table gives a "Grand Total" of all rows at the end of row. Each time I run a Pivot Table, the Grand Total Column is changing from column to column....

Hello, col A1 thru F1 has following codes 1,5,7,8,4,9 Col a2 thru F2 has 10,15,25,50,55,60 values col G, H & I need a formula where col G would add the value...

Hello Experts, Customer is delinquent for 10 payments of total $25,850 (Col b2)/each monthly payment of $2585(Col a2). I extract the customers arrears from...

Hi, Looking for unique formula to allocate the past due amounts for customer deliquency. Col A = Monthly Payment Col B = Total payments due Col C = 30 days...

Hi, Somehow my Pivot table is not summing up rows at the end when I have more than two data field in excel 2007. It does sums up by columns. Does any one...

Hi, Somehow my Pivot table do not sums up by rows. Boxes are checked for both columns and rows for Grand total under options, Tools and Filter. Dinesh

Hi All, Below formula works good except it seems like the result come as a text and not as a number. Therefore, I can not calculate further. Txs for the...

Is there a function in an excel where you double click the formula which is linked to another worksheet and it open the worksheet automatically? Thanks to...

I have a file that is shared by many user. The file contains certain line items.. Let's say Col A Row 1 has the amount of $100, A2 has $150 and A3 has $200....

Hi, I like to extract a value at the end of text string. The long text string ends with "Inc. for - 356989.23". Is there a formula where I can just extract...

Col "A" Col "B" 8/18/06 Vlookup formula (result is $5) 8/21/06 Vlookup formula (cell not updated yet so result...

Hi, I am looking for a IF statement (?) where it write the statement as stated below. From To Statement as formula A B C D ...

Row 2 - Col A thru D has peoples name A, B, C, D Row 2 - Col E thru H has same peoples name A, B, C, D Row 3 - Col A has $10 (person A) Row 3 - Col F has $10...

i have a excel file which contains 14 sheets now i want to copy all teh contents of the first 13 sheets into the 14th sheet automatically ...i mean is there...

I have a long text string. Within the text string, there is always a word either "deleted" or "rejected". I like to equate the word "deleted" as "D" or...

Hi, see table below. Col A Col B Col C a 1 7 s 4 9 x 8 4 d 9 3