Get values and data from another table in excel

hi Taislin, i had to change the header in K2 & M2 to be exactly like column G. there is of course a longer way to do the formula if you do not want the "de" word in both cells. but see if this is ok

Originally Posted by benishiryo

hi Taislin, i had to change the header in K2 & M2 to be exactly like column G. there is of course a longer way to do the formula if you do not want the "de" word in both cells. but see if this is ok

I was cheking your formulas again and after all they are not array formulas. Thas great cause in my file it thakes a lote time to the processor do the calculation and in your formula its lot more faster. But in your file there is still one problem because i want that the source data to be able of change and with that the filtered data change too. When i erase some data (from source) i get a lot of #VALUE. In my formula that doesn t happen but it takes a lot of time to do calculation. Check it:

My file(but takes a lote of time doing calculations): http://www.freefilehosting.net/testedebettingpand best thing is i can delete the data or input new one and i calculates the same thing

Your file and formula is fast but if i change data or delete some i gete error values