Hey, I'm trying to get this formula to find each correct value, without finding an incorrect value.
My formula in G2:
ctrl+shift+enterPlease Login or Register to view this content.
Where the final "+0" changes to +1, +2, etc... to get the further results.
Using the formula above, cell G4 gives the incorrect value of 55. I want it to be an error, because the 3rd value is not a "type".
A B C D E F G 1 Standard1 amt1 Type1 111 Type 2 Standard1 amt1 Type2 41 amt2 231 3 Standard1 amt1 Not 1 29 amt2 88 4 Standard2 amt2 Type1 231 amt2 55 5 Standard2 amt2 Type2 88 6 Standard2 amt2 Not 1 55 7 Name1 amt2 Type1 197 8 Name1 amt2 Not 1 52 9 Name2 amt2 Type1 245
Bookmarks