Forum Discussion
Merged Cells Causing Problems!
I'm working a project with a large data set (>500,000 rows, 5 columns). The columns are the date, order number, invoice number, Amount A, and Amount B. There should only be ONE line for each invoice ...
you can create a third helper columns and use the IF function.
try this on a copy of the workbook.
lets sau your invoice number is in Column A .
Select the range of the merged cells which is the column A
Unmerge the cells
Home -> Find and Select -> Go to special... -> Blanks -> ok
Type "=" move one cell up and press Ctrl + Enter
this will enter Fill with Duplicate invoice numbers in Column A then
use a helper column, lets say your value 63.27 and 0.77 are in column B and C
then in helper column D put this formula =IF(B2<>"",B2,IF(C2<>"",C2,"")) and copy down.
see if this works for you.