I have excel 2007 sheet.
I have data from 1 to 9 in A1:I9
In above range some column & row is blank.
Firstly I have find missing number from coulmn & row & those missing number enter in blank column / row.
But during entering missing number no duplicate value reflected in same row or column.
I have attach sample file.
Last edited by avk; 06-29-2013 at 02:45 AM. Reason: rectification in attach file.
Should the missing numbers be entered in column J and row 10?
Will there always be numbers from 1 to 9 only?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Missing numbers enter between a1:i9 column & row in blank cells.
yes number between min. 1 & max 9.
I came up with this UDF but it's still doesn't work for rows :/
Use it as =MISSING_NUM(A1:A9, ",")
Please Login or Register to view this content.
Last edited by zbor; 06-29-2013 at 03:43 AM.
Never use Merged Cells in Excel
@ Zabor,
I tested your code and its working nice for both rows/columns, refer the attached file for reference.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
ThanksSixteenth
Oh, I forgot delimiter in mine solution...
It's working...
Also it gave error if all values are in range... This should solve it:
Please Login or Register to view this content.
Last edited by zbor; 06-29-2013 at 04:04 AM.
Actually i required missing number input in all blank column / row in between a1:i9 but same time no duplicate value reflected in same row or column.
I have attach file & mentioned highlighted comments.
What, you trying to make Sudoku solver?
No actually i am trying to update (branch wise data. Total 09 branches) our "table form" which is update value on weekly base.
It's a typical 9x9 sudoku problem...
Use this .xls file: http://www.mrexcel.com/solveanysudoku.zip
Form this link: http://www.mrexcel.com/tip109.shtml
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks