Forum Discussion
Formula Assistance
I would like to know if there is a formula that will take an entry made with initials of employees in one column with an entry made with number in another column and put the number value into a speci...
What’s the relationship of B2:B3 to A2:A3? Also, what results do you want to be returned in C2:C3?
Column A would be initials of different employees, so it would contain multiple different values. Column B is a quantity of material packaged. What I am looking to do is have excel move the values from Column B to a specific cell in Column C that is assigned to each individual employee and be auto summed.
- No formula can move B2:B3 to C2:C3. You still haven’t answered my question. What results do you want to be returned in C2:C3?
If the same as B2:B3, the formula in C2 is simply:
=B2I hope this is better, as I am obviously not an expert excel user!
What I am looking for is a formula that will take the values in the B column, based on the values in the A column, and put them into the D column. Also would like the D column to auto sum the numbers from the B column. The colors are just used for illustration purposes.
