E
ebt
I am not very skilled in Excel and am hoping someone might be able to
give me some guidance. I'm creating a document in which I will have
two charts, the first being a list of names followed by three columns
of categorical information.
Here are three example entries in this chart: "Smith" "XX" "YY" "ZZ";
"Jones" "YY" "WW" "[blank]"; "Anderson" "ZZ" "[blank]" "[blank]"
The second chart is somewhat the reverse of the first, as I would like
a column for each of the results in the first chart ("WW", "XX", "YY",
"ZZ"), and want to fill in these columns with the corresponding names
from the first chart (so in the "XX" column I would have "Smith", in
the "YY" column I would have "Smith" and then "Jones", etc.).
As I add names to the first chart I'd like the information to
automatically fill in on the second chart under their respective
categories.
The best function I've been able to come up with to use in the second
chart is (example for the "XX" column)
IF(OR(B:B="XX", C:C="XX", D
="XX"), A:A, "")
but this only looks at the data from the same row in the first chart,
which is a problem because I'd like the lists of names in the second
chart to begin immediately under the column titles and appear
consecutively beneath each other without any gaps.
I hope this made sense and I thank you for your time in reading this,
any suggestions are greatly appreciated.
give me some guidance. I'm creating a document in which I will have
two charts, the first being a list of names followed by three columns
of categorical information.
Here are three example entries in this chart: "Smith" "XX" "YY" "ZZ";
"Jones" "YY" "WW" "[blank]"; "Anderson" "ZZ" "[blank]" "[blank]"
The second chart is somewhat the reverse of the first, as I would like
a column for each of the results in the first chart ("WW", "XX", "YY",
"ZZ"), and want to fill in these columns with the corresponding names
from the first chart (so in the "XX" column I would have "Smith", in
the "YY" column I would have "Smith" and then "Jones", etc.).
As I add names to the first chart I'd like the information to
automatically fill in on the second chart under their respective
categories.
The best function I've been able to come up with to use in the second
chart is (example for the "XX" column)
IF(OR(B:B="XX", C:C="XX", D
="XX"), A:A, "")but this only looks at the data from the same row in the first chart,
which is a problem because I'd like the lists of names in the second
chart to begin immediately under the column titles and appear
consecutively beneath each other without any gaps.
I hope this made sense and I thank you for your time in reading this,
any suggestions are greatly appreciated.