Reputation
4,292
Top tag
Next privilege 5,000 Rep.
Approve tag wiki edits
Badges
4 25
Newest
 Yearling
Impact
~323k people reached

Sep
17
reviewed Reject Splitting the string by space?
Sep
11
comment How to change a chart's orientation in Excel 2013?
@downvoter: care to explain what is so wrong so I can make the answer better?
Apr
23
awarded  Yearling
Apr
17
answered Splitting the string by space?
Sep
30
awarded  Explainer
Sep
29
awarded  worksheet-function
Jul
24
revised Apply a formula to an entire column since the number of rows is changing from a source file?
Added tag
Jul
24
comment Apply a formula to an entire column since the number of rows is changing from a source file?
Ok... I don't know enough VBA either to help you on this problem. Hopefully someone else will be able to help you :)
Jul
24
comment Apply a formula to an entire column since the number of rows is changing from a source file?
You could fill the entire column with a formula and make it not display anything if the row it's on is empty. Otherwise if that's not an option, I'd say you'd need VBA.
Jul
18
comment Last occurence in a “right vlookup”
@Guest01 No problem. I was travelling and couldn't get on till now.
Jul
18
revised Last occurence in a “right vlookup”
Fix cell ref
Jul
18
comment Last occurence in a “right vlookup”
@Guest01 Oh yes oops. Sorry about that. I had V in A1 in my test worksheet to confirm the formula. I can write them without testing, but I prefer making sure they work :)
Jul
18
answered Last occurence in a “right vlookup”
Jul
18
comment Last occurence in a “right vlookup”
Is the column freq sorted? You could use an array formula for that, but it'll be easier if it is sorted.
Jul
8
revised Embedded IF(OR(IF) statement
Oops, horribly didn't type what I meant
Jul
7
comment Embedded IF(OR(IF) statement
@EoinOliver Ok, great! :)
Jul
5
comment Embedded IF(OR(IF) statement
Thank you, and no worries, it takes some time to get used to how the stackexchange sites work :)
Jul
5
answered Embedded IF(OR(IF) statement
Jul
5
comment Embedded IF(OR(IF) statement
Edit your question please.
Jul
5
comment Embedded IF(OR(IF) statement
I find it hard to understand what you are looking for. Your formula does not 'look for a string of text inside a cell', it only checks whether it's blank or not. Next, what if the three cells are not blank and contain different words? What word should be taken to the final column?