Formula for searching names from two columns
Closed
naumansa
-
Sep 18, 2010 at 04:01 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 18, 2010 at 09:45 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 18, 2010 at 09:45 PM
Related:
- Formula for searching names from two columns
- Tweetdeck larger columns - Guide
- My contacts list names - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Display two columns in data validation list but return only one - Guide
- Count names in excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Sep 18, 2010 at 09:45 PM
Sep 18, 2010 at 09:45 PM
Best to use pivot tables. another method is to use formula . first you have to find out unique items from column A and B and put it in a matrix format. If there a is big data base you can used advancaed filer to get the uniuqe items.
download the file from this webpage
http://www.speedyshare.com/files/24311978/NAUMANASA.xls
and see the formulas in D13 which is copied to other cells in that matrix;
download the file from this webpage
http://www.speedyshare.com/files/24311978/NAUMANASA.xls
and see the formulas in D13 which is copied to other cells in that matrix;
