Microsoft Office Forums - View Single Post - [Solved] searching a range using a value in another cell

Thread: [Solved] searching a range using a value in another cell

View Single Post

Old

05-11-2015, 04:26 AM

beginner

beginner is offline

beginner uses Windows 7 32bit

Windows 7 32bit beginner uses Office 2007

beginner uses Office 2007

Office 2007

Advanced Beginner

Join Date: Sep 2011

Location: Europe

Posts: 45

beginner will become famous soon enough

Default

On Sheet2 try in cell B2 enter the formula and copy it down

Code:

=COUNTIF(Sheet1!$A$2:$C$6,A2)
or
=COUNTIF(Sheet1!$B$2:$C$6,A2)

Reply With Quote