Accounts data requires automatic analysis [Solved/Closed]

Question

Accounts data requires automatic analysis [Solved/Closed]

Report

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.

Accounts data requires automatic analysis
Disabled instagram payment account is required to submit this form. - How-To - Instagram
How to delete facebook account data - How-To - Facebook
Orkut account data recovery - How-To - Web
Recover old photos from Orkut ✓ - Forum - Google
Transfer data from one excel worksheet to another automatically - How-To - Excel

1 reply

Ask a question

Mazzaropi · Accepted Answer · 2015-09-02T12:30:08-0400

Answer 1 / 1

Mazzaropi

Posts: 1934
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: July 21, 2021

144
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

Report

249ccjames
Sep 2, 2015 at 06:04 PM

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

Accounts data requires automatic analysis [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!