Search results

Happened upon this thread while looking for a solution to apply conditional formatting to only one row in a cell ... and I hear you, Chandoo Ninjas - constants only (my environment prevents the use of code/vba). So then, I wonder if one can take a cell that contains a formula that concatenates...

I think that I have it mostly solved; using Luke M.'s Formula Forensics # 003 model, 1. I added a new worksheet "Sheet 2" and added two column titles - "Copied Type" and "Copied Name" 2. "Copied Type" contains formula: =IF(Sheet1!$A:$A=Sheet1!$D$2, Sheet1!$A:$A, "") 3. "Copied Name" contains...

Greetings - I happened upon salmonchild's dilemma while researching how to copy rows that matched criteria to another worksheet *without* code/macros. Was anyone able to resolve this? I was able to accomplish this same functionality using an Advanced Filter, however the Advanced Filter must be...

do not read this again.

I've always used =Mod(Row(),2) ... what does the <>0 do? Thanks!

Hazaa! NARAYANK991 & SirJB7 have done it! Thank you all so much for helping me solve this riddle. Such is the beauty of life, that when an answer comes to light, so are new questions illuminated =) |||||[ MANY THANKS TO ]||||| NARAYANK991 & SirJB7 & kchiba

Apologies for the misaligned post, and thank you for the warm welcome.

Wow - Thank you for all for your responses! SirJB7: I searched rather extensively but was unable to locate a solution. kchiba: i like your helper column approach for other uses, however, i am trying to get start and end cell addresses for multiple values/matches in a single column. using my...

column A has many rows containing 123, ABC, or XYZ. column A is already sorted. i use the following forumla to return the address of the fist cell matching ABC: =ADDRESS(MATCH("ABC",A:A,0),2) i would like to do something similar to either return the address of the last cell in column A that...

greetings. i happened upon chandoo.org while researching an excel challenge that i am currently facing - i hope to contribute as well!