Find entries in a sheet available or not

AFZAL SOHAIL

Board Regular
Joined
May 31, 2023
Messages
146
Office Version
  1. 2021
  2. 2016
Platform
  1. Windows
Dear Team,
I need your help, I have an excel file I need a formula to find out the entries in col-C is available in Col-G or not, if available then highlights this row also
I attached the file:
Thanks a lot.
SR.NO.NamePositionJoining Date
Sr.No.​
Name​
Designation​
1​
Hafiz Hussain Ahmad​
Network Technician​
08-01-24​
1​
Zulfiqar Ali​
Associate Network Technician​
2​
Hafiz M Babar Ishaq​
Supervisor - Deployment​
29-02-24​
2​
muhammad Arif Anjum​
Associate Network Technician​
3​
Basit Aziz Ullah​
Executive - Deployment​
29-01-24​
3​
Muhammad Ilyas​
Associate Network Technician​
4​
Muhammad Suleman​
Supervisor - Deployment​
13-02-24​
4​
RAI M Zergham KHAN​
Associate Network Technician​
5​
Hamid Maqbool​
Sr. Network Technician​
23-04-19​
5​
Muhammad Tariq Hanif​
Associate Network Technician​
6​
Syed Ali Raza​
Supervisior - QA​
20-02-24​
6​
Abdul Hannan Ali​
Associate Network Technician​
7​
Mehmood Ali Khalid​
Supervisor - Field Operations​
01-02-24​
7​
Muhammad Daud Malik​
Associate Network Technician​
8​
Wali Ur Rehman​
Network Technician​
21-05-15​
8​
Ali Sanwal​
Associate Network Technician​
9​
Shahid Nazir​
Rigger​
01-01-16​
9​
Syed Asad Ali​
Associate Network Technician​
10​
Muhammad Haseeb Javed​
Supervisor - Deployment​
01-02-24​
10​
Talha Naveed​
Associate Network Technician​
11​
Muhammad Hamza Javed​
Team Lead - Deployment​
29-01-24​
11​
Arslan Ahmad​
Associate Network Technician​
12​
Abdullah Raza​
Technical Support Associate​
07-12-22​
12​
Muhammad Husnain​
Associate Network Technician​
13​
Muhammad Kamran​
Sr. Network Technician​
01-02-24​
13​
Muhammad Asim​
Driver​
14​
Aon Muhammad​
Splicer​
03-02-17​
14​
Muhammad Shafiq​
Driver​
15​
Azhar Ali​
Supervisor - Field Operations​
01-02-24​
15​
Imran Ahmed​
Driver​
16​
Umair Chaudhry​
Splicer​
01-02-24​
16​
Muhammad Amin shahid​
Driver​
17​
Adnan Majeed​
Technical Associate​
03-02-17​
17​
Nasir Arfat​
Driver​
18​
Muhammad Ibrahim​
Driver​
03-02-17​
18​
Hafiz Muhammad Imtiaz​
Driver​
19​
Muhammad Riaz​
Technical Assistant​
21-03-17​
19​
Ali Raza​
Driver​
20​
Muhammad Asim​
Driver​
18-03-20​
20​
Imran Karamat​
Driver​
21​
Muhammad Shafiq​
Driver​
21-03-17​
21​
Rana Muhammad Mubeen Ud Din​
Driver​
22​
Zulfiqar Ali​
Associate Network Technician​
21-03-17​
22​
Muhammad Adnan​
Driver​
23​
Haris Lateef​
Sr. Technical Support Representative​
03-11-23​
23​
Muhammad Kashif​
Manager - Fiber Operations​
24​
Haris Naveed​
Network Technician​
08-06-17​
24​
Hassan Ali​
Network Technician​
25​
Imran Ahmed​
Driver​
17-07-17​
25​
Aon Muhammad​
Splicer​
26​
Muhammad Amin shahid​
Driver​
18-07-17​
26​
Muhammad Irfan​
Splicer​
27​
Vikram Javed​
Sr. Rigger​
24-05-22​
27​
Yasir Ali​
Splicer​
28​
Muhammad Usama Habib​
Team Lead - Deployment​
02-02-24​
28​
Muhammad Sajjad​
Splicer​
29​
Sajjad Ali​
Associate Network Technician​
18-08-17​
29​
Muhmmad Faizan​
Splicer​
30​
Hafiz Atif​
Supervisior - QA​
21-02-24​
30​
Muhammad Asim Shahzad​
Splicer​
31​
Hafiz Waseem Iqbal​
Sr. Splicer​
04-05-18​
31​
Muhammad Ahsan​
Splicer​
32​
Faisal Maqsood​
Technical Assistant​
19-07-17​
32​
Muhammad Imran​
Splicer​
33​
muhammad Arif Anjum​
Associate Network Technician​
19-07-17​
33​
Hafiz Habib Ullah​
Splicer​
34​
Muhammad Asim​
Technical Associate​
03-10-17​
34​
Shabir Hussain​
Splicer​
35​
Muhammad Adil Jahangir​
Technical Associate​
03-10-17​
35​
Khalid Ali​
Sr. Splicer​
36​
Ramis James​
Sr. Rigger​
09-05-18​
36​
Mehmood Ali Khalid​
Supervisor - Field Operations​
37​
Farhan Khursheed​
Sr. Rigger​
09-05-18​
37​
Ikram Hussain​
Supervisor - Field Operations​
38​
Muhammad Anwar Ishaq​
Sr. Rigger​
10-09-18​
38​
Faisal Maqsood​
Technical Assistant​
39​
Salman Shahzad​
Supervisior - QA​
20-02-24​
39​
Muhammad Arslan​
Technical Assistant​
40​
Salman Mukhtar​
Technical Assistant​
12-01-19​
40​
Muhammad Nadeem​
Technical Assistant​
41​
Muhammad Arslan​
Technical Assistant​
12-01-19​
41​
Muhammad Akmal​
Technical Assistant​
42​
Muhammad Nadeem​
Technical Assistant​
12-01-19​
42​
Muhammad Babar​
Technical Assistant​
43​
Hassan Ali​
Network Technician​
18-04-19​
43​
Abhishik Danish​
Technical Assistant​
44​
Muhammad Gulfam Tariq​
Supervisior - QA​
13-02-24​
44​
Muhammad Asim​
Technical Associate​
45​
Muhammad Kashif​
Supervisor - Field Operations​
01-02-24​
45​
Muhammad Adil Jahangir​
Technical Associate​
46​
Muhammad Aftab Hanif​
Network Technician​
25-04-19​
46​
Sami Ullah​
Technical Associate​
47​
Mirza Safwan Baig​
Sr. Network Technician​
18-04-19​
47​
Hasnain Ghani​
Technical Associate​
48​
Nasir Arfat​
Driver​
29-05-19​
48​
Waheed Mahmood​
Technical Associate​
49​
Muhammad Usman Mahmood​
Sr. Network Technician​
10-06-19​
49​
Ali Hira​
Technical Associate​
50​
Ibtasam Afzal​
Splicer​
11-05-23​
50​
Syed Ali Murtaza​
Technical Associate​
51​
Suleman Khalil​
Rigger​
26-07-19​
51​
Muhammad Azhar Saroosh Naqeeb​
Technical Associate​
52​
Muhammad Akmal​
Technical Assistant​
04-09-19​
52​
Muhammad Umar​
Technical Associate​
53​
Muhammad Irfan​
Splicer​
04-09-19​
53​
Muhammad Arslan​
Technical Associate​
54​
Danish Masih​
Technical Associate​
04-09-19​
54​
Muhammad Noman​
Technical Associate​
55​
Muhammad Ilyas​
Associate Network Technician​
16-09-19​
55​
Uzair Qasim​
Technical Associate​
56​
Yasir Ali​
Splicer​
19-09-19​
56​
Inam Ul Mustafa​
Technical Associate​
57​
Muhammad Hamza​
Team Lead- Deployment​
01-02-24​
57​
Muhammad Adeel​
Technical Associate​
58​
Muhammad Ans Irfan​
Manager - Deployment​
21-08-23​
58​
Hassan Maqsood​
Technical Associate​
59​
Sami Ullah​
Technical Associate​
13-03-20​
59​
Dawood Ali​
Technical Associate​
60​
Adeel Nazeer​
Technical Associate​
01-01-20​
60​
Aneeq Ahmad​
Technical Associate​
61​
Muhammad Hasnain​
Associate Network Technician​
09-10-23​
61​
Farrukh Ehsan Baig​
Driver​
62​
Zeeshan Ahmad​
Technical Associate​
01-01-20​
62​
Muhammad Hussain Hani​
Power Technician​
63​
Waqas Ilyas​
Driver​
01-01-20​
63​
Irtiza Ali​
Rigger​
64​
Haider Ali​
Driver​
01-01-20​
64​
Farhan Bashir​
Manager - Fiber Operations​
65​
Mohsin Mujtaba​
Driver​
21-01-20​
66​
Daud​
Splicer​
30-01-24​
67​
Arbab Ahmad​
Associate Network Technician​
08-12-23​
68​
Muhammad Sajjad​
Splicer​
17-02-20​
69​
Hasnain Ghani​
Technical Associate​
21-02-20​
70​
RAI M Zergham KHAN​
Associate Network Technician​
20-05-20​
71​
Ghulam Abbas​
Associate Network Technician​
09-06-20​
72​
Muhammad Muzaib Manzoor​
Associate Network Technician​
09-06-20​
73​
Mujahid Ali​
Associate Network Technician​
09-06-20​
74​
Muhammad Bilal​
Associate Network Technician​
09-06-20​
75​
Muhammad Hussain Hani​
Power Technician​
08-06-20​
76​
Raza Haider​
Associate Power Technician​
08-06-20​
77​
Noor Ahmad​
Network Technician​
08-06-20​
78​
Ijaz Ahmad​
Network Technician​
08-06-20​
79​
Shahzad Shafique​
Driver​
24-08-20​
80​
Hassan Maqsood​
Technical Associate​
08-10-20​
81​
Muhammad Waqas​
Technical Associate​
08-10-20​
82​
Muhammad Naeem​
Technical Associate​
20-10-20​
83​
Muhammad Usman​
Technical Associate​
11-11-20​
84​
Muhammad Muneeb Ur Rehman​
Network Technician​
01-02-24​
85​
Ramzan Shah​
Technical Associate​
21-06-21​
86​
Rashid Arshad Ali​
Splicer​
07-06-21​
87​
Muhammad Saeed Khan​
Driver​
18-05-21​
88​
Waheed Mahmood​
Technical Associate​
23-07-21​
89​
Hafiz Muhammad Imtiaz​
Driver​
29-07-21​
90​
Abdullah Khalil​
Executive - Deployment​
21-02-24​
91​
Muhammad Tariq Hanif​
Associate Network Technician​
13-09-21​
92​
Muhammad Naeem Ansari​
Supervisor - Deployment​
13-02-24​
93​
Abdul Hannan Ali​
Associate Network Technician​
28-09-21​
94​
Adeel Abbas​
Supervisior - QA​
21-02-24​
95​
Malik Arham Jaa​
Supervisior - QA​
20-02-24​
96​
Faiz ur Rehman​
Supervisior - QA​
21-02-24​
97​
Muhammad Tayyab​
Supervisor - Deployment​
29-01-24​
98​
Syed Muhammad Mehdi​
Technical Associate​
08-12-21​
99​
Muhammad Hussnain​
Associate Network Technician​
08-12-21​
100​
Rehan Ali​
Technical Support Associate​
15-02-22​
101​
Muhammad Bilal Ahmad​
Network Technician​
07-02-22​
102​
Muhmmad Faizan​
Splicer​
07-03-22​
103​
Saghir Ahmed Bhatti​
Technical Associate​
23-02-22​
104​
Shahid Shoaib​
Technical Associate​
23-02-22​
105​
Amir Munir​
Splicer​
23-02-22​
106​
Muhammad Daud Malik​
Associate Network Technician​
25-03-22​
107​
Muhammad Nasir​
Executive - Deployment​
29-01-24​
108​
Ali Hira​
Technical Associate​
21-04-22​
109​
Muhammad Asim Shahzad​
Splicer​
01-03-24​
110​
Syed Ali Murtaza​
Technical Associate​
21-04-22​
111​
Muhammad Zia Ullah​
Executive - Fiber Operations​
03-04-24​
112​
Umair Nawaz​
Team Lead - Deployment​
29-01-24​
113​
Muhammad John Raza​
Supervisior - QA​
06-05-22​
114​
M Ahsan Ahmed Siddiqui​
Technician - Deployment​
29-04-22​
115​
Muhammad Shoaib​
Manager - Deployment​
01-04-24​
116​
Muhammad Hamza Shahid​
Supervisior - QA​
06-02-24​
117​
Ahsan Jamil​
Team Lead - Deployment​
29-01-24​
118​
Maqsood Shahzad​
Supervisior - QA​
06-05-22​
119​
Usama Abid​
Supervisior - QA​
10-05-22​
120​
Muhammad Shahzaib​
Technical Associate​
16-04-22​
121​
Dawood Ali​
Technical Associate​
20-04-22​
122​
Aneeq Ahmad​
Technical Associate​
20-04-22​
123​
Asif Ali​
Supervisior - QA​
10-05-22​
124​
Zeeshan​
Supervisior - QA​
10-05-22​
125​
Muhammad Husnain Butt​
Supervisior - QA​
21-02-24​
126​
Muhammad Azhar Saroosh Naqeeb​
Technical Associate​
27-06-22​
127​
Muhammad Umar​
Technical Associate​
27-06-22​
128​
Muhammad Farooq Yasin​
Executive- QA​
23-11-23​
129​
Muhammad Talha Shehroz​
Supervisor - Deployment​
15-02-24​
130​
Hamza Zulfiqar​
Executive - Deployment​
29-01-24​
131​
Muhammad Ahsan​
Splicer​
18-08-22​
132​
Muhammad Qasim​
Supervisior - QA​
03-02-24​
133​
Hammad Ahmad​
Technical Associate​
05-09-22​
134​
Abdul Rehman​
Technical Associate​
08-09-22​
135​
Muhammad Usman Hader​
Associate Network Technician​
13-09-22​
136​
Fakhara Chaudhary​
Technical Support Associate​
15-09-22​
137​
Ali Sanwal​
Associate Network Technician​
08-09-22​
138​
Ali Raza​
Driver​
29-09-22​
139​
Imran Karamat​
Driver​
29-09-22​
140​
Muhammad Babar​
Technical Assistant​
30-09-22​
141​
Bilal Butt​
Driver​
07-10-22​
142​
Farrukh Ehsan Baig​
Driver​
12-10-22​
143​
Shaharyar Zulfiqar Ali​
Network Technician​
25-10-22​
144​
Adal Waqar​
Technical Associate​
07-11-22​
145​
Muhammad Ibrar​
Technical Associate​
07-11-22​
146​
Sikandar Abbas​
Network Technician​
15-11-22​
147​
Muhammad Usama Tanvir​
Technical Support Associate​
25-11-22​
148​
Muhammad Hassan​
Splicer​
08-12-22​
149​
Hamza Naveed​
Associate Network Technician​
09-12-22​
150​
Adil Tabassum​
Driver​
08-12-22​
151​
Hafiz Muhammad Muneeb Ahmad​
Team Lead - Deployment​
29-01-24​
152​
Areeb Ahmad​
Technical Support Associate​
13-01-23​
153​
Muhammad Ahmad Arshad​
Network Technician​
01-02-24​
154​
Syed Faizan Ali​
Technical Associate​
06-02-23​
155​
Abu Bakar Siddique​
Supervisor - Deployment​
29-01-24​
156​
Muhammad Arslan​
Technical Associate​
20-02-23​
157​
Muhammad Imran​
Splicer​
02-03-23​
158​
Muhammad Usman​
Supervisor - Deployment​
01-02-24​
159​
Fasih Ur Rehman​
Executive- QA​
14-11-23​
160​
Ghulam Murtaza​
Supervisior - QA​
24-03-23​
161​
Kashif Iqbal​
GIS Surveyor​
27-03-23​
162​
Hamza Jamal Pasha​
Associate Network Technician​
30-03-23​
163​
Aftab Ahmad​
Executive - Deployment​
16-01-24​
164​
Muhammad Zeeshan Iqbal​
Supervisor - Deployment​
05-03-24​
165​
Asad Ali​
Supervisior - QA​
16-01-24​
166​
Hussam Ahmad​
Executive - Deployment​
16-01-24​
167​
Usman Ahmad​
Supervisor - Deployment​
01-02-24​
168​
Uzair Qasim​
Technical Associate​
23-06-23​
169​
Nadeem Ahmad​
Supervisor - Deployment​
29-01-24​
170​
Nadeem Ijaz​
Supervisior - QA​
21-08-23​
171​
Muhammad Shafiq​
Technician - Deployment​
25-07-23​
172​
Inam Ul Mustafa​
Technical Associate​
01-08-22​
173​
Muhammad Kashif​
Manager - Fiber Operations​
21-08-23​
174​
Rana Muhammad Mubeen Ud Din​
Driver​
30-08-23​
175​
Muhammad Bilal Fareed​
Driver​
30-08-23​
176​
Sheikh Muhammad Hamza​
Driver​
31-08-23​
177​
Syed Asad Ali​
Associate Network Technician​
05-08-23​
178​
Muhammad Ali Raza​
Executive- QA​
01-02-24​
179​
Haris Usman​
Supervisior - QA​
11-09-23​
180​
Abhishik Danish​
Technical Assistant​
18-09-23​
181​
Abdul Qadeer​
Supervisor - Deployment​
06-02-24​
182​
Muhammad Ashar Anjum​
Supervisior - QA​
20-02-24​
183​
Talha Naveed​
Associate Network Technician​
20-09-23​
184​
Fasir Nazir​
Associate Network Technician​
02-10-23​
185​
Aqeel Ahmed​
Splicer​
06-10-23​
186​
Muhammad Yasir​
Technician - Deployment​
06-12-23​
187​
Shehroz Yameen​
Splicer​
06-10-23​
188​
Muhammad Abbas​
Supervisor- Deployment​
15-02-24​
189​
Khawaja Shaheryar Ahmad​
Supervisior - QA​
01-02-24​
190​
Muhammad Ahmad Majid​
Executive- QA​
31-10-23​
191​
Faraz Bajwa​
Supervisior - QA​
20-02-24​
192​
Arslan Ahmad​
Associate Network Technician​
10-10-23​
193​
Muhammad Adnan​
Driver​
23-10-23​
194​
Raheel Ahmad​
AC Technician​
03-11-23​
195​
Muhammad Faizan​
Technician - Deployment​
23-11-23​
196​
Subhan Ali​
Technician - Deployment​
23-11-23​
197​
Abdullah Pervaiz​
Technician - Deployment​
29-11-23​
198​
Muhammad Ahmad Hassan Bhatti​
Sr. Network Technician​
30-11-23​
199​
Usama Iqbal​
Technical Support Associate​
30-11-23​
200​
Irtiza Ali​
Rigger​
30-11-23​
201​
Amir Shahzad​
Technical Support Associate​
30-11-23​
202​
Hafiz Habib Ullah​
Splicer​
05-12-23​
203​
Adeel Ahmad Khan​
Executive - Planning​
23-11-23​
204​
Abdul Qayyum​
Manager - QA​
23-11-23​
205​
Shraf Riaz​
Supervisior - QA​
08-12-23​
206​
Muhammad Usama Mubarak​
Supervisior - QA​
12-12-23​
207​
Fahad Arshad​
Technical Support Representative​
18-12-23​
208​
Hasnain Ali Shah​
Technical Associate​
18-12-23​
209​
Muhammad Husnain​
Associate Network Technician​
03-01-24​
210​
Syed Hassan Raza​
Technician - Deployment​
08-01-24​
211​
Abdullah Ahmad​
Technician - Deployment​
12-01-24​
212​
Abdul Wasiq​
Supervisior - QA​
17-01-24​
213​
Shabir Hussain​
Splicer​
18-01-24​
214​
Shoukat Ali​
Rigger​
18-01-24​
215​
Ziam Ahmad​
Supervisior - QA​
18-01-24​
216​
Shahzaib Ali​
Supervisior - QA​
22-01-24​
217​
Nauman Abid Chaudhary​
Executive- QA​
16-01-24​
218​
Muhammad Daniyal Badar​
Executive- QA​
17-01-24​
219​
Rana Ali Hamza​
Executive- QA​
17-01-24​
220​
Muhammad Fazeel​
Supervisior - QA​
25-01-24​
221​
Kashif Khan​
Technician - Deployment​
30-01-24​
222​
Muhammad Moazam Sardar​
Technician - Deployment​
30-01-24​
223​
Hamza Ali​
Technician - Deployment​
30-01-24​
224​
Sohaim Saleem​
Technician - Deployment​
30-01-24​
225​
Abdur Rehman​
Technical Support Associate​
29-01-24​
226​
Jahanzaib​
Supervisor - Deployment​
29-01-24​
227​
Muhammad Usman​
Supervisor - Deployment​
29-01-24​
228​
Ali Imran​
Supervisor - Deployment​
15-02-24​
229​
Muhammad Awais Ali​
Technician - Deployment​
29-01-24​
230​
Furqan Hameed​
Supervisor - Deployment​
29-01-24​
231​
Adnan Saeed​
Manager - Deployment​
29-01-24​
232​
Adnan Ali​
Team Lead - Deployment​
29-01-24​
233​
Muhammad Saifullah Khalid​
Technician - Deployment​
29-01-24​
234​
Umair Farooq​
Executive - Deployment​
29-01-24​
235​
Mudasir Iqbal​
Team Lead - Deployment​
01-02-24​
236​
Abdul Aleem​
Supervisor - Deployment​
01-02-24​
237​
Zimad Nazir​
Supervisor - Deployment​
30-01-24​
238​
Muhammad Tayyab​
Executive - Deployment​
30-01-24​
239​
Syed Farhan Hassan Bukhari​
Technician - Deployment​
01-02-24​
240​
Muhammad Ali​
Team Lead - Deployment​
01-02-24​
241​
Imran Malik​
Team Lead - Deployment​
31-01-24​
242​
Muhammad Atif Ur Rehman​
Supervisor - Deployment​
01-02-24​
243​
Shahab Khan​
Supervisor - Deployment​
05-02-24​
244​
Roshnan Ali​
Supervisor - Deployment​
02-02-24​
245​
Mateen Ahmad​
Supervisor - Deployment​
01-02-24​
246​
Mehran Shahid​
Team Lead - Deployment​
31-01-24​
247​
Wajeeh Ul Hassan​
Technician - Deployment​
31-01-24​
248​
Bilal Zagham​
Supervisor - Deployment​
31-01-24​
249​
Ali Raza Ifthikhar​
Technician - Deployment​
31-01-24​
250​
Hamza Malik​
Technician - Deployment​
31-01-24​
251​
Muhammad Farhan Shehzad​
Technician - Deployment​
06-02-24​
252​
Muhammad Zohaib​
Technician - Deployment​
07-02-24​
253​
Muhammad Danyal​
Technician - Deployment​
07-02-24​
254​
Mansoor Ahmed Khan​
Executive- QA​
12-02-24​
255​
Hafiz Usman Farrukh​
Supervisior - QA​
19-02-24​
256​
Zeeshan Ul Haque​
Manager - Deployment​
01-03-24​
257​
Ali Haider​
Supervisior - QA​
14-02-24​
258​
Sarfraz Ahmad​
Supervisior - QA​
26-02-24​
259​
Faisal Ashraf​
Technician - Deployment​
14-02-24​
260​
Muhammad Asad Ehsan​
Supervisior - QA​
14-02-24​
261​
Muhammad Mehdi​
Supervisior - QA​
14-02-24​
262​
Muhammad Mudassar Akram​
Executive- QA​
13-02-24​
263​
Muhammad Bilal Asghar​
Supervisior - QA​
14-02-24​
264​
Nouman Bashir​
Supervisor - Deployment​
04-03-24​
265​
Jawad Hassan​
Executive- QA​
01-03-24​
266​
Muhammad Zeeshan​
Team Lead - Deployment​
19-02-24​
267​
Muhammad Abrar​
Team Lead - Deployment​
19-02-24​
268​
Abdullah Sajid​
Executive - Deployment​
14-02-24​
269​
Muhammad Shazil Asif Attari​
Supervisior - QA​
14-02-24​
270​
Ikram Hussain​
Supervisor - Field Operations​
01-03-24​
271​
Sanif Ur Rehman​
Supervisior - QA​
13-02-24​
272​
Haris Nazir​
Supervisior - QA​
13-02-24​
273​
Ghazanfar Gulzar​
Supervisor - Deployment​
21-02-24​
274​
Hafiz Amaz Ali​
Technician - Deployment​
21-02-24​
275​
Ahmar Ahtisham​
Technician - Deployment​
21-02-24​
276​
Mahad Ali Khan​
Executive - Deployment​
21-02-24​
277​
Junaid Ahmed​
Manager - Deployment​
21-02-24​
278​
Farhan Bashir​
Manager - Fiber Operations​
26-03-24​
279​
Nadeem Abbas​
Technician - Deployment​
23-02-24​
280​
Haseeb Ashfaq Khan​
Technician - Deployment​
29-02-24​
281​
Muhammad Adeel​
Technical Associate​
29-02-24​
282​
Muhammad Zeeshan Ali​
Executive - Deployment​
04-03-24​
283​
Muhammad Fahad Malik​
Network Technician​
01-02-24​
284​
Muhammad Athar Rana​
Executive - Deployment​
12-03-24​
285​
Wasim Akram​
Technician - Deployment​
08-04-24​
286​
Muhammad Azeem​
Associate Network Technician​
19-04-24​
287​
Muhammad Zeeshan​
Technical Associate​
23-04-24​
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Are you just looking for any appearance of the value? Or are you trying to only highlight rows as they are "checked" off the list?

