List required IDs missing from another export
Enter one formula in G5. List IDs from A2:A9 that do not occur in D2:D11, once each, uppercased and in first required-occurrence order. Ignore genuinely blank or empty-text source cells. Compare printable ASCII text IDs literally with case ignored; spaces and leading zeroes remain significant. Return No missing IDs when the difference is empty, including an empty required list.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter one formula in G5. List IDs from A2:A9 that do not occur in D2:D11, once each, uppercased and in first required-occurrence order. Ignore genuinely blank or empty-text source cells. Compare printable ASCII text IDs literally with case ignored; spaces and leading zeroes remain significant. Return No missing IDs when the difference is empty, including an empty required list.
No account. No upload. Just try it.