951
Points
Questions
8
Answers
15

Hi, thanks for the code. But I’m not getting any result even if the condition is met. I have attached a sample sheet here – http://www.megafileupload.com/8hwq/sample.xlsx. Please review it. Thanks in advance.
 147 views
 2 answers
 0 votes

Thanks for the reply and ur time 🙂 I found the answer to this 🙂
 217 views
 2 answers
 0 votes

Any help please?
 349 views
 17 answers
 0 votes

I need to do the same type of calculation for different cell rages from “TP” sheet and update the result in “WBR45” sheet in different cells. And also slightly modify the formula.
Destination cells in WBR45 sheet – AE104,AE105
These are cell ranges in TP i will use – (I3 to K30 and M3 to M30) ; (Q3 to Q30 and U3 to U30)
Difference in formula –
"=PERCENTILE.INC("
& rng.Address &
",90%)*24" ;
"=PERCENTILE.INC("
& rng.Address &
",50%)*24"If a template is given ,I can keep adding how much ever range and destination cells that I want to do this calculation.
 349 views
 17 answers
 0 votes

This fixes it..how do I add multiple cells and formula in the same code?
 349 views
 17 answers
 0 votes

I dont find the above line in the code..should I add this?
 349 views
 17 answers
 0 votes

Awesome!! This is exactly what I wanted.
But there is a small glitch…the calculation is not correct…I mean the result in the destination is in thousands and it should not be like that..it will be a two digits and few decimals..If i apply the formula directly I’m getting the correct answer
 349 views
 17 answers
 0 votes

Application defined or Object defined error in line –
Sheets(
"WBR45"
).Range(
"AE103"
).Formula =
"=PERCENTILE.INC("
& rng.Address &
",99%)*24"
 349 views
 17 answers
 0 votes

http://www.filedropper.com/wbrsample – Check TP sheet
 349 views
 17 answers
 0 votes

The formula calculates the percentile from sheet “TP” and paste it in cell in WBR45 sheet
 349 views
 17 answers
 0 votes

If the cell has colored text, then that cell should not be included in the formula. The cell with only black colored text should be taken for calculation
 349 views
 17 answers
 0 votes

I found the answer. Thanks 🙂
Dim lRow As Integer, i As Integer, j As Integer Dim ws1, ws2 As Worksheet Set ws1 = ThisWorkbook.Sheets("Latency") Set ws2 = ThisWorkbook.Sheets("TP") 'Find last roe in Sheet1 lRow = ws1.Cells.SpecialCells(xlLastCell).Row j = 2 For i = 1 To lRow If ws1.Range("E" & i) = "COMPATIBLE" And ws1.Range("O" & i) = "Pass" Then
 155 views
 7 answers
 0 votes