try this:

Book1
ABCDEFG
1SR.NO.NamePositionJoining DateSr.No.NameDesignation
21Hafiz Hussain AhmadNetwork Technician2024-01-081Zulfiqar AliAssociate Network Technician
32Hafiz M Babar IshaqSupervisor - Deployment2024-02-292muhammad Arif AnjumAssociate Network Technician
43Basit Aziz UllahExecutive - Deployment2024-01-293Muhammad IlyasAssociate Network Technician
54Muhammad SulemanSupervisor - Deployment2024-02-134RAI M Zergham KHANAssociate Network Technician
65Hamid MaqboolSr. Network Technician2019-04-235Muhammad Tariq HanifAssociate Network Technician
76Syed Ali RazaSupervisior - QA2024-02-206Abdul Hannan AliAssociate Network Technician
87Mehmood Ali KhalidSupervisor - Field Operations2024-02-017Muhammad Daud MalikAssociate Network Technician
98Wali Ur RehmanNetwork Technician2015-05-218Ali SanwalAssociate Network Technician
109Shahid NazirRigger2016-01-019Syed Asad AliAssociate Network Technician
1110Muhammad Haseeb JavedSupervisor - Deployment2024-02-0110Talha NaveedAssociate Network Technician
1211Muhammad Hamza JavedTeam Lead - Deployment2024-01-2911Arslan AhmadAssociate Network Technician
1312Abdullah RazaTechnical Support Associate2022-12-0712Muhammad HusnainAssociate Network Technician
1413Muhammad KamranSr. Network Technician2024-02-0113Muhammad AsimDriver
1514Aon MuhammadSplicer2017-02-0314Muhammad ShafiqDriver
1615Azhar AliSupervisor - Field Operations2024-02-0115Imran AhmedDriver
1716Umair ChaudhrySplicer2024-02-0116Muhammad Amin shahidDriver
1817Adnan MajeedTechnical Associate2017-02-0317Nasir ArfatDriver
1918Muhammad IbrahimDriver2017-02-0318Hafiz Muhammad ImtiazDriver
2019Muhammad RiazTechnical Assistant2017-03-2119Ali RazaDriver
2120Muhammad AsimDriver2020-03-1820Imran KaramatDriver
2221Muhammad ShafiqDriver2017-03-2121Rana Muhammad Mubeen Ud DinDriver
2322Zulfiqar AliAssociate Network Technician2017-03-2122Muhammad AdnanDriver
2423Haris LateefSr. Technical Support Representative2023-11-0323Muhammad KashifManager - Fiber Operations
2524Haris NaveedNetwork Technician2017-06-0824Hassan AliNetwork Technician
2625Imran AhmedDriver2017-07-1725Aon MuhammadSplicer
2726Muhammad Amin shahidDriver2017-07-1826Muhammad IrfanSplicer
2827Vikram JavedSr. Rigger2022-05-2427Yasir AliSplicer
2928Muhammad Usama HabibTeam Lead - Deployment2024-02-0228Muhammad SajjadSplicer
3029Sajjad AliAssociate Network Technician2017-08-1829Muhmmad FaizanSplicer
3130Hafiz AtifSupervisior - QA2024-02-2130Muhammad Asim ShahzadSplicer
3231Hafiz Waseem IqbalSr. Splicer2018-05-0431Muhammad AhsanSplicer
3332Faisal MaqsoodTechnical Assistant2017-07-1932Muhammad ImranSplicer
3433muhammad Arif AnjumAssociate Network Technician2017-07-1933Hafiz Habib UllahSplicer
3534Muhammad AsimTechnical Associate2017-10-0334Shabir HussainSplicer
3635Muhammad Adil JahangirTechnical Associate2017-10-0335Khalid AliSr. Splicer
3736Ramis JamesSr. Rigger2018-05-0936Mehmood Ali KhalidSupervisor - Field Operations
3837Farhan KhursheedSr. Rigger2018-05-0937Ikram HussainSupervisor - Field Operations
3938Muhammad Anwar IshaqSr. Rigger2018-09-1038Faisal MaqsoodTechnical Assistant
4039Salman ShahzadSupervisior - QA2024-02-2039Muhammad ArslanTechnical Assistant
4140Salman MukhtarTechnical Assistant2019-01-1240Muhammad NadeemTechnical Assistant
4241Muhammad ArslanTechnical Assistant2019-01-1241Muhammad AkmalTechnical Assistant
4342Muhammad NadeemTechnical Assistant2019-01-1242Muhammad BabarTechnical Assistant
4443Hassan AliNetwork Technician2019-04-1843Abhishik DanishTechnical Assistant
4544Muhammad Gulfam TariqSupervisior - QA2024-02-1344Muhammad AsimTechnical Associate
4645Muhammad KashifSupervisor - Field Operations2024-02-0145Muhammad Adil JahangirTechnical Associate
4746Muhammad Aftab HanifNetwork Technician2019-04-2546Sami UllahTechnical Associate
4847Mirza Safwan BaigSr. Network Technician2019-04-1847Hasnain GhaniTechnical Associate
4948Nasir ArfatDriver2019-05-2948Waheed MahmoodTechnical Associate
5049Muhammad Usman MahmoodSr. Network Technician2019-06-1049Ali HiraTechnical Associate
5150Ibtasam AfzalSplicer2023-05-1150Syed Ali MurtazaTechnical Associate
5251Suleman KhalilRigger2019-07-2651Muhammad Azhar Saroosh NaqeebTechnical Associate
5352Muhammad AkmalTechnical Assistant2019-09-0452Muhammad UmarTechnical Associate
5453Muhammad IrfanSplicer2019-09-0453Muhammad ArslanTechnical Associate
5554Danish MasihTechnical Associate2019-09-0454Muhammad NomanTechnical Associate
5655Muhammad IlyasAssociate Network Technician2019-09-1655Uzair QasimTechnical Associate
5756Yasir AliSplicer2019-09-1956Inam Ul MustafaTechnical Associate
5857Muhammad HamzaTeam Lead- Deployment2024-02-0157Muhammad AdeelTechnical Associate
5958Muhammad Ans IrfanManager - Deployment2023-08-2158Hassan MaqsoodTechnical Associate
6059Sami UllahTechnical Associate2020-03-1359Dawood AliTechnical Associate
6160Adeel NazeerTechnical Associate2020-01-0160Aneeq AhmadTechnical Associate
6261Muhammad HasnainAssociate Network Technician2023-10-0961Farrukh Ehsan BaigDriver
6362Zeeshan AhmadTechnical Associate2020-01-0162Muhammad Hussain HaniPower Technician
6463Waqas IlyasDriver2020-01-0163Irtiza AliRigger
6564Haider AliDriver2020-01-0164Farhan BashirManager - Fiber Operations
6665Mohsin MujtabaDriver2020-01-21
6766DaudSplicer2024-01-30
6867Arbab AhmadAssociate Network Technician2023-12-08
6968Muhammad SajjadSplicer2020-02-17
7069Hasnain GhaniTechnical Associate2020-02-21
7170RAI M Zergham KHANAssociate Network Technician2020-05-20
7271Ghulam AbbasAssociate Network Technician2020-06-09
7372Muhammad Muzaib ManzoorAssociate Network Technician2020-06-09
7473Mujahid AliAssociate Network Technician2020-06-09
7574Muhammad BilalAssociate Network Technician2020-06-09
7675Muhammad Hussain HaniPower Technician2020-06-08
7776Raza HaiderAssociate Power Technician2020-06-08
7877Noor AhmadNetwork Technician2020-06-08
7978Ijaz AhmadNetwork Technician2020-06-08
8079Shahzad ShafiqueDriver2020-08-24
8180Hassan MaqsoodTechnical Associate2020-10-08
8281Muhammad WaqasTechnical Associate2020-10-08
8382Muhammad NaeemTechnical Associate2020-10-20
8483Muhammad UsmanTechnical Associate2020-11-11
8584Muhammad Muneeb Ur RehmanNetwork Technician2024-02-01
8685Ramzan ShahTechnical Associate2021-06-21
8786Rashid Arshad AliSplicer2021-06-07
8887Muhammad Saeed KhanDriver2021-05-18
8988Waheed MahmoodTechnical Associate2021-07-23
9089Hafiz Muhammad ImtiazDriver2021-07-29
9190Abdullah KhalilExecutive - Deployment2024-02-21
9291Muhammad Tariq HanifAssociate Network Technician2021-09-13
9392Muhammad Naeem AnsariSupervisor - Deployment2024-02-13
9493Abdul Hannan AliAssociate Network Technician2021-09-28
9594Adeel AbbasSupervisior - QA2024-02-21
9695Malik Arham JaaSupervisior - QA2024-02-20
9796Faiz ur RehmanSupervisior - QA2024-02-21
9897Muhammad TayyabSupervisor - Deployment2024-01-29
9998Syed Muhammad MehdiTechnical Associate2021-12-08
10099Muhammad HussnainAssociate Network Technician2021-12-08
101100Rehan AliTechnical Support Associate2022-02-15
102101Muhammad Bilal AhmadNetwork Technician2022-02-07
103102Muhmmad FaizanSplicer2022-03-07
104103Saghir Ahmed BhattiTechnical Associate2022-02-23
105104Shahid ShoaibTechnical Associate2022-02-23
106105Amir MunirSplicer2022-02-23
107106Muhammad Daud MalikAssociate Network Technician2022-03-25
108107Muhammad NasirExecutive - Deployment2024-01-29
109108Ali HiraTechnical Associate2022-04-21
110109Muhammad Asim ShahzadSplicer2024-03-01
111110Syed Ali MurtazaTechnical Associate2022-04-21
112111Muhammad Zia UllahExecutive - Fiber Operations2024-04-03
113112Umair NawazTeam Lead - Deployment2024-01-29
114113Muhammad John RazaSupervisior - QA2022-05-06
115114M Ahsan Ahmed SiddiquiTechnician - Deployment2022-04-29
116115Muhammad ShoaibManager - Deployment2024-04-01
117116Muhammad Hamza ShahidSupervisior - QA2024-02-06
118117Ahsan JamilTeam Lead - Deployment2024-01-29
119118Maqsood ShahzadSupervisior - QA2022-05-06
120119Usama AbidSupervisior - QA2022-05-10
121120Muhammad ShahzaibTechnical Associate2022-04-16
122121Dawood AliTechnical Associate2022-04-20
123122Aneeq AhmadTechnical Associate2022-04-20
124123Asif AliSupervisior - QA2022-05-10
125124ZeeshanSupervisior - QA2022-05-10
126125Muhammad Husnain ButtSupervisior - QA2024-02-21
127126Muhammad Azhar Saroosh NaqeebTechnical Associate2022-06-27
128127Muhammad UmarTechnical Associate2022-06-27
129128Muhammad Farooq YasinExecutive- QA2023-11-23
130129Muhammad Talha ShehrozSupervisor - Deployment2024-02-15
131130Hamza ZulfiqarExecutive - Deployment2024-01-29
132131Muhammad AhsanSplicer2022-08-18
133132Muhammad QasimSupervisior - QA2024-02-03
134133Hammad AhmadTechnical Associate2022-09-05
135134Abdul RehmanTechnical Associate2022-09-08
136135Muhammad Usman HaderAssociate Network Technician2022-09-13
137136Fakhara ChaudharyTechnical Support Associate2022-09-15
138137Ali SanwalAssociate Network Technician2022-09-08
139138Ali RazaDriver2022-09-29
140139Imran KaramatDriver2022-09-29
141140Muhammad BabarTechnical Assistant2022-09-30
142141Bilal ButtDriver2022-10-07
143142Farrukh Ehsan BaigDriver2022-10-12
144143Shaharyar Zulfiqar AliNetwork Technician2022-10-25
145144Adal WaqarTechnical Associate2022-11-07
146145Muhammad IbrarTechnical Associate2022-11-07
147146Sikandar AbbasNetwork Technician2022-11-15
148147Muhammad Usama TanvirTechnical Support Associate2022-11-25
149148Muhammad HassanSplicer2022-12-08
150149Hamza NaveedAssociate Network Technician2022-12-09
151150Adil TabassumDriver2022-12-08
152151Hafiz Muhammad Muneeb AhmadTeam Lead - Deployment2024-01-29
153152Areeb AhmadTechnical Support Associate2023-01-13
154153Muhammad Ahmad ArshadNetwork Technician2024-02-01
155154Syed Faizan AliTechnical Associate2023-02-06
156155Abu Bakar SiddiqueSupervisor - Deployment2024-01-29
157156Muhammad ArslanTechnical Associate2023-02-20
158157Muhammad ImranSplicer2023-03-02
159158Muhammad UsmanSupervisor - Deployment2024-02-01
160159Fasih Ur RehmanExecutive- QA2023-11-14
161160Ghulam MurtazaSupervisior - QA2023-03-24
162161Kashif IqbalGIS Surveyor2023-03-27
163162Hamza Jamal PashaAssociate Network Technician2023-03-30
164163Aftab AhmadExecutive - Deployment2024-01-16
165164Muhammad Zeeshan IqbalSupervisor - Deployment2024-03-05
166165Asad AliSupervisior - QA2024-01-16
167166Hussam AhmadExecutive - Deployment2024-01-16
168167Usman AhmadSupervisor - Deployment2024-02-01
169168Uzair QasimTechnical Associate2023-06-23
170169Nadeem AhmadSupervisor - Deployment2024-01-29
171170Nadeem IjazSupervisior - QA2023-08-21
172171Muhammad ShafiqTechnician - Deployment2023-07-25
173172Inam Ul MustafaTechnical Associate2022-08-01
174173Muhammad KashifManager - Fiber Operations2023-08-21
175174Rana Muhammad Mubeen Ud DinDriver2023-08-30
176175Muhammad Bilal FareedDriver2023-08-30
177176Sheikh Muhammad HamzaDriver2023-08-31
178177Syed Asad AliAssociate Network Technician2023-08-05
179178Muhammad Ali RazaExecutive- QA2024-02-01
180179Haris UsmanSupervisior - QA2023-09-11
181180Abhishik DanishTechnical Assistant2023-09-18
182181Abdul QadeerSupervisor - Deployment2024-02-06
183182Muhammad Ashar AnjumSupervisior - QA2024-02-20
184183Talha NaveedAssociate Network Technician2023-09-20
185184Fasir NazirAssociate Network Technician2023-10-02
186185Aqeel AhmedSplicer2023-10-06
187186Muhammad YasirTechnician - Deployment2023-12-06
188187Shehroz YameenSplicer2023-10-06
189188Muhammad AbbasSupervisor- Deployment2024-02-15
190189Khawaja Shaheryar AhmadSupervisior - QA2024-02-01
191190Muhammad Ahmad MajidExecutive- QA2023-10-31
192191Faraz BajwaSupervisior - QA2024-02-20
193192Arslan AhmadAssociate Network Technician2023-10-10
194193Muhammad AdnanDriver2023-10-23
195194Raheel AhmadAC Technician2023-11-03
196195Muhammad FaizanTechnician - Deployment2023-11-23
197196Subhan AliTechnician - Deployment2023-11-23
198197Abdullah PervaizTechnician - Deployment2023-11-29
199198Muhammad Ahmad Hassan BhattiSr. Network Technician2023-11-30
200199Usama IqbalTechnical Support Associate2023-11-30
201200Irtiza AliRigger2023-11-30
202201Amir ShahzadTechnical Support Associate2023-11-30
203202Hafiz Habib UllahSplicer2023-12-05
204203Adeel Ahmad KhanExecutive - Planning2023-11-23
205204Abdul QayyumManager - QA2023-11-23
206205Shraf RiazSupervisior - QA2023-12-08
207206Muhammad Usama MubarakSupervisior - QA2023-12-12
208207Fahad ArshadTechnical Support Representative2023-12-18
209208Hasnain Ali ShahTechnical Associate2023-12-18
210209Muhammad HusnainAssociate Network Technician2024-01-03
211210Syed Hassan RazaTechnician - Deployment2024-01-08
212211Abdullah AhmadTechnician - Deployment2024-01-12
213212Abdul WasiqSupervisior - QA2024-01-17
214213Shabir HussainSplicer2024-01-18
215214Shoukat AliRigger2024-01-18
216215Ziam AhmadSupervisior - QA2024-01-18
217216Shahzaib AliSupervisior - QA2024-01-22
218217Nauman Abid ChaudharyExecutive- QA2024-01-16
219218Muhammad Daniyal BadarExecutive- QA2024-01-17
220219Rana Ali HamzaExecutive- QA2024-01-17
221220Muhammad FazeelSupervisior - QA2024-01-25
222221Kashif KhanTechnician - Deployment2024-01-30
223222Muhammad Moazam SardarTechnician - Deployment2024-01-30
224223Hamza AliTechnician - Deployment2024-01-30
225224Sohaim SaleemTechnician - Deployment2024-01-30
226225Abdur RehmanTechnical Support Associate2024-01-29
227226JahanzaibSupervisor - Deployment2024-01-29
228227Muhammad UsmanSupervisor - Deployment2024-01-29
229228Ali ImranSupervisor - Deployment2024-02-15
230229Muhammad Awais AliTechnician - Deployment2024-01-29
231230Furqan HameedSupervisor - Deployment2024-01-29
232231Adnan SaeedManager - Deployment2024-01-29
233232Adnan AliTeam Lead - Deployment2024-01-29
234233Muhammad Saifullah KhalidTechnician - Deployment2024-01-29
235234Umair FarooqExecutive - Deployment2024-01-29
236235Mudasir IqbalTeam Lead - Deployment2024-02-01
237236Abdul AleemSupervisor - Deployment2024-02-01
238237Zimad NazirSupervisor - Deployment2024-01-30
239238Muhammad TayyabExecutive - Deployment2024-01-30
240239Syed Farhan Hassan BukhariTechnician - Deployment2024-02-01
241240Muhammad AliTeam Lead - Deployment2024-02-01
242241Imran MalikTeam Lead - Deployment2024-01-31
243242Muhammad Atif Ur RehmanSupervisor - Deployment2024-02-01
244243Shahab KhanSupervisor - Deployment2024-02-05
245244Roshnan AliSupervisor - Deployment2024-02-02
246245Mateen AhmadSupervisor - Deployment2024-02-01
247246Mehran ShahidTeam Lead - Deployment2024-01-31
248247Wajeeh Ul HassanTechnician - Deployment2024-01-31
249248Bilal ZaghamSupervisor - Deployment2024-01-31
250249Ali Raza IfthikharTechnician - Deployment2024-01-31
251250Hamza MalikTechnician - Deployment2024-01-31
252251Muhammad Farhan ShehzadTechnician - Deployment2024-02-06
253252Muhammad ZohaibTechnician - Deployment2024-02-07
254253Muhammad DanyalTechnician - Deployment2024-02-07
255254Mansoor Ahmed KhanExecutive- QA2024-02-12
256255Hafiz Usman FarrukhSupervisior - QA2024-02-19
257256Zeeshan Ul HaqueManager - Deployment2024-03-01
258257Ali HaiderSupervisior - QA2024-02-14
259258Sarfraz AhmadSupervisior - QA2024-02-26
260259Faisal AshrafTechnician - Deployment2024-02-14
261260Muhammad Asad EhsanSupervisior - QA2024-02-14
262261Muhammad MehdiSupervisior - QA2024-02-14
263262Muhammad Mudassar AkramExecutive- QA2024-02-13
264263Muhammad Bilal AsgharSupervisior - QA2024-02-14
265264Nouman BashirSupervisor - Deployment2024-03-04
266265Jawad HassanExecutive- QA2024-03-01
267266Muhammad ZeeshanTeam Lead - Deployment2024-02-19
268267Muhammad AbrarTeam Lead - Deployment2024-02-19
269268Abdullah SajidExecutive - Deployment2024-02-14
270269Muhammad Shazil Asif AttariSupervisior - QA2024-02-14
271270Ikram HussainSupervisor - Field Operations2024-03-01
272271Sanif Ur RehmanSupervisior - QA2024-02-13
273272Haris NazirSupervisior - QA2024-02-13
274273Ghazanfar GulzarSupervisor - Deployment2024-02-21
275274Hafiz Amaz AliTechnician - Deployment2024-02-21
276275Ahmar AhtishamTechnician - Deployment2024-02-21
277276Mahad Ali KhanExecutive - Deployment2024-02-21
278277Junaid AhmedManager - Deployment2024-02-21
279278Farhan BashirManager - Fiber Operations2024-03-26
280279Nadeem AbbasTechnician - Deployment2024-02-23
281280Haseeb Ashfaq KhanTechnician - Deployment2024-02-29
282281Muhammad AdeelTechnical Associate2024-02-29
283282Muhammad Zeeshan AliExecutive - Deployment2024-03-04
284283Muhammad Fahad MalikNetwork Technician2024-02-01
285284Muhammad Athar RanaExecutive - Deployment2024-03-12
286285Wasim AkramTechnician - Deployment2024-04-08
287286Muhammad AzeemAssociate Network Technician2024-04-19
288287Muhammad ZeeshanTechnical Associate2024-04-23
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A3:F289Expression=ISNUMBER(MATCH($C3,$G$2:$G$65,0))textNO
A2:F2Expression=ISNUMBER(MATCH($C2,$G$2:$G$65,0))textNO
 
