Excelspreadsheet~8 mins

FIND and SEARCH in Excel - Dashboard Guide

Choose your learning style9 modes available

Learn Why Deep Sheet Try Challenge Scenario Recall Dash

Dashboard Mode - FIND and SEARCH

Goal

Find where a word or letter appears in a text to help analyze customer feedback quickly.

Sample Data

Customer	Feedback
Alice	Great product, fast delivery
Bob	Good quality but slow shipping
Carol	Excellent support and fast response
David	Product arrived damaged
Eve	Fast delivery and good packaging

Dashboard Components

KPI Card: Position of word "fast" in feedback using =FIND("fast", B2) for Alice (returns 15)
KPI Card: Position of word "Fast" (case-insensitive) using =SEARCH("Fast", B2) for Alice (returns 15)
Table: Positions of "fast" in all feedbacks using =IFERROR(FIND("fast", B2), "Not found") copied down rows 2-6
Table: Positions of "Fast" (case-insensitive) in all feedbacks using =IFERROR(SEARCH("Fast", B2), "Not found") copied down rows 2-6
Summary: Count of feedbacks containing "fast" (case-sensitive) using =SUMPRODUCT(--ISNUMBER(FIND("fast", B2:B6))) (returns 2)
Summary: Count of feedbacks containing "Fast" (case-insensitive) using =SUMPRODUCT(--ISNUMBER(SEARCH("Fast", B2:B6))) (returns 3)

Dashboard Layout

+----------------------+-----------------------+
|  KPI: FIND Position  |  KPI: SEARCH Position  |
|  (case-sensitive)    |  (case-insensitive)   |
+----------------------+-----------------------+
|  Table: FIND Results  |  Table: SEARCH Results |
|  Positions or "Not"  |  Positions or "Not"  |
+----------------------+-----------------------+
|       Summary Counts (case-sensitive and insensitive)       |
+-------------------------------------------------------------+

Interactivity

Add a filter to select a customer name. When a customer is selected, the KPI cards and tables update to show the FIND and SEARCH results only for that customer's feedback. The summary counts update to reflect how many feedbacks in the filtered list contain the word "fast".

Self Check

If you add a filter for Customer = "Bob", which components update?

KPI cards show FIND and SEARCH positions for Bob's feedback.
Tables show positions or "Not found" only for Bob.
Summary counts update to count only Bob's feedback containing "fast".

Key Result

Dashboard shows where the word 'fast' appears in customer feedback using FIND (case-sensitive) and SEARCH (case-insensitive) with counts and positions.