Search results

Hi Please find Link below http://speedy.sh/TcMrR/Greater-than-18-Hrs-Less-than-24-Hrs.xlsx help me to write Countifs formula for >18 - < 24 Hrs in cell B4 > Sheet "UPC Pend". Thanks in Advance Regards Basavaraj K H

Hi Please tell me anyone How do I write countifs formula by using wild cards The cell contain "HD PVR" Please find attached Links http://speedy.sh/c8tTs/HD-PVR.xlsx I have to write formula in cell B4 > count the number cell contan "HD PVR" in column E > in Status Sheet belongs to...

Hi How do I Sort Less than Rs. 200.00 Recharge Please find link below http://speedy.sh/7fJSt/Sort-Less-than-200-Rs-Recharge.xlsx in column G pls help me Thanks in advance

Hi Please find Link below http://speedy.sh/eJ3Da/48-Hrs-Count-of-ASM.xlsx I have to write formula in cell B2 i.e., total no. of w/o (#N/A + Non#N/A) belongs to dhananjaya in AL column (ASM) >Ageing Sheet. & in cell C2 i.e., count of "#N/A" in column AJ belongs Dhananjaya in AL column...

Hi I have some date in column A, & I already concatenate A1 & B1 with below formula =TEXT(A2,"dd/mm")&" "&B2 & in cell C3 comma is missing please help me to write formula. Pls Find Link below http://speedy.sh/ZqPWc/ex.xlsx Thanks in Advance

Hi How do I put the formula in the Calculated field Ex:- =C6/D6 i.e. = 'Slab / 'Grand Total' Please find the link http://speedy.sh/hPg6P/Copy-of-RT-Performance-March.xlsx

Hi In column G some of the date formula not working Pls help me & find the link below : http://speedy.sh/yZYbx/W-O-Pending-for-Closure-1st-March.xlsx Thanks Regards Basavaraj K H

Hi In Column A I have to find duplicates, in that duplicates I want know about both dates are same or not, how to find? Pls help me. Thanks Basavaraj K H

Hi I used some formula like below for my Report's Completed Count of Comp! =D34+D74 =COUNTA(Comp!A:A)-1 Pending Count of Pending! =G34+G74 =COUNTA(Pending!A:A)-1 Creation Count of Creation! =I34+I74 =COUNTA(Created!A:A)-1 Results =IF(Q11=R11,"Y ","N...

Selecting a data from a date as source and use the same for countifs for further calculation, Which formula is best

Hi In my excel sheet 2007, macro and vba tools are unvisible. So, how to make them appear on the sheet. Thank you in advance

HI I HAD SOME DATA IN COLUMN “A” WANTS TO REMOVE ALL THE BLANKS & THE DATA WHICH IS MENTIONED BELOW; SMS Category: Real Estate Management All Listings | SMS Click to view larger map Click to enlarge 0 Review(s) Rate it WITH THE HELP OF VBA CODE OR SOME FORMULA. PLEASE FIND THE...

Hi Particular excel sheet the delete Option shift cells left & Shift cells Right option not available in particular sheet. Plz help me Thanks in Advance Regards Basavaraj K H

Hi I had used the countif formula in sheet!1 i.e., =COUNTIF(A2:A1048576,"R")& draged from cell A1 to J1. & I want that same result in sheet! 2 in transpose mode (i.e. in sheet!2 cell A1 to A10). Which formula can I write. Plz help me to write Thanks Regards Basavaraj K H

Hi I want to run VLOOKUP or something, which will show me the both columns( Cities and Fruits ) as a base. As we see in this DATA and DATA1 there are apples available in different cities but Qty and Days differ, so I need to generate DATA which can differentiate between apple of bangalore...

Hi, I need a nested formula, Data's are stated below: In column A = City Name ( Bangalore, Simla ), Column B = City Code 1,2 and 3 and In column c = Amount. I need the sum of amount for city code 1 for Bangalore city. Thanks.

Hi Can some one help me out from this problem. I am new VBA macros. I have data like Date, ID, Last name, First name, and Middle name in the word document. I want to convert into excel sheet with the help of VBA Marcos. Example :- 10/12/2011 80997 Augustin Helene Anesthesia...

Hi Please help me to write a IF formula for below condition in attached file Cell K2 BINARIES STATUS COMPARE STATUS BINARIES & COMPARE STATUS COMPLETED DONE COMPLETED COMPLETED PENDING...

Hi How do I change String to Rev-String My Question is for ex: ABCD#?1234 I wanted it's in reverse see 4321?#DCBA like that. which formula can I use. I want both formula & VBA code also. Plz help me Thank in Advance Basavaraj K H Member of Chandoo.org

Hi How do I -Join the Cell A1 B1 & C1, When B1 is #N/A & B2 is Blank how to apply the formula, by using if or concatenate or some others formula. A B C D 1 Jagdamba #N/A Services =? 2 Jagdamba Services =? Plz send me Answer. Regards Basavaraj K H...

How to put the if condition formula in calculated filed? in pivot table, Excel 2003 My clints condition is 98-100 0% 96-97.9 10% 93-95.9 30% 90-92.9 50% 85-89.9 65% <84.9 No Incentive & I applied formula like below...

Hi How to run the formula in the Pivot Table, Excel 2003

Hi Plz send me answer to this question How to run the formula in pivot table, in Excel 2003. Basavaraj K H basavarajkh@ibibo.com 9902888801 Bengaluru Karnataka

I am Basavaraj K H from Bangalore Karnataka right now I am working with Jagdamba Infosys (Medical Transcription) as a M I S Executive working with Excel. Chandoo This is a great website with such a helpful community of contributors; I've learned so much from this site. Thank U lot of...