danovkos
07-08-2015, 12:33 AM
Hi,
pls. i have for me very hard problem.
I have e.g. about 20 columns. In this columns are amount. I want to search for numbers in columns but not in all columns and only in each third column.
With other words. I have columns KK:AB. In column BV i need first number, which formula will find from left side and in column BW i want other formula, which make the same but from right side. The next hard thing is, that i want not search in each column, but only in each third column. Exactly it means from column K then N, Q, T, W and Z.
Result will be when i copy the formula for whole column, in BV will first number from left sied and in BW i will have first number from right side. Left side means, that formula start search from K and right side start search from AB.
I tried it with hlookup, but it search also in every column :(.
Pls. any suggestions?
thx for any help.
pls. i have for me very hard problem.
I have e.g. about 20 columns. In this columns are amount. I want to search for numbers in columns but not in all columns and only in each third column.
With other words. I have columns KK:AB. In column BV i need first number, which formula will find from left side and in column BW i want other formula, which make the same but from right side. The next hard thing is, that i want not search in each column, but only in each third column. Exactly it means from column K then N, Q, T, W and Z.
Result will be when i copy the formula for whole column, in BV will first number from left sied and in BW i will have first number from right side. Left side means, that formula start search from K and right side start search from AB.
I tried it with hlookup, but it search also in every column :(.
Pls. any suggestions?
thx for any help.