Formulas, Functions, Formatting, Charts, Data Analysis, etc.
by Randyww » Thu Jul 07, 2016 7:34 pm
I have 20 to 30 account numbers sent to me each day. I have to match them up with a filled or not filled code which is attached to another column of 200 accounts. Is there a way to have the first set interrogate the second set and either change colour or generate a filled or not filled notification.
-
Randyww
- Rookie
-
- Posts: 1
- Joined: Jul 7, 2016
- Reputation: 0
- Excel Version: Excel 2016
by pecoflyer » Fri Jul 08, 2016 2:27 am
Hi
yes there are many techniques.
Please post a sample sheet ( no pics please). Thx
A relevant topic title helps get faster and more answers
-
pecoflyer
- Moderator
-
- Posts: 1274
- Joined: Jan 24, 2012
- Location: Belgium
- Reputation: 39
- Excel Version: 2003/2007/2010
Return to General Excel Questions
Who is online
Users browsing this forum: No registered users and 39 guests