Hi, we are trying to untangle some info and put in a helper column to show where "FullSearch" is available.
The trouble we have is that the FullSearch has been jumbled into the same Field as the classifications, hopefully this may try to show what we are trying to do....
Huge thanks for taking a look!
The trouble we have is that the FullSearch has been jumbled into the same Field as the classifications, hopefully this may try to show what we are trying to do....
| FindFullSearch-01-Question.xlsx | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Row | Classification | Helper-01: FullSearch "Identifier" | Manual Notes to ( hopefully!) help explain | |||
| 2 | 2 | Alpha | N | The classifications are arranged A-Z, but the Full Search info has accidentally been jumbled into the classifications. | |||
| 3 | 3 | Alpha | N | Rows 2-5 are all Alpha | |||
| 4 | 4 | Alpha | N | There is no change of classification until Row 6. | |||
| 5 | 5 | Alpha | N | As Row 6 does "not" equal FullSearch, then the Helper Column to see if it contains "FullSearch" remains "N" on all of the rows with "Alpha" (2-5 inclusive) | |||
| 6 | 6 | Beta | Y | Row 6 is Beta. The next change of classification is "FullSearch" (on row 7) so therefore the Helper Column for Rows 6 & 7 are "Y" | |||
| 7 | 7 | FullSearch | Y | ||||
| 8 | 8 | Charlie | Y | Rows 8 to 11 are all Charlie. And the next change of classifcation (i.e. where it does "not" equal Charlie) is "FullSearch" on Row 12, so the helper column will be "Y" for all of the rows where the classification is "Charlie" (rows 8-12 inclusive) | |||
| 9 | 9 | Charlie | Y | ||||
| 10 | 10 | Charlie | Y | ||||
| 11 | 11 | Charlie | Y | ||||
| 12 | 12 | FullSearch | Y | ||||
Sheet1 | |||||||
Huge thanks for taking a look!
