order - Ordering the third column in excel according to first column (and fill blanks) -
i have 3 columns, 2 first columns have identical values, third 1 has values missing (below nr. 2 & 4 missing). so how can "order" these: +---+---+---+ | | b | c | +---+---+---+ | 1 | 1 | 1 | | 2 | 2 | 3 | | 3 | 3 | 5 | | 4 | 4 | | | 5 | 5 | | +---+---+---+ to become: +---+---+---+ | | b | c | +---+---+---+ | 1 | 1 | 1 | | 2 | 2 | 0 | | 3 | 3 | 3 | | 4 | 4 | 0 | | 5 | 5 | 5 | +---+---+---+ as can see, values missing being (i.e. should be ) filled zero. numbers above unique (i.e. can't have 2 4's in same column). how can same values column c right next column b (and can fill empty fields zero). assuming have row 1 headers... create new column d formula in d2= =iferror(vlookup(a2,c:c,1,false),0) drag down , copy/paste special values columns d , delete column c