Upvote 0
Thanks a lot for your reply Sir,
Actually i want to trace out the entry of Col-B is present in Col-F or not.
For example in B2 Hafiz Hussain Ahmad is in the list of F or not, if it present then highlight it
 
Upvote 0
then use this formula as your conditional formatting rule.

Excel Formula:
=ISNUMBER(MATCH($B2,$F$2:$F$65,0))
 
Upvote 0
Sir, I applied this formula but nothing happened through conditional formatting.
 
Upvote 0
Sir, I applied this formula but nothing happened through conditional formatting.
works for me:

Book1
ABCDEFG
1SR.NO.NamePositionJoining DateSr.No.NameDesignation
21Hafiz Hussain AhmadNetwork Technician2024-01-081Zulfiqar AliAssociate Network Technician
32Hafiz M Babar IshaqSupervisor - Deployment2024-02-292muhammad Arif AnjumAssociate Network Technician
43Basit Aziz UllahExecutive - Deployment2024-01-293Muhammad IlyasAssociate Network Technician
54Muhammad SulemanSupervisor - Deployment2024-02-134RAI M Zergham KHANAssociate Network Technician
65Hamid MaqboolSr. Network Technician2019-04-235Muhammad Tariq HanifAssociate Network Technician
76Syed Ali RazaSupervisior - QA2024-02-206Abdul Hannan AliAssociate Network Technician
87Mehmood Ali KhalidSupervisor - Field Operations2024-02-017Muhammad Daud MalikAssociate Network Technician
98Wali Ur RehmanNetwork Technician2015-05-218Ali SanwalAssociate Network Technician
109Shahid NazirRigger2016-01-019Syed Asad AliAssociate Network Technician
1110Muhammad Haseeb JavedSupervisor - Deployment2024-02-0110Talha NaveedAssociate Network Technician
1211Muhammad Hamza JavedTeam Lead - Deployment2024-01-2911Arslan AhmadAssociate Network Technician
1312Abdullah RazaTechnical Support Associate2022-12-0712Muhammad HusnainAssociate Network Technician
1413Muhammad KamranSr. Network Technician2024-02-0113Muhammad AsimDriver
1514Aon MuhammadSplicer2017-02-0314Muhammad ShafiqDriver
1615Azhar AliSupervisor - Field Operations2024-02-0115Imran AhmedDriver
1716Umair ChaudhrySplicer2024-02-0116Muhammad Amin shahidDriver
1817Adnan MajeedTechnical Associate2017-02-0317Nasir ArfatDriver
1918Muhammad IbrahimDriver2017-02-0318Hafiz Muhammad ImtiazDriver
2019Muhammad RiazTechnical Assistant2017-03-2119Ali RazaDriver
2120Muhammad AsimDriver2020-03-1820Imran KaramatDriver
2221Muhammad ShafiqDriver2017-03-2121Rana Muhammad Mubeen Ud DinDriver
2322Zulfiqar AliAssociate Network Technician2017-03-2122Muhammad AdnanDriver
2423Haris LateefSr. Technical Support Representative2023-11-0323Muhammad KashifManager - Fiber Operations
2524Haris NaveedNetwork Technician2017-06-0824Hassan AliNetwork Technician
2625Imran AhmedDriver2017-07-1725Aon MuhammadSplicer
2726Muhammad Amin shahidDriver2017-07-1826Muhammad IrfanSplicer
2827Vikram JavedSr. Rigger2022-05-2427Yasir AliSplicer
2928Muhammad Usama HabibTeam Lead - Deployment2024-02-0228Muhammad SajjadSplicer
3029Sajjad AliAssociate Network Technician2017-08-1829Muhmmad FaizanSplicer
3130Hafiz AtifSupervisior - QA2024-02-2130Muhammad Asim ShahzadSplicer
3231Hafiz Waseem IqbalSr. Splicer2018-05-0431Muhammad AhsanSplicer
3332Faisal MaqsoodTechnical Assistant2017-07-1932Muhammad ImranSplicer
3433muhammad Arif AnjumAssociate Network Technician2017-07-1933Hafiz Habib UllahSplicer
3534Muhammad AsimTechnical Associate2017-10-0334Shabir HussainSplicer
3635Muhammad Adil JahangirTechnical Associate2017-10-0335Khalid AliSr. Splicer
3736Ramis JamesSr. Rigger2018-05-0936Mehmood Ali KhalidSupervisor - Field Operations
3837Farhan KhursheedSr. Rigger2018-05-0937Ikram HussainSupervisor - Field Operations
3938Muhammad Anwar IshaqSr. Rigger2018-09-1038Faisal MaqsoodTechnical Assistant
4039Salman ShahzadSupervisior - QA2024-02-2039Muhammad ArslanTechnical Assistant
4140Salman MukhtarTechnical Assistant2019-01-1240Muhammad NadeemTechnical Assistant
4241Muhammad ArslanTechnical Assistant2019-01-1241Muhammad AkmalTechnical Assistant
4342Muhammad NadeemTechnical Assistant2019-01-1242Muhammad BabarTechnical Assistant
4443Hassan AliNetwork Technician2019-04-1843Abhishik DanishTechnical Assistant
4544Muhammad Gulfam TariqSupervisior - QA2024-02-1344Muhammad AsimTechnical Associate
4645Muhammad KashifSupervisor - Field Operations2024-02-0145Muhammad Adil JahangirTechnical Associate
4746Muhammad Aftab HanifNetwork Technician2019-04-2546Sami UllahTechnical Associate
4847Mirza Safwan BaigSr. Network Technician2019-04-1847Hasnain GhaniTechnical Associate
4948Nasir ArfatDriver2019-05-2948Waheed MahmoodTechnical Associate
5049Muhammad Usman MahmoodSr. Network Technician2019-06-1049Ali HiraTechnical Associate
5150Ibtasam AfzalSplicer2023-05-1150Syed Ali MurtazaTechnical Associate
5251Suleman KhalilRigger2019-07-2651Muhammad Azhar Saroosh NaqeebTechnical Associate
5352Muhammad AkmalTechnical Assistant2019-09-0452Muhammad UmarTechnical Associate
5453Muhammad IrfanSplicer2019-09-0453Muhammad ArslanTechnical Associate
5554Danish MasihTechnical Associate2019-09-0454Muhammad NomanTechnical Associate
5655Muhammad IlyasAssociate Network Technician2019-09-1655Uzair QasimTechnical Associate
5756Yasir AliSplicer2019-09-1956Inam Ul MustafaTechnical Associate
5857Muhammad HamzaTeam Lead- Deployment2024-02-0157Muhammad AdeelTechnical Associate
5958Muhammad Ans IrfanManager - Deployment2023-08-2158Hassan MaqsoodTechnical Associate
6059Sami UllahTechnical Associate2020-03-1359Dawood AliTechnical Associate
6160Adeel NazeerTechnical Associate2020-01-0160Aneeq AhmadTechnical Associate
6261Muhammad HasnainAssociate Network Technician2023-10-0961Farrukh Ehsan BaigDriver
6362Zeeshan AhmadTechnical Associate2020-01-0162Muhammad Hussain HaniPower Technician
6463Waqas IlyasDriver2020-01-0163Irtiza AliRigger
6564Haider AliDriver2020-01-0164Farhan BashirManager - Fiber Operations
6665Mohsin MujtabaDriver2020-01-21
6766DaudSplicer2024-01-30
6867Arbab AhmadAssociate Network Technician2023-12-08
6968Muhammad SajjadSplicer2020-02-17
7069Hasnain GhaniTechnical Associate2020-02-21
7170RAI M Zergham KHANAssociate Network Technician2020-05-20
7271Ghulam AbbasAssociate Network Technician2020-06-09
7372Muhammad Muzaib ManzoorAssociate Network Technician2020-06-09
7473Mujahid AliAssociate Network Technician2020-06-09
7574Muhammad BilalAssociate Network Technician2020-06-09
7675Muhammad Hussain HaniPower Technician2020-06-08
7776Raza HaiderAssociate Power Technician2020-06-08
7877Noor AhmadNetwork Technician2020-06-08
7978Ijaz AhmadNetwork Technician2020-06-08
8079Shahzad ShafiqueDriver2020-08-24
8180Hassan MaqsoodTechnical Associate2020-10-08
8281Muhammad WaqasTechnical Associate2020-10-08
8382Muhammad NaeemTechnical Associate2020-10-20
8483Muhammad UsmanTechnical Associate2020-11-11
8584Muhammad Muneeb Ur RehmanNetwork Technician2024-02-01
8685Ramzan ShahTechnical Associate2021-06-21
8786Rashid Arshad AliSplicer2021-06-07
8887Muhammad Saeed KhanDriver2021-05-18
8988Waheed MahmoodTechnical Associate2021-07-23
9089Hafiz Muhammad ImtiazDriver2021-07-29
9190Abdullah KhalilExecutive - Deployment2024-02-21
9291Muhammad Tariq HanifAssociate Network Technician2021-09-13
9392Muhammad Naeem AnsariSupervisor - Deployment2024-02-13
9493Abdul Hannan AliAssociate Network Technician2021-09-28
9594Adeel AbbasSupervisior - QA2024-02-21
9695Malik Arham JaaSupervisior - QA2024-02-20
9796Faiz ur RehmanSupervisior - QA2024-02-21
9897Muhammad TayyabSupervisor - Deployment2024-01-29
9998Syed Muhammad MehdiTechnical Associate2021-12-08
10099Muhammad HussnainAssociate Network Technician2021-12-08
101100Rehan AliTechnical Support Associate2022-02-15
102101Muhammad Bilal AhmadNetwork Technician2022-02-07
103102Muhmmad FaizanSplicer2022-03-07
104103Saghir Ahmed BhattiTechnical Associate2022-02-23
105104Shahid ShoaibTechnical Associate2022-02-23
106105Amir MunirSplicer2022-02-23
107106Muhammad Daud MalikAssociate Network Technician2022-03-25
108107Muhammad NasirExecutive - Deployment2024-01-29
109108Ali HiraTechnical Associate2022-04-21
110109Muhammad Asim ShahzadSplicer2024-03-01
111110Syed Ali MurtazaTechnical Associate2022-04-21
112111Muhammad Zia UllahExecutive - Fiber Operations2024-04-03
113112Umair NawazTeam Lead - Deployment2024-01-29
114113Muhammad John RazaSupervisior - QA2022-05-06
115114M Ahsan Ahmed SiddiquiTechnician - Deployment2022-04-29
116115Muhammad ShoaibManager - Deployment2024-04-01
117116Muhammad Hamza ShahidSupervisior - QA2024-02-06
118117Ahsan JamilTeam Lead - Deployment2024-01-29
119118Maqsood ShahzadSupervisior - QA2022-05-06
120119Usama AbidSupervisior - QA2022-05-10
121120Muhammad ShahzaibTechnical Associate2022-04-16
122121Dawood AliTechnical Associate2022-04-20
123122Aneeq AhmadTechnical Associate2022-04-20
124123Asif AliSupervisior - QA2022-05-10
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:E2,A2:D288Expression=ISNUMBER(MATCH($B2,$F$2:$F$65,0))textNO
 
Upvote 0
Thanks a lot Sir,
It is working now through conditional formatting, before I select the wrong, I correct it is working now.
If I match Col-b with Col-F then what would the formula, not necessary to highlight need a formula.
 
Upvote 0
the match function gives you the row number (relative to the top of the search range) in the search range column.
Excel Formula:
=MATCH($B2,$F$2:$F$65,0)
 
Upvote 0
Thanks a lot Sir,it is working and giving the row number, so possible give the employee name ?
 
Upvote 0
Thanks a lot Sir,it is working and giving the row number, so possible give the employee name ?
This may work for 2021 excel, but unsure:
Excel Formula:
=XLOOKUP($B2,$F$2:$F$65,$F$2:$F$65,0)
If it does not work in 2021
Excel Formula:
 =INDEX($F$2:$F$65, MATCH($B2,$F$2:$F$65,0))

NOTE: I am really confused why you want to use the name to look up the name? You already have the name because it is your search criteria.
 
Upvote 0

Forum statistics

Threads
1,223,099
Messages
6,170,107
Members
452,302
Latest member
TaMere

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top