This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
1. The number of Fields which differ by number suffix(1,2,3..) is NOT FIXED. So sometimes, there can be just two fields, Type and Type2. But sometimes it can be Type ~ Type 10 with 10 columns.
2. I need to build a dynamic formula which IF TYPE is blank, then use the Type2 OR WHATEVER COLUMN THAT HAS A VALUE.
At least the good thing is there will always BE JUST ONE column that has A VALUE. There will not be two or more columns with values. IF one column has a value, then REST columns will ALWAYS be empty. Just that the number of columns are not fixed but changeable.