Need help with VLookUp or need Formula
Closed
Tonya
-
May 2, 2012 at 01:54 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 3, 2012 at 06:24 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 3, 2012 at 06:24 AM
Related:
- Need help with VLookUp or need Formula
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Date formula in excel dd/mm/yyyy - Guide
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
4 responses
tid hash status_desc first mid last
Pending VALDEZ
Fail VALDEZ
Pending BERGEVIN
Fail LYNEMA
Fail BACHLER
Here's the first worksheet...
Here's the 2nd...
Tid Hash status_desc first mid last former
Fail AARONS
Fail ABBOTT
Fail ABDO
Fail ADAMS
Fail ADAMS
Fail ADERHOLT
Pending VALDEZ
Fail VALDEZ
Pending BERGEVIN
Fail LYNEMA
Fail BACHLER
Here's the first worksheet...
Here's the 2nd...
Tid Hash status_desc first mid last former
Fail AARONS
Fail ABBOTT
Fail ABDO
Fail ADAMS
Fail ADAMS
Fail ADERHOLT
that didn't come out correctly. I will re-send via speedyshare once I get to my other computer and resend. Thanks
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 2, 2012 at 06:01 PM
May 2, 2012 at 06:01 PM
there are many site including google docs.
Hello,
Can someone help me with this please?
Here is the link to the file via speedyshare.com
<a href="http://speedy.sh/3vXbQ/TEST-Subjects.xlsx">Download at SpeedyShare</a>
Thank you for your help.
Can someone help me with this please?
Here is the link to the file via speedyshare.com
<a href="http://speedy.sh/3vXbQ/TEST-Subjects.xlsx">Download at SpeedyShare</a>
Thank you for your help.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 2, 2012 at 06:44 PM
May 2, 2012 at 06:44 PM
In your sample book could you put some sample answer too. There seem to be some thing missing here. Both sheets has name repeating. So where this formula that you are looking for goes.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 3, 2012 at 06:24 AM
May 3, 2012 at 06:24 AM
From what I understood from your sheets, the approach that I would suggest would be
1. Copy all the names from sheet "A_Subject" to a new sheet (lets say column A)
2. use "filter-- advance feature" to remove any duplicates (lets say column B)
3. delete column A now
4.you can then use combination of IF, MATCH, SUMPRODUCT function to get what you desired.
1. Copy all the names from sheet "A_Subject" to a new sheet (lets say column A)
2. use "filter-- advance feature" to remove any duplicates (lets say column B)
3. delete column A now
4.you can then use combination of IF, MATCH, SUMPRODUCT function to get what you desired.