Vlookup
Closed
Lost
-
Jul 4, 2009 at 03:05 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 4, 2009 at 11:03 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 4, 2009 at 11:03 PM
Related:
- Vlookup
- If iserror vlookup - Guide
- Transfer data from one excel worksheet to another automatically vlookup - Guide
- Automatically transfer data from one sheet to another ✓ - Excel Forum
- Using Vlookup to return insted of 00/01/1900 ✓ - Excel Forum
- Removing "FALSE" from an IF statement with a VLOOKUP ✓ - Excel Forum
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Jul 4, 2009 at 11:03 PM
Jul 4, 2009 at 11:03 PM
Hi Lost
Try =countif(a1,sheet1!A:A) in sheet 2 cell B1 and then sort/filter
Try =countif(a1,sheet1!A:A) in sheet 2 cell B1 and then sort/filter
