-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
cde
-
Sumproduct/Match
I am having a brain block. I have 4 columns with number and label. a1:a30 are numbers, b1:b30 are labels. C1:c30 are numbers, D1:D30 are labels All in random order. I am trying to match the labels in column B to the label in Column D and then add the 2 numbers corresponding numbers in column...- JTL9161
- Thread
- cde column label labels numbers
- Replies: 3
- Forum: Excel Questions
-
E
Count unique value with multiple criteria in a range
<tbody> Customer Name Customer Add ABC Add 1 ABC Add 2 CDE Add 3 BFE ( CDE Finance) Add 3 </tbody> Hi guys, I have a set of data consist of the below: - Customer Name - Customer Address - Status - Owner - Type I would like to count the number of customer with criteria 1...- ExcelLearner_
- Thread
- add array cde count unique value customer
- Replies: 7
- Forum: Excel Questions
-
K
Macros : to copy the number down
Hello, I have 100 GL accounts and each GL has the same list of projects, as example- six projects. I need to copy each GL account down for each project. Can you help to write a Macro to automate this process? <colgroup><col style="mso-width-source:userset;mso-width-alt:3876;width:80pt"...- Kazdima
- Thread
- abc bcd cde def fgh
- Replies: 12
- Forum: Excel Questions
-
E
Turning data Horizontal to logical table based
hello, I have data like below. Family_Name | People In the Family ABC | 1a| 2a|3a|4a|5a CDE | 1b|2b| 3b| FGH | 1c| IJK |1d| 2d| 3d|4d| Like above I have like 15columns*5000 rows of data but I want to see it like below ABC 1a 2a 3a 4a...- exllearner
- Thread
- cde columns data pivot 2016 powerquery
- Replies: 7
- Forum: Power Tools
