-
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.
pns
-
D
Combine complex arrays
I am combining data in several columns into one single column using this formula: =OFFSET($F$2:$F$509,MOD(ROW()-ROW(ColumnData1),ROWS($F$2:$F$509)),TRUNC((ROW()-ROW(ColumnData1))/ROWS($F$2:$F$509),0),1,1) Then I'm using this formula to ignore blank and zero cells, round the number and only look...- drluke
- Thread
- city council county pns rec
- Replies: 1
- Forum: Excel Questions
-
R
Require macro
Hello, PN's in each row are alternate to each other but they are repeated in other rows in different order / sequence Example - PN's in 1st row are also in row 3,5 & 7. Output requirement - I need to retain only 1 row which has the maximum alternate parts and delete the remaining rows. In...- Ron99
- Thread
- delete pns retain row rows
- Replies: 8
- Forum: Excel Questions
-
E
sum function but row dependent on value
Hi. I have a table with various PN's in rows with different groupings (IE Forecast, Sales, Return ) and week numbers in columns on sheet 1. On sheet 2, I want to be able to summarize forecast by summing 3 weeks at a time by group by PN. Data <tbody> PN Week 1 2 3 4 5 6 7 8 9 123 Forecast 3...- EdE
- Thread
- forecast pns returns sales sheet
- Replies: 4
- Forum: Excel Questions
