Matching a Column in a table
Closed
PJ
-
Sep 7, 2009 at 01:57 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 7, 2009 at 11:25 AM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Sep 7, 2009 at 11:25 AM
Related:
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history.
- Orkut login gmail account - Guide
- Gmail login another account - Guide
- Delete whatsapp account without login - Guide
- Hi5 login old account - Guide
- Free fire account transfer - Guide
1 response
Excelguru
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Sep 7, 2009 at 11:25 AM
Sep 7, 2009 at 11:25 AM
try the array formula =SUM(($A$1:$E$5=$G1)*($A$6:$E$6)) after inserting the formula press CTRL+SHIFT+ENTER
Here $A$1:$E$5 - your data
$G1 - search item
$A$6:$E$6 - a new row contains column values
Here $A$1:$E$5 - your data
$G1 - search item
$A$6:$E$6 - a new row contains column values
