Search results

=IF(COUNTIF($A$4:$A$15,"*"&$D$7&"*")<COLUMNS($E7:E7),"",INDEX($B$4:$B$15,SMALL(IF($A$4:$A$15="*"&$D$7&"*",ROW($A$4:$A$15)-MIN(ROW($A$4:$A$15))+1),COLUMN(A1)))) Why do this formula giving #NUM!

I have a sheet which extract the desired result from an another sheet with a formula like : {IF(COUNTIF(Ledger!B:B,Chk!$M$9)<ROWS($K$13:K13),"",INDEX(Ledger!F:F,SMALL(IF(Ledger!$B$2:$B$70284=Chk!$M$9,ROW(Ledger!$B$2:$B$70284)),ROW(Ledger!B1))))}. But it is not fetching the value beyond rows...

I have a line chart which shows the usage against the projected value. Projected value is in green color and the exact value in black. Now, I need the color to be changed automatically from black to red when the exact value exceeds the projected value.

Hi Masters, My worksheet produce the desired result on the input given in Cell A1 by the users. (This is being done with many paramtrs). Here I need to restrict the cursor movement in cell A1 itself. Any kind of xls or VBA function will do. Thanks in advance. Shibu

Hi, Once again.... I have a worksheet with cheque status. The results coming in to the worksheet is produced thru vlookup command. How can I autofilter a worksheet avoiding blank rows ? (I used IFFERROR formula to make the column blank.) Regards, Shibu

I have the total of a column with the formula ---&#62; =DSUM($A$7:$G$65000,"Proj",drill_it!A1:B2)- (A1:B2 is where I have defined the criteria & drill_it is sheet name). But this formula calculate the total of all figures in column named "Proj" - including minus value. I just want to toal only...

I have C column with the result of simple subtraction. (B-C) The format goes like this A B C D 1 2 500 100 400 3 800 300 500 4 700 900 -200 5 200 50 150 Now, I want the total of D column without calculating the minus figure in D4. The answer must be...

I Need to count the exact no. of months in between 2 particular dates. How could it be extracted ? Please help.

Hello, I use =IF(COUNTIF($B$1:B1,B1)&#62;1,"Duplicate","") to identify the duplicate values. Since my worksheet does have near about 50000 line items, while I am sorting, saving, deleting or adding columns or rows, it takes much time to execute the command. Is there any remedy to solve...

Hi, I have a sheet with the data of Electricity Payment. I need to calculate the payment on no. of days basis. Eg; billing date of a bill is from 02-02-2012 to 10-04-2012. I need to bring the no. of days (27) for February in column A1 and (31) days for March in column B1 and (10) days for April...

A simple Q - since Im being confused. in last qrtr the total sale was Rs.1,00,000.00 in this qrtr the sale is Rs.50,000.00 I need to calculate the percentile of decrease in sale. Please help ...

Hi, I was trying to freeze the cell with the following program. It works with the worksheet of mine. But the problem is that when the same worksheet sent to another person by mail, this MACRO doesn't work. Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim TabOrder As...

Can a folder be password protected ?

I have a sheet which is being aligned with some criterias. Here I need to work and extract the result with DSUM on 2 different criterias. Is it possible ? First Criteria is =DSUM(A9:P2660,"TTL_U",CRITERIA_FND_TRCKR!L13:M14) I want to extend the DSUM application in CRITERAI_FND_TRCKR! L20:M21...

I have a worksheet where the T column is having the result extracted thru some formulas. I just want to hightlight the similiar answers automatically with colours or with some patterns. Is it possible ? If T column is : aaa bbb nnn aaa cell 1st and 4th should automatically be filled...........

Hi, I have some results in column J which is being extracted by using Criteria. Some rows are empty, some are having the desired results.... Now my question is that is it possible to auto filter on the result (value greater than 0 or so) ?.

How can I hide a MAIN sheet from viewing or editing others in a shared file ? Normal Alt+O+H+H will hide but the same can be visible when you give alt+O+H+U. Is there any option to give password to enable alt+O+H+U ?.

Is there any option for Blink or Highlight the result in a particular cell ?

When I extract the result with DSUM 4mula, the cell turns 0 where there is not match. How can I suppress those ZEROs ?....

=DSUM('All Site All Details'!$E$2:$AO$3504,"Esc_amnt",ESCMicr!A7:B8). How to repeat the copy command with the multiplication of 2 rows in A7:B8 ? (A9:B10, A11:B12 like that)

Hi, I have a sheet which contains the date on which the admission is taken by the students.Eg.some one has taken it on 02/03/2011, some other on 10/03/2011. I have this genuine date in column A. But I need the start date of that particular month in column C as 01/03/2011 for both the cases.