separate the numbers from the 4th position to the 12th position then locate within the 01 to 25
https://www.excelforum.com/attachmen...1&d=1579895560
separate the numbers from the 4th position to the 12th position then locate within the 01 to 25
https://www.excelforum.com/attachmen...1&d=1579895560
Q6 =TEXT(OFFSET($A6,0,4-2+COLUMNS($Q$5:Q5),1,1),"00")
AA6=IF(COUNTIF($P6:$Y6,AA$5)>0,"x","")
Copy and paste as needed
Last edited by PCI; 01-24-2020 at 05:10 PM.
- Battle without fear gives no glory - Just try
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks