Formula to find out all the master ID's
Closed
neha
-
Sep 15, 2016 at 11:32 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 15, 2016 at 11:47 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Sep 15, 2016 at 11:47 AM
Related:
- Formula to find out all the master ID's
- Master royale - Download - Strategy
- Typing master pro - Download - Education
- Pokemon fire red cheats rare candy and master ball - Guide
- Yu-gi-oh master duel download pc - Download - Strategy
- Samsung master reset code - Guide
1 response
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Sep 15, 2016 at 11:47 AM
Sep 15, 2016 at 11:47 AM
neha, good afternoon.
You can use a Conditional Format to show them for you.
Suppose:
Master ID --> A1:A100
DATA 1 --> B1:B100
DATA 2 --> C1:C100
DATA 3 --> C1:C100
Item Name --> D1:D100
G1 --> Type a item name to search
Try to do:
Select A1:A100 cells.
CF MENU --> NEW RULE --> USING FORMULA
Type it: =D1=$G$1
Choose the color you want as fill format
OK
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
You can use a Conditional Format to show them for you.
Suppose:
Master ID --> A1:A100
DATA 1 --> B1:B100
DATA 2 --> C1:C100
DATA 3 --> C1:C100
Item Name --> D1:D100
G1 --> Type a item name to search
Try to do:
Select A1:A100 cells.
CF MENU --> NEW RULE --> USING FORMULA
Type it: =D1=$G$1
Choose the color you want as fill format
OK
Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
