excel

By -

Yes, ✅ you can do this directly in Excel using a formula — no code or external tool required.

Here’s how you can achieve the same logic using a formula in Column N of the "Icon Tracker" sheet:

🧠 What You Want:

For each row:

  • Check if value in Column M exists in Column G of the "ICON management" sheet.
  • If not found and the value is not "NA", show:
    "Icon not present in management Sheet".
  • If value is "NA" → leave blank.

✅ Excel Formula for Column N (e.g., N2):

=IF(OR(M2="NA", ISNUMBER(MATCH(M2, 'ICON management'!G:G, 0))), "", "Icon not present in management Sheet")

💡 Explanation:

Part Meaning
M2="NA" Checks if current row's value in Column M is "NA" (case-sensitive, use LOWER() for case-insensitive).
MATCH(M2, 'ICON management'!G:G, 0) Looks for M2's value in Column G of "ICON management". Returns row number if found.
ISNUMBER(...) If MATCH returns a number → the value was found.
OR(...) If either condition is true → leave cell empty.
"Icon not present in management Sheet" Shown if value not found and not "NA".

📍 Steps:

  1. Open the "Icon Tracker" sheet.
  2. Go to cell N2.
  3. Paste the formula:
=IF(OR(M2="NA", ISNUMBER(MATCH(M2, 'ICON management'!G:G, 0))), "", "Icon not present in management Sheet")
  1. Drag it down to fill all rows in Column N.

📝 Optional: Make it Case-Insensitive for "NA"

Use:

=IF(OR(LOWER(M2)="na", ISNUMBER(MATCH(M2, 'ICON management'!G:G, 0))), "", "Icon not present in management Sheet")

Let me know if you want to:

  • Highlight unmatched rows with conditional formatting.
  • Filter or count unmatched rows.

Excel is powerful — you can absolutely do this without coding!

Comments

Post a Comment

Popular posts from this blog

My work

By -
 Here's the PowerPoint slide data using only the first and second responses (which covered Figma REST API accessible data and a categorized API list): --- 🎯 Slide 1: Title Slide Title: Accessing Figma Data via REST API Subtitle: What’s Possible and What’s Not with Figma’s API --- ✅ Slide 2: What You Can Access via Figma REST API File & Design Data (Read-only): File metadata (name, modified date, version) Document structure (pages, frames, groups, nodes) Colors, fonts, layout, vectors, strokes, effects Local & team components Export images (PNG, JPG, SVG, PDF) Comments (read, post, resolve) Version history Project and team data (for Org accounts) --- ❌ Slide 3: What You Cannot Access via API Limitations: No write/edit of nodes or layout Cannot simulate or control prototypes No real-time collaboration info (like cursors) No plugin execution Cannot access plugin-specific or private data No access to interactions/animations execution --- 🌐 Slide 4: Key API Endpoints Purpose E...
Read more

color change

By -
using System; using System.Runtime.InteropServices; using Excel = Microsoft.Office.Interop.Excel; namespace ExcelRedToBlack {     class Program     {         static void Main(string[] args)         {             Console.WriteLine("Enter full path to the Excel file:");             string filePath = Console.ReadLine();             if (string.IsNullOrWhiteSpace(filePath))             {                 Console.WriteLine("Invalid file path.");                 return;             }             Excel.Application excelApp = null;             Excel.Workbook workbook = null;             try         ...
Read more