S
Steve
I have appx 50 rows of data, each with a name, 3 columns of different volume,
and hours:
Col A -name
Col B - Vol 1
Col C - Vol 2
Col D - Vol 3
Col E - Hours
I'd like formulas in the cells in the F & G columns to check if there is
volume in B1, C1, or D1, and if hours in E1. If there is vol but no hours for
row 1, I'd like F1 to produce -> A1 &"had vol but no hours".(see below)
And also, if no volume in either B2, C2, or D2, but hours in E2,
I'd like G2 to produce ->A2 &"has hours but no vol" (see below).
And if volume in either col's B, C or D, and Hours in E, then nothing in F3
& G3.
And down trhough all 50 rows.
A B C D E F G
Jim 0 0 12 0 Jim had vol but no hrs
Tim 0 0 0 8 Tim has hrs but no
vol.
Kim 3 0 0 8 "" ""
Thanks,
Steve
and hours:
Col A -name
Col B - Vol 1
Col C - Vol 2
Col D - Vol 3
Col E - Hours
I'd like formulas in the cells in the F & G columns to check if there is
volume in B1, C1, or D1, and if hours in E1. If there is vol but no hours for
row 1, I'd like F1 to produce -> A1 &"had vol but no hours".(see below)
And also, if no volume in either B2, C2, or D2, but hours in E2,
I'd like G2 to produce ->A2 &"has hours but no vol" (see below).
And if volume in either col's B, C or D, and Hours in E, then nothing in F3
& G3.
And down trhough all 50 rows.
A B C D E F G
Jim 0 0 12 0 Jim had vol but no hrs
Tim 0 0 0 8 Tim has hrs but no
vol.
Kim 3 0 0 8 "" ""
Thanks,
Steve