Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

Match Formula?

Hi,

I have a row of data in column B, there may be data anywhere from B1-B10,000. Can i return to M1, M2, M3 etc any results.

The data in ColB will always be "Double Div"

So if theres an instance return it, i can guarantee this wont happen more than 50 times so i could drag down till then.

Ive attached the file

Thanks
Seamus

CP-Report.zip
0
Seamus2626
Asked:
Seamus2626
  • 4
  • 2
  • 2
2 Solutions
 
StephenJRCommented:
Seamus - do you mean col A? Col B is empty. An instance of what - not clear what you are looking for?
0
 
Rory ArchibaldCommented:
What exactly do you want returned?
0
 
StephenJRCommented:
OK, I think I see now. You want B37, B195 returned in M1, M2 etc?
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Rory ArchibaldCommented:
My best guess - in M7:
=IF(COUNTIF(INDEX(B:B,C7):INDEX(B:B,IF(C8="",65536,C8-1)),"Double Div")>0,"Double Div","")
and copy down.
0
 
Seamus2626Author Commented:
Sorry guys, i have to shoot, i will return first thing Mon Morning.

Thanks for the help

Seamus
0
 
StephenJRCommented:
Perhaps this in M1 and down. An array formula so Ctrl+Shift+Enter:

=IF(ROWS(M$6:M6)<=COUNTIF($B$1:$B$1500,"Double Div"),"B" & SMALL(IF($B$1:$B$1500="Double Div",ROW($M$1:$M$1500)-ROW($M$1)+1),ROWS(M$6:M6)),"")
0
 
StephenJRCommented:
Should be, in M6 and down.
0
 
Seamus2626Author Commented:
Thanks lads, both worked perfectly!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now