Hi, I am trying to format some data to put it in a view that I need (see attached screenshot). The data I am starting with is in column A-E. I want to be able to remove the duplicates from Column A & B but take the program names (5 different ones total) from column E and transpose them like shown and get the quantities for each CCA/SIDE like I wrote in. I am dying with this trying to figure out what formula I should be using for this.
Excel formula to SUM Columns
- Thread starter Nu2Java
- Start date
SirJB7
Excel Rōnin
Hi, Nu2Java!
A few doubts:
a) "** I need column C & E to go away now that I have a formula in F:J showing quantities"
If going away means hiding then no problem, otherwise you can't as you're using those columns in the F:J cell formulas.
b) "** Starting with Column A, I need the duplicates to go away but when I do that, the data gets messed up
*** Good example is line 32&33"
Data in column A is the same, but is different in columns C:E. It's related to a) too.
Regards!
A few doubts:
a) "** I need column C & E to go away now that I have a formula in F:J showing quantities"
If going away means hiding then no problem, otherwise you can't as you're using those columns in the F:J cell formulas.
b) "** Starting with Column A, I need the duplicates to go away but when I do that, the data gets messed up
*** Good example is line 32&33"
Data in column A is the same, but is different in columns C:E. It's related to a) too.
Regards!
Hi SirJB7, I should have clarified that. I will turn the sheet into values when printing so C & E can go away. To get F:J, I created a separate list of E, removed duplicates and then transposed. So like line 32 & 33, I just need one of those lines now as my quantities are in F:J under the associated program name.
SirJB7
Excel Rōnin
Hi, Nu2Java!
Maybe it's my usual dumbness but I don't understand your point.
And what about C data?
Regards!
Maybe it's my usual dumbness but I don't understand your point.
You usually print values, not formulas, so nothing to be turned from x-thing into y-thing.
And against which data are you going to compare/check this unique ex-E data?
And what about C data?
Regards!
NARAYANK991
Excel Ninja
Hi ,
See the attached file , and comment as to whether your problem is resolved or not.
1. The cells G1 through T1 have a formula in them , to extract the unique data items from the ones in column E.
2. Column F has a formula to determine the duplicates ; all duplicates are identified by values greater than 1.
3. Applying an AutoFilter to column F , and selecting 1 in the filter dropdown , hides all the duplicates.
4. Before printing , you can hide columns C , E and F.
Narayan
See the attached file , and comment as to whether your problem is resolved or not.
1. The cells G1 through T1 have a formula in them , to extract the unique data items from the ones in column E.
2. Column F has a formula to determine the duplicates ; all duplicates are identified by values greater than 1.
3. Applying an AutoFilter to column F , and selecting 1 in the filter dropdown , hides all the duplicates.
4. Before printing , you can hide columns C , E and F.
Narayan
@NARAYANK991, Thank you... I think I can work with this.
@SirJB7, Thank you for your time. Sorry for the confusion, I think I was having a harder time trying to explain what I needed in words.
@SirJB7, Thank you for your time. Sorry for the confusion, I think I was having a harder time trying to explain what I needed in words.