-
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.
How to write if condition
- Thread starter guptasweb
- Start date
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,548
- Office Version
- 365
- Platform
- Windows
What rows?
Upvote
0
| RawData.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | North American Forging 2024 OEE Scorecard | |||||||||||||
| 2 | Plant | Press | Target | JAN-2024 | FEB-2024 | MAR-2024 | APR-2024 | MAY-2024 | JUN-2024 | JUL-2024 | AUG-2024 | |||
| 3 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | ||||||
| 4 | AHMC | Line 1 | 65.0% | 49.0% | 56.5% | 50.0% | 55.0% | |||||||
| 5 | Line 2 | 65.0% | 41.0% | |||||||||||
| 6 | Line 3 | 65.0% | 43.0% | 55.4% | 46.0% | 45.0% | ||||||||
| 7 | Line 6 | 65.0% | 41.0% | 43.0% | 53.0% | 40.0% | ||||||||
| 8 | Line 7 | 65.0% | 55.0% | 56.3% | 63.0% | 66.0% | ||||||||
| 9 | 10R80 | 85.0% | 72.0% | 72.0% | 73.4% | 73.0% | ||||||||
| 10 | S1 Line | 85.0% | 70.0% | 71.0% | 69.0% | 71.0% | ||||||||
| 11 | S4 Line | 85.0% | 71.0% | 74.6% | 74.3% | 72.0% | ||||||||
| 12 | CD6 | 85.0% | 74.0% | 79.0% | 76.0% | 81.0% | ||||||||
| 13 | ||||||||||||||
| 14 | Plant | Press | Target | JAN-2024 | FEB-2024 | MAR-2024 | APR-2024 | MAY-2024 | JUN-2024 | JUL-2024 | AUG-2024 | |||
| 15 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | ||||||
| 16 | CIMF-2 | Line 1 | 65.0% | 51.9% | 55.5% | 56.8% | 60.9% | |||||||
| 17 | Line 2 | 65.0% | 53.1% | 53.0% | 51.8% | 61.8% | ||||||||
| 18 | ||||||||||||||
| 19 | Plant | Press | Target | JAN-2024 | FEB-2024 | MAR-2024 | APR-2024 | MAY-2024 | JUN-2024 | JUL-2024 | AUG-2024 | |||
| 20 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | ||||||
Actual | ||||||||||||||
Upvote
0
I want to remove row no 14& 15,19&20 and so on
Upvote
0
Scott Huish
MrExcel MVP
- Joined
- Mar 17, 2004
- Messages
- 20,548
- Office Version
- 365
- Platform
- Windows
It will take VBA to do that, but since those are the only lines other than the top headers that are bold, you should just be able to check for that.
VBA Code:
Sub RemoveDuplicateHeaders()
Dim x As Long, y As Long
x = Range("L" & Rows.Count).End(xlUp).Row
For y = x To 4 Step -1
If Cells(y, 12).Font.Bold = True Then Rows(y).Delete
Next
End Sub
Upvote
0
Similar threads
- Question
