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

Thank you lot I edit your formula like below =COUNTIFS(Status!E2:E758,"*" & "HD PVR" & "*",Status!$H$2:$H$758,A4) now it's fine

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...

I understood but How you Remove "Rs." Please explain me

please explain me how you did?

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

Pls find the attachment http://speedy.sh/w6duf/Find-the-Duplicates-between-Sub-Id-Dates.xls

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

Thank U so much I edited your formula like below =IF(Q11=COUNTA(Comp!A:A)-1,"Y ","N ")&IF(Q14=COUNTA('Pending 1'!A:A)-1,"Y ","N ")&IF(Q17=COUNTA(Created!A:A)-1,"Y ","N ") is'it ok, but I want direct reference, I mean instead of cell Q11, D34+D74. Q14, G34+G74. Q17, I34+I74. I wait for...

Pls find the Download Link http://speedy.sh/xXsgF/TGT-Vs-ACH..xls

Pls find the Download Link http://speedy.sh/xXsgF/TGT-Vs-ACH..xls Thanks in Advance Regards 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...

how lookup helps

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

Sorry, I am not understood. Please...,

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

I know 4 steps (technique's), but I received more than 12 times in 8 Hours. So I planned to prepare VBA Code. Please help me to write VBA Code. It's help me to finish work early.

Sorry, I concentrated on your's VBA code only & expected also

Thanks Narayan & Kaushik Sorry Kaushik your solution works delete the blanks cells only I want to delete blank cells and the data which contains as follows.in column A. (1) "SMS" (2) "Category: Real Estate Management" (3) "All Listings | SMS" (4) "Click to view larger map" (5) "Click to...

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...

In one of the excel file, I have applied filter so, the delete move cells left or up options was not availalble.. Its found out thanks.