here it is mga gurus.... name middlename lastname in spreadsheet 1 and i want to compare it to spreadsheet 2
any tips and guides to help me on this one.... iam matching names so that i can determine which person have duplicate....
Results 1 to 5 of 5
-
10-09-2013, 10:51 PM #1Newbie
- Join Date
- Apr 2013
- Gender
- Posts
- 34
Need formula in name matching in excel....
-
10-13-2013, 11:43 AM #2C.I.A.
- Join Date
- Oct 2010
- Gender
- Posts
- 2,393
vlookup() migo,...
-
10-13-2013, 06:53 PM #3Newbie
- Join Date
- Apr 2013
- Gender
- Posts
- 34
pls give me the full range unsaon? sample formula lang pls
Originally Posted by _hizuka_
-
10-13-2013, 07:00 PM #4C.I.A.
- Join Date
- Oct 2010
- Gender
- Posts
- 2,393
nay daghan sa google migo....
mao ni syntax: VLOOKUP(keyword na esearch,range sa search,ikapila na column ang item na imong kwaon kung makita ang search)
sample:
kung pangitaon nako ang grado ni hizuka007 mao ni:
A_________B
thomas____ 70
tiban_______80
hizuka007___99
goliat______70
vlookup(A3,A1:B4,2,false)
result: 99
-
11-06-2013, 02:52 PM #5Elite Member
- Join Date
- Dec 2010
- Gender
- Posts
- 1,131
dont forget lang to put $ sign sa A$1:B$4.
Reply With Quote Advertisement
Similar Threads |
|
Posting Permissions
|