Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.

Nou pe simpatie:
lonely_32 pe Simpatie.ro

Femeie
24 ani
Valcea
cauta Barbat
26 - 57 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] Find Missing Number

Pagini: 1

Moderat de TRaP, TonyTzu

pus acum 5 luni#1

Mrrrr
AdMiN
Postari: 2388

I have a table where I number things manually as I add them. It seems that I skipped a number. MAX(Table1[No]) says 641, but when I select the column it shows a count of 640.

=FILTER(SEQUENCE(641); ISNA(MATCH(SEQUENCE(641); Table1[No]; 0)))

To show in 1 cell instead of a spill, you could:

=TEXTJOIN(", ";TRUE; FILTER(SEQUENCE(641); ISNA(MATCH(SEQUENCE(641); Table1[No]; 0))))

Source: ChatGPT

_______________________________________

Pagini: 1

Mergi la