Accounts data requires automatic analysis

Solved/Closed
Report
Posts
1
Registration date
Wednesday September 2, 2015
Status
Member
Last seen
September 2, 2015
-
 249ccjames -
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

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

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