Correcting a formula to remove old references

[avidcat]

In this formula:

=IF(AND(OR(AND(Search!$B$2="ALL",OR(Search!$M$3="",N3=Search!$M$3))),OR(AND(Search!$B$4="All",OR(Search!$M$5="",O3=Search!$M$5)),AND(B3=Search!$B$4,OR(Search!$M$5="",O3=Search!$M$5))),OR(Search!$B$6="ALL",G3=Search!$B$6),OR(Search!$B$7="ALL",H3=Search!$B$7),OR(Search!$B$8="ALL",I3=Search!$B$8),OR(Search!$B$9="",ISNUMBER(SEARCH(Search!$B$9,J3))),OR(IF(ISNUMBER(Search!$X$29),AND(C3>=TODAY()-Search!$X$29,C3<=TODAY()),AND(C3>=Search!$B$10,C3<=Search!$B$11)))),COUNT(K$2:K2)+1,"")

I need to remove referrences to: $M$3, N3, $M$5, and O3.

Here is a screen shot of the highlighted code:
Formula.PNG

When I try to do it I mess up the original coding.

Thanks for any help,
Nick

[FDibbins]

not every1 can open .png files, myself included. It would be far better if you could upload a sample of your file, showing what you have, and an example of your expected outcome. Thanks

edit: however, looking at your formula, would this work for you?....

Please Login or Register  to view this content.

[ConneXionLost]

How about this:

Please Login or Register  to view this content.

[avidcat]

Thanks for the help, attached is a sample. I input your code FDibbins, it works except for the drop down on B2 on the Search Sheet.

I attached a sample file.

Thanks for the help.
Nick

[FDibbins]

the formula you gave in your 1st post is not the same as the formulas in your file. i will work on your file and see what i can come up with

[avidcat]

Sorry your right, I deleted two two rows on the Search Sheet that were not being used, that probably changed the cell references.

[FDibbins]

in your formula, what is...ISNUMBER(SEARCH(Search!$B$9,J3))),...supposed to be doing? you seem to have an extra search in there?

[avidcat]

Someone originally made the formula for me, I edited as needed. It's possible that something might have been left where it was not needed.

[FDibbins]

ok, i can understand that, hoever the entire formula is a bit of a mess, and is very confusing to edit.

can you walk me thu what you are trying to achieve, i can probably reconstruct your formula in a far simpler way?

[FDibbins]

I will (probably) be unavailable for the next 2 day, if you can wait that long, cool, if not maybe some1 else can help you?

[avidcat]

Sure. The sheet named "Data" is where we input all the information. The sheet named "Search" is where we can narrow down the search.

For example we can search by employee, Observed By, ACT, Appearance, Pass All, and Comments or any combination of all those.

The track back days on the "Search" sheet is the amount of days back it will pull data from, unless a start date and end date are entered on the "Search Sheet"

[avidcat]

No problem, I will leave this till tomorrow afternoon. If no other replies I can start a new post with my most updated information.

Thanks for looking.