Good evening
I'm trying to get a string return into Field 8 instead of zero.
Any thoughts, please? Thanks!
V_String just means that it's text - and it needs to be in it's stored a "
Do you understand what my code does ? It basically says if you get a null, then another null, then a " then change the " to be "Missing".
It won't change the earlier records which is just one null then a "
Should your logic really be looking at prior records to determine the value ?
Is the data in the spreadsheet you attached the exact same as the file you're wanting to process ?
Can you create another sheet in the XLS file to show the results that you're after ? (& possibly explain the logic on each row?)
Cheers
I don't understand the logic, do you really need a multi-row formula ?
cmcclellan
This is a simplified version of my question.
When the data is missing, there are two null fields prior to a " symbol. Normally there is only 1 null field prior. Usually only 1 occurrence of this in 2000+ records but when it occurs, my fields are thrown off course
