Microsoft Office Forums - View Single Post - How can I delete the content of a cell in column if the cell value is more than 1000?

Thread: How can I delete the content of a cell in column if the cell value is more than 1000?

View Single Post

Old

06-27-2011, 04:34 AM

Colin Legg Colin Legg is offline

Colin Legg is offline

Colin Legg uses Windows 7 32bit

Windows 7 32bit Colin Legg uses Office 2010 32bit

Colin Legg uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

Colin Legg will become famous soon enough

Default

Hi,

Filter column B for values greater than 1000 and then delete the visible rows.

Reply With Quote