nok

Hello Mr. Excel Friends, I have an excel sheet that keeps track of the status of some items, broken into OK or NOK status. I need a log of all NOK parts in another sheet, I have tried an index match function and successfully pulled the first match row of data (as in, it found the first NOK...

Hi all. I've created this simple code to help me move some data around. I'm trying to move data from Column C to Column D, E, F, etc when there is no text in a cell within Column B. See my code and example below. Sub Test() Dim rownum As Long Dim rowtext As Long Dim colmnltr As Long For...

Dear all I have a file that is automatic filled-out by 3rd-parties. This file contains a column containing dates that are displayed in mixed formats (mm/dd/yyyy) and (dd/mm/yyyy) and I wish to display them all in just one format (dd/mm/yyyy) – (brazilian). Any formula that will help me convert...

Dear Excel Fans, I can not find the formula or mutiple formulas for the following problem. I have to following excel sheet: I have an excel sheet in which multiple rows has the same number (ID number) these ID numbers are split in multiple groups for which we make a conclusion. I would...

Hey all, I have been looking for an answer to following match/lookup question: I have a column with recurring products and one with a status: Product A Ok Lookup /match column Product B NOk Product C Ok Product D Ok Product E NOK Product A Ok Product C NOK...