Hi guys
Hope you all are doing just great, Please I have a slight issue and how to get around this
Am trying to count Column column A and I need my result in Column B based on the criteria
Example of what I need:
in column A I have 1 repeated twice, so I will need column B to count as 2 and when i drag down I need the next to be blank
I need the same result as this on the table
Appreciate your support
Hope you all are doing just great, Please I have a slight issue and how to get around this
Am trying to count Column column A and I need my result in Column B based on the criteria
Example of what I need:
in column A I have 1 repeated twice, so I will need column B to count as 2 and when i drag down I need the next to be blank
I need the same result as this on the table
Appreciate your support
| Range | Count |
1 | 2 |
1 | |
2 | 1 |
3 | 1 |
4 | 2 |
4 |
| Data build up for Presentation( 23)update.xlsx | ||||
|---|---|---|---|---|
| A | B | |||
| 132 | Count | |||
| 133 | 1 | 2 | ||
| 134 | 1 | 2 | ||
| 135 | 2 | 1 | ||
| 136 | 3 | 1 | ||
| 137 | 4 | 2 | ||
| 138 | 4 | 2 | ||
2023_Data_Vessel_Trip | ||||
| Cell Formulas | ||
|---|---|---|
| Range | Formula | |
| A132:A138 | A132 | =IFERROR(MATCH(DAY(H132),{1,8,15,22,29}),"") |
| B133:B138 | B133 | =SUMPRODUCT(($A$133:$A$138=$A133)*($A$133:$A$138>0)) |
