Accounts data requires automatic analysis
Solved/Closed
249ccjames
Posts
1
Registration date
Wednesday September 2, 2015
Status
Member
Last seen
September 2, 2015
-
Sep 2, 2015 at 11:48 AM
249ccjames - Sep 2, 2015 at 06:04 PM
249ccjames - Sep 2, 2015 at 06:04 PM
Related:
- Accounts data requires automatic analysis
- Transfer data from one excel worksheet to another automatically - Guide
- Nvidia automatic driver detection tool - Guide
- Tmobile data check - Guide
- Data transmission cable - Guide
- Digital data transmission - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 2, 2015 at 12:30 PM
Sep 2, 2015 at 12:30 PM
249ccjames, Good afternoon.
Attention: Next time attach an Excel File NOT an image!
Suppose your table start at A1.
Try to use:
=IF(C$1=$B2,$A2,"")
Copy it down and to the right as necessary.
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Attention: Next time attach an Excel File NOT an image!
Suppose your table start at A1.
Try to use:
=IF(C$1=$B2,$A2,"")
Copy it down and to the right as necessary.
Is that what you're looking for?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Sep 2, 2015 at 06:04 PM
I agree excel file would have been best but not possible as forum requires PNG, gif,BMP or JPEG. I appreciate your time spent
Cheers