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
1842
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
October 27, 2020
136
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 2942 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