Sub Count_Change()
Dim I As Integer
Dim StrtRow As Integer
Dim rng As Range
StrtRow = 6
Do While ActiveCell.Value <> ""
If ActiveCell.Offset(1, 0).Value <> ActiveCell.Value Then
Set rng = Rows(ActiveCell.Row)
For I = 1 To 2
rng.Offset(1).Insert xlDown...
Hi Sachin,
May be below formula can address your problem , Considering Cell A1 has the Date+Time value , Midnight will give result as Zero while Noon will give result as 12
=IF(TEXT(A1,"hh")+0<13,(TEXT(A1,"hh")+0),(TEXT(A1,"hh")-12))
I hope this helps
Hi,
Please see attached file. I have managed to come up with the required result. Still I feel this is not the best way to achieve the desired result. Looking forward for more efficient inputs that can better the solution.
the only catch here is that on topmost left cell we need to provide...
Hi,
It seems there is a mismatch in the output which you desire and the data you have provided ( Account not matching , 3000 entry shown under 450060 & mar'15 , is actually for account 450061 in your base data. ). Also months in base data are mixed of text and dates. For desired output it...
Hi,
Please try
=IF(AND(D2="Pending with UIDAI(DQC)",E2=""),"Pending with customer",IF(E2="","Pending with team","Closed"))
Attaching file for your ready reference.
Thanks Luke,
I intently excluded one date as I did not wanted to include the same for my calculation purpose as a nature of the analytics.
By d way If there a way through which I can address my problem through mix of existing (Inbuilt) functions?? ( Just wanted to know ).
Greetings !!!!!!
This is a recent problem I came across. I have two sheets here , One containing employee bill details ( along with desired Output ) named " Employee Billing Data". While the other have their travel details along with Geography in which they traveled named "Travel Data".
I need...
You are getting error because you cant add blank ( "") with Zero ... Try to use following
=IFERROR(IF(ISBLANK([Date1]),"",[Date1]) + IF(ISNUMBER([Inv. Payment Terms]), [Inv. Payment Terms],0),"")
Abhiroop ,
I have used simple conditional formatting & sum formula to derived at following sheet.
Request you to please see and suggest this meets your requirement or not.
Just have one concern , In Result amount column , formula should be =IFERROR(IF(C5=F5,D5,D5*F5/C5),0) , This will give you proportional cost.
In your formula , If I look at Row 19 , Cost for 3 People is less than what is there for 1 people.
Please correct me If my understanding is wrong.
Was jus
@ somendra
We may miss out blank cells and might end up counting the same , Just a bit modification to formula can take care of such omissions.
=COUNTIFS($A$2:$A$7,A10,$B$2:$B$7,"<>0",$B$2:$B$7,"<>")
Dear Arup , Sorry to interrupt , But formula mentioned by Mike works on different sheets of the same workbook as well. Only change you need to do is to append sheet name in you reference.
i.e. =SUBTOTAL(3,Sheet1!$A$2:$A$54)-SUBTOTAL(3,Sheet1!$B$2:$B$54)