Top Contributor
951
Points

Questions
8

15

• Top Contributor Asked on January 20, 2017 in

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
• Top Contributor Asked on January 16, 2017 in

Thanks for the reply and ur time 🙂 I found the answer to this 🙂

• 217 views
• Top Contributor Asked on January 14, 2017 in

• 349 views
• Top Contributor Asked on January 13, 2017 in

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
• Top Contributor Asked on January 13, 2017 in

This fixes it..how do I add multiple cells and formula in the same code?

• 349 views
• Top Contributor Asked on January 13, 2017 in

I dont find the above line in the code..should I add this?

• 349 views
• Top Contributor Asked on January 13, 2017 in

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
• Top Contributor Asked on January 13, 2017 in

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

• 349 views
• Top Contributor Asked on January 13, 2017 in
• 349 views
• Top Contributor Asked on January 13, 2017 in

The formula calculates the percentile from sheet “TP” and paste it in cell in WBR45 sheet

• 349 views
• Top Contributor Asked on January 13, 2017 in

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
• Top Contributor Asked on January 12, 2017 in

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