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
Five columns headed Value, Type, Food, Household, Medical.
The data is in Value and Type listed alongside each other.
I wish to have those transferred automatically to their respective Type.
Thank you.
John



columns as values.

1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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
1
Thanks very much Mazzaropi you solved it! Leave the dollars out of B2.A2 and it can be pulled down.

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
0