T
Tomkat743
ba1 ba2 ba3 bb1 bb2 bb3 bc1 bc2 bc3
1 1 i want to return
ba2 and bb2
1 1 1 (1) i want to return
ba1, ba3, bb3, -bc2
1 i want to return
bb1
i want to keep row one information "ba2 and bb2" in row one. Actually row 2
information since row one has the header row. So the ba2 in this senario
would report in j2 and bb2 would report in k2.
Sometimes the codes are for removal and report as a negative can i turn
these red?
i know i could make it work with vlookup but i have 60 columns and usually
only 3 or 4 codes are used so i would like to have them together. Any help
would be greatly appreciated.
1 1 i want to return
ba2 and bb2
1 1 1 (1) i want to return
ba1, ba3, bb3, -bc2
1 i want to return
bb1
i want to keep row one information "ba2 and bb2" in row one. Actually row 2
information since row one has the header row. So the ba2 in this senario
would report in j2 and bb2 would report in k2.
Sometimes the codes are for removal and report as a negative can i turn
these red?
i know i could make it work with vlookup but i have 60 columns and usually
only 3 or 4 codes are used so i would like to have them together. Any help
would be greatly appreciated.