What Most People Miss About Does Gillette Still Make Sensor Excel

By Lisa Anderson
No, Gillette stopped making Sensor Excel razors in 2019. But if you’re filtering an Excel sheet labeled 'Gillette_Products_2024' and still seeing 'Sensor Excel' in column C, your data is stale — and worse, it’s silently breaking your forecasts.

The Problem

You inherit a spreadsheet named Q3_Inventory_Master.xlsx. It’s got 7,842 rows. Someone told you it’s "updated weekly." You run a quick COUNTIF on column D (Product Line) and get 1,203 matches for "Sensor Excel." That’s impossible — unless your procurement team is hoarding 2017 stock or someone pasted old CSVs into the wrong tab. The real issue isn’t the typo. It’s that "Sensor Excel" appears alongside valid SKUs like "Mach3 Turbo" and "Venus Embrace," but with mismatched attributes: launch dates from 2008, supplier IDs that no longer resolve in SAP, and zero cost-of-goods values in column G. Here’s what 12 sample rows actually look like in A1:H12:
A
ID		 B
SKU		 C
Product Name		 D
Product Line		 E
Launch Date		 F
Supplier ID		 G
COGS ($)		 H
Status
101 GIL-SE-772 Sensor Excel Twin Pack Sensor Excel 2008-04-12 SUP-0082 Discontinued
102 GIL-M3T-441 Mach3 Turbo Refills (4ct) Mach3 2015-09-03 SUP-0119 $2.17 Active
103 GIL-SE-889 Sensor Excel Sensitive Sensor Excel 2006-11-21 SUP-0082 Discontinued
104 GIL-VEN-553 Venus Embrace Shaver Venus 2021-02-17 SUP-0204 $18.95 Active
105 GIL-SE-901 Sensor Excel Comfort Gel Sensor Excel 2007-08-30 SUP-0082 Discontinued
106 GIL-LP-227 Labs ProShield FlexBall ProShield 2019-06-11 SUP-0231 $12.49 Active
107 GIL-SE-772-A Sensor Excel Twin Pack (Old) Sensor Excel 2008-04-12 SUP-0082 Discontinued
108 GIL-FC-334 Fusion5 Power Razor Fusion 2012-01-14 SUP-0145 $24.99 Active
109 GIL-SE-889-B Sensor Excel Sensitive (Refurb) Sensor Excel 2006-11-21 SUP-0082 Discontinued
110 GIL-VEN-553-X Venus Embrace (Export) Venus 2021-02-17 SUP-0204 $19.25 Active
111 GIL-SE-901-C Sensor Excel Comfort Gel (Bulk) Sensor Excel 2007-08-30 SUP-0082 Discontinued
112 GIL-PRO-662 ProGlide Styler ProGlide 2020-11-05 SUP-0240 $32.50 Active
Notice how all rows with "Sensor Excel" in column D have blank COGS, pre-2010 launch dates, and identical Supplier ID (SUP-0082). That’s your smoking gun.

The Solution

Do this. Not “consider doing.” Do it.
  1. In cell I1, type Status Check. In I2, paste this formula:
    =IF(OR(D2="Sensor Excel",ISNUMBER(SEARCH("Sensor Excel",C2))),"FLAG","OK")
  2. Drag I2 down to I7843. Press Ctrl+Shift+L to turn on AutoFilter.
  3. Click the dropdown in column I → uncheck OK → click OK. Now only rows flagged as "FLAG" are visible.
  4. Select all visible rows (click the row numbers — 101, 103, 105, etc.). Right-click → Delete Row.
  5. Turn off AutoFilter (Ctrl+Shift+L again). Save as Q3_Inventory_Clean.xlsx.
That’s it. No macros. No add-ins. Done in under 90 seconds. Here’s what your cleaned table looks like — same columns, now 6,639 rows, zero Sensor Excel entries:
A
ID		 B
SKU		 C
Product Name		 D
Product Line		 E
Launch Date		 F
Supplier ID		 G
COGS ($)		 H
Status
102 GIL-M3T-441 Mach3 Turbo Refills (4ct) Mach3 2015-09-03 SUP-0119 $2.17 Active
104 GIL-VEN-553 Venus Embrace Shaver Venus 2021-02-17 SUP-0204 $18.95 Active
106 GIL-LP-227 Labs ProShield FlexBall ProShield 2019-06-11 SUP-0231 $12.49 Active
108 GIL-FC-334 Fusion5 Power Razor Fusion 2012-01-14 SUP-0145 $24.99 Active
110 GIL-VEN-553-X Venus Embrace (Export) Venus 2021-02-17 SUP-0204 $19.25 Active
112 GIL-PRO-662 ProGlide Styler ProGlide 2020-11-05 SUP-0240 $32.50 Active

Going Further

If you manage multiple brands — not just Gillette — build a master discontinuation list in Sheet2. Put these headers in Sheet2!A1:D1: Brand, Product Line, Last Valid Year, Action. Fill it like this:
  • A2 = "Gillette", B2 = "Sensor Excel", C2 = 2019, D2 = "Remove"
  • A3 = "Schick", B3 = "Quattro", C3 = 2017, D3 = "Flag Only"
  • A4 = "Harry's", B4 = "Truman", C4 = 2022, D4 = "Archive"
Then replace step 1’s formula with:
=IF(COUNTIFS(Sheet2!B:B,D2,Sheet2!C:C,">="&YEAR(E2))>0,"OK",IF(COUNTIF(Sheet2!B:B,D2),"FLAG","OK")) This checks whether the Product Line exists in your master list *and* whether its Launch Date falls within the valid year range. If it doesn’t — flag it. One more tip: Never use FIND() for this. Use SEARCH() instead — it’s case-insensitive. You’ll catch "sensor excel", "SENSOR EXCEL", and "Sensor excel" in one go.

When NOT to Use This

Don’t delete rows if column H (Status) contains "Legacy Replenishment" or "Spare Parts Only". Those might be real — especially in medical or industrial supply chains where obsolete parts stay active for 10+ years. Don’t run this on raw ERP exports before validating with Finance. We once deleted 412 rows tagged "Sensor Excel" — only to find they were rebranded as "GilletteSkinGuard" in SAP but never updated in Excel. And never apply this to merged cells. If A1:A3 is merged and says "Sensor Excel", the formula breaks. Unmerge first (Alt+H+M+U).

Keyboard Shortcuts

Shortcut Action Use Case
Ctrl+Shift+L Toggle AutoFilter Fast filter toggle — beats clicking the Data tab every time
Alt+H+M+U Unmerge Cells Fixes broken formulas in merged ranges
Ctrl+G → Special → Blanks → OK → Ctrl+- → Shift+Space → Enter Delete blank rows fast Use after flagging — deletes entire rows where column G is blank
Ctrl+Shift+→ → Ctrl+Shift+↓ → Ctrl+C Select contiguous data block Skip scrolling — grabs full dataset from active cell
Lisa Anderson

Lisa Anderson

Lisa is a certified Microsoft trainer who writes step-by-step guides for Power Automate