Find duplicates across columns in Excel

=ISNUMBER(MATCH(A1,B$1:B$20,FALSE)) will return TRUE if the name in A1 is in the range B1:B20. Enter it in say C1 and copy down as far as necessary. If you AutoFilter the data for column C = TRUE you will see which rows to delete. src: http://www.mrexcel.com/forum/excel-questions/55208-identify-duplicates-between-2-columns.html

Value from previous sheet in Excel

I changed this to not give an error if it finds nothing, but to produce 0. Used for accumulating overtime, so very important you see. Function PrevSheet(Range As Range) Application.Volatile PrevSheet = Application.Caller.Parent.Index If PrevSheet = 1 Then PrevSheet = 0 ElseIf Sheets(PrevSheet - 1).Type <> -4167 Then PrevSheet = CVErr(xlErrNA) Else PrevSheet = Sheets(PrevSheet... Continue Reading →

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