-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
second occurrence
-
J
Trying to find the second occurrence in a row.
Hi there, I've had a problem where I have a row of percentages and I need to find the second occurrence of a percentage that is under 40%. E.g. if I have two rows like this <tbody> Jan Feb March April May 56% 44% 39% 25% 99% </tbody> Then I would like it to return April. I have found lots...- JoeSw
- Thread
- 40% columns excel row second occurrence
- Replies: 6
- Forum: Excel Questions
-
R
MATCH TRUE INDEX - Where does small come in to it??!!?
Hi Guys, I am completely stuck on this and could really do with some help. I am trying to display a column title when a unit sale (indicated by a 1) is placed below in the rows. The current set up I have, which is working perfectly is...- Robbiehof
- Thread
- help formula excel index match second occurrence small
- Replies: 5
- Forum: Excel Questions
-
B
Nth occurrence
Hi! My table looks this: <tbody> x y z aa ab 100 Client Jan-12 Fev-12 Mar-12 Apr-12 101 aaa 1 1 3 1 102 bbb 3 2 1 2 103 ccc 1 2 1 2 104 ddd 4 4 3 4 105 eee 5 4 5 4 106 fff 5 6 5 6 107 ggg 5 6 7 6 108 hhh 5 8 8 8 </tbody> For Jan-12 I would get this information...- Bugas
- Thread
- match #value! second occurrence vlookup
- Replies: 11
- Forum: Excel Questions
-
R
How do i Substitue second occurrence of a string within a cell?
Hello, Could anyone suggest how do i Substitue second occurrence of a string within a cell? Cell A1: Port Size","","Female Port Size","1/8" I want to substitute the second occurrence of this "," string with |(pipe). Please suggest me a formula for this. Regards, Raj- rajtak
- Thread
- replace string second occurrence second string subsitute
- Replies: 2
- Forum: Excel Questions
