hi guys, i have a table with forty five numbers, what i want is to extract in a column the numbers they did not appeared at all.thank you!
hi guys, i have a table with forty five numbers, what i want is to extract in a column the numbers they did not appeared at all.thank you!
just the values the did not pull out from the box! please see example at the workbook i attached.
thanks again from my heart
Please try M2 copy down
=IFERROR(AGGREGATE(15,6,$A$1:$J$5/NOT(COUNTIF($E$10:$E$32,$A$1:$J$5)+($A$1:$J$5="")),ROWS(M$2:M2)),"")
Using helper columns.
2d matrix to column 'M':
Test if missing from random list:![]()
Please Login or Register to view this content.
List of missing numbers (array entered** in column O):![]()
Please Login or Register to view this content.
**...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.![]()
Please Login or Register to view this content.
Ben Van Johnson
thanks proton!is working!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks