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 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
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